APPS.AMW_PROC_APPROVAL_PKG dependencies on AMW_APPROVED_HIERARCHIES

Line 444: insert into amw_approved_hierarchies(

440: connect by prior child_process_id = parent_process_id);
441: BEGIN
442: if ( (p_step = 1) or (p_step = 0) ) then
443: for a_link in c1 loop
444: insert into amw_approved_hierarchies(
445: organization_id,
446: parent_id,
447: child_id,
448: start_date,

Line 474: update amw_approved_hierarchies

470: end if;
471:
472: if p_step = 2 then
473: for defunct_link in c2 loop
474: update amw_approved_hierarchies
475: set end_date = APPROV_TXN_DATE,
476: object_version_number = object_version_number + 1
477: where organization_id = -1
478: and parent_id = defunct_link.parent_process_id

Line 486: update amw_approved_hierarchies

482: end if;
483:
484: if ( (p_step = 1) or (p_step = 3) ) then
485: for defunct_link in c3 loop
486: update amw_approved_hierarchies
487: set end_date = APPROV_TXN_DATE,
488: object_version_number = object_version_number + 1
489: where organization_id = -1
490: and parent_id = defunct_link.parent_process_id

Line 500: insert into amw_approved_hierarchies(

496: ---05.11.2005 npanandi: added below step to club the above actions
497: ---when calling this procedure from WebADI
498: if(p_step=4) then
499: for a_link in c1 loop
500: insert into amw_approved_hierarchies(
501: organization_id,
502: parent_id,
503: child_id,
504: start_date,

Line 528: update amw_approved_hierarchies

524: );
525: end loop;
526:
527: for defunct_link in c2_1 loop
528: update amw_approved_hierarchies
529: set end_date = APPROV_TXN_DATE
530: ,object_version_number = object_version_number + 1
531: ,last_update_date = sysdate
532: ,last_updated_by = G_USER_ID

Line 541: update amw_approved_hierarchies

537: and end_date is null;
538: end loop;
539:
540: for defunct_link in c3 loop
541: update amw_approved_hierarchies
542: set end_date = APPROV_TXN_DATE,
543: object_version_number = object_version_number + 1
544: ,last_update_date = sysdate
545: ,last_updated_by = G_USER_ID