APPS.AME_MIGRATION_REPORT dependencies on AME_APPROVAL_GROUP_ITEMS

Line 442: -- ame_approval_group_items

438: and (wf.expiration_date is null or
439: sysdate < wf.expiration_date)
440: and rownum < 2);
441: --
442: -- ame_approval_group_items
443: --
444: cursor c_grpItems_NoWfRoles is
445: select distinct grpitems.approval_group_id
446: ,parameter person_id

Line 448: from ame_approval_group_items grpitems

444: cursor c_grpItems_NoWfRoles is
445: select distinct grpitems.approval_group_id
446: ,parameter person_id
447: ,grp.name
448: from ame_approval_group_items grpitems
449: ,ame_approval_groups grp
450: where grpitems.parameter_name = ame_util.approverPersonId
451: and grp.approval_group_id = grpitems.approval_group_id
452: and grp.start_date = (select max(start_date)

Line 593: --ame_approval_group_items

589: and (wf.expiration_date is null or
590: sysdate < wf.expiration_date)
591: and rownum < 2);
592: --
593: --ame_approval_group_items
594: --
595: cursor c_migrated_grpItems is
596: select distinct grpitems.approval_group_id
597: ,substrb(parameter, instrb(parameter,'AME_MIGRATION_')+14) person_id

Line 600: from ame_approval_group_items grpitems

596: select distinct grpitems.approval_group_id
597: ,substrb(parameter, instrb(parameter,'AME_MIGRATION_')+14) person_id
598: ,parameter
599: ,grp.name
600: from ame_approval_group_items grpitems
601: ,ame_approval_groups grp
602: where grpitems.parameter_name = 'wf_roles_name'
603: and grp.approval_group_id = grpitems.approval_group_id
604: and grp.start_date = (select max(start_date)

Line 729: --ame_approval_group_items

725: where cond.parameter_one in ('any_approver_user_id','final_approver_user_id')
726: and fnd.employee_id is not null
727: and cond.parameter_two = to_char(fnd.user_id);
728: --
729: --ame_approval_group_items
730: --
731: cursor c_grpItems_InvalidUser is
732: select distinct grp.name
733: ,grpitems.parameter user_id

Line 736: from ame_approval_group_items grpitems

732: select distinct grp.name
733: ,grpitems.parameter user_id
734: ,fnd.employee_id person_id
735: ,fnd.user_name
736: from ame_approval_group_items grpitems
737: ,ame_approval_groups grp
738: ,fnd_user fnd
739: where grpitems.parameter_name = 'user_id'
740: and fnd.employee_id is not null

Line 839: --ame_approval_group_items - to be migrated

835: ,description => lmConditionDesc
836: ,approvers => approversToBeMigrated);
837: end loop;
838: --
839: --ame_approval_group_items - to be migrated
840: --
841: for r in c_grpItems_NoWfRoles loop
842: addApprover(id => r.person_id
843: ,source => 'ame_approval_group_items'

Line 843: ,source => 'ame_approval_group_items'

839: --ame_approval_group_items - to be migrated
840: --
841: for r in c_grpItems_NoWfRoles loop
842: addApprover(id => r.person_id
843: ,source => 'ame_approval_group_items'
844: ,source_object => 'approval_group_id : '||r.approval_group_id
845: ,description => r.name
846: ,approvers => approversToBeMigrated);
847: end loop;

Line 932: --ame_approval_group_items - already migrated

928: ,description => lmConditionDesc
929: ,approvers => migratedApprovers);
930: end loop;
931: --
932: --ame_approval_group_items - already migrated
933: --
934: for r in c_migrated_grpItems loop
935: addApprover(id => r.person_id
936: ,source => 'ame_approval_group_items'

Line 936: ,source => 'ame_approval_group_items'

932: --ame_approval_group_items - already migrated
933: --
934: for r in c_migrated_grpItems loop
935: addApprover(id => r.person_id
936: ,source => 'ame_approval_group_items'
937: ,source_object => 'approval_group_id : '||r.approval_group_id
938: ,description => r.name
939: ,approvers => migratedApprovers);
940: end loop;

Line 1048: --ame_approval_group_items

1044: ,description => null
1045: ,approvers => invalidUsers);
1046: end loop;
1047: --
1048: --ame_approval_group_items
1049: --
1050: for r in c_grpItems_InvalidUser loop
1051: addApprover(id => r.person_id
1052: ,user_id => r.user_id

Line 1054: ,source => 'ame_approval_group_items'

1050: for r in c_grpItems_InvalidUser loop
1051: addApprover(id => r.person_id
1052: ,user_id => r.user_id
1053: ,user_name => r.user_name
1054: ,source => 'ame_approval_group_items'
1055: ,source_object => 'group_name:'||r.name
1056: ,description => null
1057: ,approvers => invalidUsers);
1058: end loop;