| |
1 |
1 |
|
| |
2 |
2 |
|
| |
3 |
3 |
|
| |
4 |
4 |
|
| |
5 |
5 |
|
| |
6 |
|
|
| |
7 |
6 |
|
| |
8 |
7 |
|
| |
9 |
8 |
|
| |
10 |
9 |
create or replace function etp__get_folder_id (integer) |
| |
11 |
10 |
returns integer as ' |
| |
12 |
11 |
declare |
| |
13 |
12 |
p_package_id alias for $1; |
| |
14 |
13 |
v_folder_id integer; |
| |
15 |
14 |
v_parent_id integer; |
| |
16 |
15 |
begin |
| |
17 |
16 |
select folder_id into v_folder_id |
| |
18 |
17 |
from cr_folders |
| |
19 |
18 |
where package_id = p_package_id; |
| |
20 |
19 |
if not found then |
| |
21 |
20 |
select parent_id into v_parent_id |
| |
22 |
21 |
from site_nodes |
| |
23 |
22 |
where object_id = p_package_id; |
| |
24 |
23 |
if found and v_parent_id is null then |
| |
25 |
24 |
v_folder_id := content_item_globals.c_root_folder_id; |
| |
26 |
25 |
else |
