APPS.AMW_PROC_ORG_APPROVAL_PKG dependencies on AMW_APPROVED_HIERARCHIES

Line 156: -- write into amw_approved_hierarchies

152:
153:
154: -- process approved: update amw_process, change status to A
155: -- unlock process(es)
156: -- write into amw_approved_hierarchies
157: -- update the association_tables
158: -- update amw_proc_hierarchy_denorm table where hierarchy_type = 'A'
159: procedure approve(p_process_id in number, p_org_id in number,
160: p_update_count in varchar2 := FND_API.G_TRUE) is

Line 650: insert into amw_approved_hierarchies

646: end if;
647: if ( (p_step = 1) or (p_step = 0) ) then
648: /* kosriniv
649: for a_link in c1 loop
650: insert into amw_approved_hierarchies
651: (organization_id,
652: parent_id,
653: child_id,
654: start_date,

Line 681: insert into amw_approved_hierarchies

677: added_rows(p_org_id);
678: if(x_parent_tbl.exists(1)) then
679:
680: forall i in x_parent_tbl.first .. x_parent_tbl.last
681: insert into amw_approved_hierarchies
682: (organization_id,
683: parent_id,
684: child_id,
685: start_date,

Line 717: update amw_approved_hierarchies

713: -- and checked for concurrency here.
714:
715: if p_step = 2 then
716: for defunct_link in c2 loop
717: update amw_approved_hierarchies
718: set end_date = APPROV_TXN_DATE,
719: object_version_number = object_version_number + 1
720: where organization_id = p_org_id
721: and parent_id = defunct_link.parent_process_id

Line 730: update amw_approved_hierarchies

726:
727: if ( (p_step = 1) or (p_step = 3) ) then
728: /* kosriniv commenting
729: for defunct_link in c3 loop
730: update amw_approved_hierarchies
731: set end_date = APPROV_TXN_DATE,
732: object_version_number = object_version_number + 1
733: where organization_id = p_org_id
734: and parent_id = defunct_link.parent_process_id

Line 741: update amw_approved_hierarchies

737: end loop;
738: */ invalid_rows(p_org_id);
739: if(x_parent_tbl.exists(1)) then
740: forall i in x_parent_tbl.first .. x_parent_tbl.last
741: update amw_approved_hierarchies
742: set end_date = APPROV_TXN_DATE,
743: object_version_number = object_version_number + 1
744: where organization_id = p_org_id
745: and parent_id = x_parent_tbl(i)

Line 1237: from amw_approved_hierarchies ah

1233: and ah.organization_id = l_org_id;
1234:
1235: cursor c_all_approved_links_org(l_org_id in number) is
1236: select ah.parent_id , ah.child_id
1237: from amw_approved_hierarchies ah
1238: where ah.parent_id =(select pp.process_id
1239: from amw_process_organization pp
1240: where pp.organization_id = ah.organization_id
1241: and pp.process_id = ah.parent_id

Line 1322: from amw_approved_hierarchies ah

1318: procedure invalid_rows(p_org_id IN NUMBER) IS
1319:
1320: cursor c_all_approved_links_org(l_org_id in number) is
1321: select ah.parent_id , ah.child_id
1322: from amw_approved_hierarchies ah
1323: where ah.parent_id =(select pp.process_id
1324: from amw_process_organization pp
1325: where pp.organization_id = ah.organization_id
1326: and pp.process_id = ah.parent_id