APPS.AME_MIGRATION_REPORT dependencies on AME_APPROVAL_GROUP_MEMBERS

Line 463: -- ame_approval_group_members

459: and (wf.expiration_date is null or
460: sysdate < wf.expiration_date)
461: and rownum < 2);
462: --
463: -- ame_approval_group_members
464: --
465: cursor c_grpMem_NoWfRoles is
466: select distinct grpmem.approval_group_id
467: ,grpmem.parameter person_id

Line 469: from ame_approval_group_members grpmem

465: cursor c_grpMem_NoWfRoles is
466: select distinct grpmem.approval_group_id
467: ,grpmem.parameter person_id
468: ,grp.name
469: from ame_approval_group_members grpmem
470: ,ame_approval_groups grp
471: where grpmem.parameter_name = ame_util.approverPersonId
472: and grp.approval_group_id = grpmem.approval_group_id
473: and grp.start_date = (select max(start_date)

Line 616: --ame_approval_group_members

612: and (wf.expiration_date is null or
613: sysdate < wf.expiration_date)
614: and rownum < 2);
615: --
616: --ame_approval_group_members
617: --
618: cursor c_migrated_grpMem is
619: select distinct grpmem.approval_group_id
620: ,substrb(grpmem.parameter,instrb(grpmem.parameter,'AME_MIGRATION_')+14) person_id

Line 623: from ame_approval_group_members grpmem

619: select distinct grpmem.approval_group_id
620: ,substrb(grpmem.parameter,instrb(grpmem.parameter,'AME_MIGRATION_')+14) person_id
621: ,grpmem.parameter
622: ,grp.name
623: from ame_approval_group_members grpmem
624: ,ame_approval_groups grp
625: where grpmem.parameter_name = 'wf_roles_name'
626: and grp.approval_group_id = grpmem.approval_group_id
627: and grp.start_date = (select max(start_date)

Line 747: --ame_approval_group_members

743: and grp.start_date = (select max(start_date)
744: from ame_approval_groups
745: where approval_group_id = grp.approval_group_id);
746: --
747: --ame_approval_group_members
748: --
749: cursor c_grpMem_InvalidUser is
750: select distinct grp.name
751: ,grpmems.parameter user_id

Line 754: from ame_approval_group_members grpmems

750: select distinct grp.name
751: ,grpmems.parameter user_id
752: ,fnd.employee_id person_id
753: ,fnd.user_name
754: from ame_approval_group_members grpmems
755: ,ame_approval_groups grp
756: ,fnd_user fnd
757: where grpmems.parameter_name = 'user_id'
758: and fnd.employee_id is not null

Line 849: --ame_approval_group_members - to be migrated

845: ,description => r.name
846: ,approvers => approversToBeMigrated);
847: end loop;
848: --
849: --ame_approval_group_members - to be migrated
850: --
851: for r in c_grpMem_NoWfRoles loop
852: addApprover(id => r.person_id
853: ,source => 'ame_approval_group_members'

Line 853: ,source => 'ame_approval_group_members'

849: --ame_approval_group_members - to be migrated
850: --
851: for r in c_grpMem_NoWfRoles loop
852: addApprover(id => r.person_id
853: ,source => 'ame_approval_group_members'
854: ,source_object => 'approval_group_id : '||r.approval_group_id
855: ,description => r.name
856: ,approvers => approversToBeMigrated);
857: end loop;

Line 942: --ame_approval_group_members - already migrated

938: ,description => r.name
939: ,approvers => migratedApprovers);
940: end loop;
941: --
942: --ame_approval_group_members - already migrated
943: --
944: for r in c_migrated_grpMem loop
945: addApprover(id => r.person_id
946: ,source => 'ame_approval_group_members'

Line 946: ,source => 'ame_approval_group_members'

942: --ame_approval_group_members - already migrated
943: --
944: for r in c_migrated_grpMem loop
945: addApprover(id => r.person_id
946: ,source => 'ame_approval_group_members'
947: ,source_object => 'approval_group_id : '||r.approval_group_id
948: ,description => r.name
949: ,approvers => migratedApprovers);
950: end loop;

Line 1060: --ame_approval_group_members

1056: ,description => null
1057: ,approvers => invalidUsers);
1058: end loop;
1059: --
1060: --ame_approval_group_members
1061: --
1062: for r in c_grpMem_InvalidUser loop
1063: addApprover(id => r.person_id
1064: ,user_id => r.user_id

Line 1066: ,source => 'ame_approval_group_members'

1062: for r in c_grpMem_InvalidUser loop
1063: addApprover(id => r.person_id
1064: ,user_id => r.user_id
1065: ,user_name => r.user_name
1066: ,source => 'ame_approval_group_members'
1067: ,source_object => 'group_name:'||r.name
1068: ,description => null
1069: ,approvers => invalidUsers);
1070: end loop;