APPS.AME_MIGRATION_REPORT dependencies on AME_TEMP_DELETIONS

Line 398: -- ame_temp_deletions

394: and (wf.expiration_date is null or
395: sysdate < wf.expiration_date)
396: and rownum < 2);
397: --
398: -- ame_temp_deletions
399: --
400: cursor c_delAppr_NoWfRoles is
401: select distinct del.person_id person_id
402: from ame_temp_deletions del

Line 402: from ame_temp_deletions del

398: -- ame_temp_deletions
399: --
400: cursor c_delAppr_NoWfRoles is
401: select distinct del.person_id person_id
402: from ame_temp_deletions del
403: where del.person_id is not null
404: and not exists (select null from wf_roles wf
405: where wf.orig_system_id = del.person_id
406: and wf.orig_system = 'PER'

Line 542: --ame_temp_deletions

538: sysdate < wf.expiration_date)
539: and name like 'AME_MIGRATION%'
540: and rownum < 2);
541: --
542: --ame_temp_deletions
543: --
544: cursor c_migrated_delAppr is
545: select distinct del.person_id person_id
546: from ame_temp_deletions del

Line 546: from ame_temp_deletions del

542: --ame_temp_deletions
543: --
544: cursor c_migrated_delAppr is
545: select distinct del.person_id person_id
546: from ame_temp_deletions del
547: where del.person_id is not null
548: and exists (select null
549: from wf_roles wf
550: where wf.orig_system_id = del.person_id

Line 690: --ame_temp_deletions

686: and oldappr.person_id is null
687: and fnd.employee_id is not null
688: and oldappr.user_id = fnd.user_id;
689: --
690: --ame_temp_deletions
691: --
692: cursor c_delAppr_InvalidUser is
693: select distinct del.user_id user_id
694: ,fnd.employee_id person_id

Line 696: from ame_temp_deletions del

692: cursor c_delAppr_InvalidUser is
693: select distinct del.user_id user_id
694: ,fnd.employee_id person_id
695: ,fnd.user_name
696: from ame_temp_deletions del
697: ,fnd_user fnd
698: where del.user_id is not null
699: and del.person_id is null
700: and fnd.employee_id is not null

Line 869: --ame_temp_deletions - to be migrated

865: ,description => r.description
866: ,approvers => approversToBeMigrated);
867: end loop;
868: --
869: --ame_temp_deletions - to be migrated
870: --
871: for r in c_delAppr_NoWfRoles loop
872: addApprover(id => r.person_id
873: ,source => 'ame_temp_deletions'

Line 873: ,source => 'ame_temp_deletions'

869: --ame_temp_deletions - to be migrated
870: --
871: for r in c_delAppr_NoWfRoles loop
872: addApprover(id => r.person_id
873: ,source => 'ame_temp_deletions'
874: ,source_object => 'n/a'
875: ,description => 'n/a'
876: ,approvers => approversToBeMigrated);
877: end loop;

Line 962: --ame_temp_deletions - already migrated

958: ,description => r.description
959: ,approvers => migratedApprovers);
960: end loop;
961: --
962: --ame_temp_deletions - already migrated
963: --
964: for r in c_migrated_delAppr loop
965: addApprover(id => r.person_id
966: ,source => 'ame_temp_deletions'

Line 966: ,source => 'ame_temp_deletions'

962: --ame_temp_deletions - already migrated
963: --
964: for r in c_migrated_delAppr loop
965: addApprover(id => r.person_id
966: ,source => 'ame_temp_deletions'
967: ,source_object => 'n/a'
968: ,description => 'n/a'
969: ,approvers => migratedApprovers);
970: end loop;

Line 1012: --ame_temp_deletions

1008: ,description => null
1009: ,approvers => invalidUsers);
1010: end loop;
1011: --
1012: --ame_temp_deletions
1013: --
1014: for r in c_delAppr_InvalidUser loop
1015: addApprover(id => r.person_id
1016: ,user_id => r.user_id

Line 1019: ,source_object => 'ame_temp_deletions'

1015: addApprover(id => r.person_id
1016: ,user_id => r.user_id
1017: ,user_name => r.user_name
1018: ,source => 'AME Runtime Table'
1019: ,source_object => 'ame_temp_deletions'
1020: ,description => null
1021: ,approvers => invalidUsers);
1022: end loop;
1023: --