APPS.AME_MIGRATION_REPORT dependencies on AME_TEMP_INSERTIONS

Line 412: -- ame_temp_insertions

408: and (wf.expiration_date is null or
409: sysdate < wf.expiration_date)
410: and rownum < 2);
411: --
412: -- ame_temp_insertions
413: --
414: cursor c_insAppr_NoWfRoles is
415: select distinct ins.person_id person_id
416: from ame_temp_insertions ins

Line 416: from ame_temp_insertions ins

412: -- ame_temp_insertions
413: --
414: cursor c_insAppr_NoWfRoles is
415: select distinct ins.person_id person_id
416: from ame_temp_insertions ins
417: where ins.person_id is not null
418: and not exists (select null from wf_roles wf
419: where wf.orig_system_id = ins.person_id
420: and wf.orig_system = 'PER'

Line 558: --ame_temp_insertions

554: sysdate < wf.expiration_date)
555: and name like 'AME_MIGRATION%'
556: and rownum < 2);
557: --
558: --ame_temp_insertions
559: --
560: cursor c_migrated_insAppr is
561: select distinct ins.person_id person_id
562: from ame_temp_insertions ins

Line 562: from ame_temp_insertions ins

558: --ame_temp_insertions
559: --
560: cursor c_migrated_insAppr is
561: select distinct ins.person_id person_id
562: from ame_temp_insertions ins
563: where ins.person_id is not null
564: and exists (select null
565: from wf_roles wf
566: where wf.orig_system_id = ins.person_id

Line 703: --ame_temp_insertions

699: and del.person_id is null
700: and fnd.employee_id is not null
701: and fnd.user_id = del.user_id;
702: --
703: --ame_temp_insertions
704: --
705: cursor c_insAppr_InvalidUser is
706: select distinct ins.user_id user_id
707: ,fnd.employee_id person_id

Line 709: from ame_temp_insertions ins

705: cursor c_insAppr_InvalidUser is
706: select distinct ins.user_id user_id
707: ,fnd.employee_id person_id
708: ,fnd.user_name
709: from ame_temp_insertions ins
710: ,fnd_user fnd
711: where ins.user_id is not null
712: and ins.person_id is null
713: and fnd.employee_id is not null

Line 879: -- ame_temp_insertions - to be migrated

875: ,description => 'n/a'
876: ,approvers => approversToBeMigrated);
877: end loop;
878: --
879: -- ame_temp_insertions - to be migrated
880: --
881: for r in c_insAppr_NoWfRoles loop
882: addApprover(id => r.person_id
883: ,source => 'ame_temp_insertions'

Line 883: ,source => 'ame_temp_insertions'

879: -- ame_temp_insertions - to be migrated
880: --
881: for r in c_insAppr_NoWfRoles loop
882: addApprover(id => r.person_id
883: ,source => 'ame_temp_insertions'
884: ,source_object => 'n/a'
885: ,description => 'n/a'
886: ,approvers => approversToBeMigrated);
887: end loop;

Line 972: -- ame_temp_insertions - already migrated

968: ,description => 'n/a'
969: ,approvers => migratedApprovers);
970: end loop;
971: --
972: -- ame_temp_insertions - already migrated
973: --
974: for r in c_migrated_insAppr loop
975: addApprover(id => r.person_id
976: ,source => 'ame_temp_insertions'

Line 976: ,source => 'ame_temp_insertions'

972: -- ame_temp_insertions - already migrated
973: --
974: for r in c_migrated_insAppr loop
975: addApprover(id => r.person_id
976: ,source => 'ame_temp_insertions'
977: ,source_object => 'n/a'
978: ,description => 'n/a'
979: ,approvers => migratedApprovers);
980: end loop;

Line 1024: --ame_temp_insertions

1020: ,description => null
1021: ,approvers => invalidUsers);
1022: end loop;
1023: --
1024: --ame_temp_insertions
1025: --
1026: for r in c_insAppr_InvalidUser loop
1027: addApprover(id => r.person_id
1028: ,user_id => r.user_id

Line 1031: ,source_object => 'ame_temp_insertions'

1027: addApprover(id => r.person_id
1028: ,user_id => r.user_id
1029: ,user_name => r.user_name
1030: ,source => 'AME Runtime Table'
1031: ,source_object => 'ame_temp_insertions'
1032: ,description => null
1033: ,approvers => invalidUsers);
1034: end loop;
1035: --