APPS.AMW_RL_HIERARCHY_PKG dependencies on AMW_APPROVED_HIERARCHIES

Line 393: from amw_approved_hierarchies

389: is
390:
391: cursor c_all_approved_links_rl is
392: select parent_id, child_id
393: from amw_approved_hierarchies
394: where (organization_id is null or organization_id = -1)
395: and (end_date is null or end_date > l_sysdate);
396:
397: cursor c_all_approved_links_org(l_org_id in number) is

Line 399: from amw_approved_hierarchies

395: and (end_date is null or end_date > l_sysdate);
396:
397: cursor c_all_approved_links_org(l_org_id in number) is
398: select parent_id, child_id
399: from amw_approved_hierarchies
400: where (organization_id = l_org_id) and
401: (end_date is null or end_date > l_sysdate);
402:
403: str varchar2(50);

Line 1069: select 1 into l_dummy from amw_approved_hierarchies

1065: l_dummy pls_integer;
1066:
1067: begin
1068:
1069: select 1 into l_dummy from amw_approved_hierarchies
1070: where parent_id = p_parent_id
1071: and child_id = p_child_id
1072: and end_date is null
1073: and ((-1 = p_org_id and (organization_id is null or organization_id = -1)) OR

Line 1076: update amw_approved_hierarchies set

1072: and end_date is null
1073: and ((-1 = p_org_id and (organization_id is null or organization_id = -1)) OR
1074: (p_org_id <> -1 and organization_id = p_org_id));
1075:
1076: update amw_approved_hierarchies set
1077: last_update_date = sysdate,
1078: last_updated_by = G_USER_ID,
1079: last_update_login = G_LOGIN_ID,
1080: child_order_number = p_instance_id,

Line 1265: insert into amw_approved_hierarchies

1261: if(l_approval_status = 'A' and p_parent_process_id = -1)
1262:
1263: then
1264: for a_link in c1 loop
1265: insert into amw_approved_hierarchies
1266: (organization_id,
1267: parent_id,
1268: child_id,
1269: start_date,

Line 1483: select 1 into l_dummy from amw_approved_hierarchies

1479: * the conditions is
1480: * The process is present under -1 in the approved hierarchy
1481: */
1482: begin
1483: select 1 into l_dummy from amw_approved_hierarchies
1484: where (organization_id is null or organization_id = -1)
1485: and parent_id = -1
1486: and child_id = p_child_process_id
1487: and end_date is null;

Line 1489: delete from amw_approved_hierarchies

1485: and parent_id = -1
1486: and child_id = p_child_process_id
1487: and end_date is null;
1488:
1489: delete from amw_approved_hierarchies
1490: where parent_id = -1
1491: and child_id = p_child_process_id
1492: and (organization_id is null or organization_id = -1)
1493: and end_date is null;

Line 1497: update amw_approved_hierarchies

1493: and end_date is null;
1494:
1495: /* run a cursor to remove defunct links */
1496: for defunct_link in c3 loop
1497: update amw_approved_hierarchies
1498: set end_date = l_sysdate,
1499: object_version_number = object_version_number + 1
1500: where (organization_id is null or organization_id = -1)
1501: and parent_id = defunct_link.parent_process_id

Line 2200: insert into amw_approved_hierarchies

2196: if(l_approval_status = 'A')
2197: then
2198: /* add link to approved hierarchy if not already there ... */
2199: for a_link in c1 loop
2200: insert into amw_approved_hierarchies
2201: (organization_id,
2202: parent_id,
2203: child_id,
2204: start_date,

Line 2626: insert into amw_approved_hierarchies

2622: if(l_approval_status = 'A' and p_parent_process_id = -1)
2623:
2624: then
2625: for a_link in c1 loop
2626: insert into amw_approved_hierarchies
2627: (organization_id,
2628: parent_id,
2629: child_id,
2630: start_date,

Line 3641: from amw_approved_hierarchies

3637:
3638: begin
3639: select child_id
3640: into l_dummy
3641: from amw_approved_hierarchies
3642: where parent_id = p_process_id
3643: and (organization_id is null or organization_id = -1)
3644: and (end_date is null or end_date > sysdate)
3645: and child_id not in

Line 3660: from amw_approved_hierarchies

3656: where parent_id = p_process_id
3657: and (organization_id is null or organization_id = -1)
3658: and child_id not in
3659: (select child_id
3660: from amw_approved_hierarchies
3661: where parent_id = p_process_id
3662: and (organization_id is null or organization_id = -1)
3663: and (end_date is null or end_date > sysdate));
3664: exception