APPS.AME_MIGRATION_REPORT dependencies on AME_CONDITIONS

Line 426: -- ame_conditions - LM

422: and (wf.expiration_date is null or
423: sysdate < wf.expiration_date)
424: and rownum < 2);
425: --
426: -- ame_conditions - LM
427: --
428: cursor c_condPerson_NoWfRoles is
429: select distinct cond.condition_id
430: ,cond.parameter_one

Line 432: from ame_conditions cond

428: cursor c_condPerson_NoWfRoles is
429: select distinct cond.condition_id
430: ,cond.parameter_one
431: ,cond.parameter_two person_id
432: from ame_conditions cond
433: where cond.parameter_one in ('any_approver_person_id','final_approver_person_id')
434: and not exists (select null from wf_roles wf
435: where wf.orig_system_id = cond.parameter_two
436: and wf.orig_system = 'PER'

Line 574: -- ame_conditions - LM

570: sysdate < wf.expiration_date)
571: and name like 'AME_MIGRATION%'
572: and rownum < 2);
573: --
574: -- ame_conditions - LM
575: --
576: cursor c_migrated_condPerson is
577: select distinct cond.condition_id
578: ,cond.parameter_one

Line 581: from ame_conditions cond

577: select distinct cond.condition_id
578: ,cond.parameter_one
579: ,substrb(cond.parameter_two, instrb(cond.parameter_two,'AME_MIGRATION_')+14) person_id
580: ,cond.parameter_two
581: from ame_conditions cond
582: where cond.parameter_one in ('any_approver','final_approver')
583: and cond.parameter_two like 'AME_MIGRATION%'
584: and exists (select null
585: from wf_roles wf

Line 716: --ame_conditions - LM

712: and ins.person_id is null
713: and fnd.employee_id is not null
714: and fnd.user_id = ins.user_id;
715: --
716: --ame_conditions - LM
717: --
718: cursor c_condUser_InvalidUser is
719: select distinct condition_id
720: ,cond.parameter_two user_id

Line 723: from ame_conditions cond

719: select distinct condition_id
720: ,cond.parameter_two user_id
721: ,fnd.employee_id person_id
722: ,fnd.user_name
723: from ame_conditions cond
724: ,fnd_user fnd
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);

Line 824: --ame_conditions - to be migrated

820: ,description => 'n/a'
821: ,approvers => approversToBeMigrated);
822: end loop;
823: --
824: --ame_conditions - to be migrated
825: --
826: for r in c_condPerson_NoWfRoles loop
827: if r.parameter_one = 'any_approver_person_id' then
828: lmConditionDesc := 'Any approver is person';

Line 833: ,source => 'ame_conditions'

829: else --final_approver_person_id
830: lmConditionDesc := 'The final approver is person';
831: end if;
832: addApprover(id => r.person_id
833: ,source => 'ame_conditions'
834: ,source_object => 'condition_id : '||r.condition_id
835: ,description => lmConditionDesc
836: ,approvers => approversToBeMigrated);
837: end loop;

Line 917: --ame_conditions - already migrated

913: ,description => 'n/a'
914: ,approvers => migratedApprovers);
915: end loop;
916: --
917: --ame_conditions - already migrated
918: --
919: for r in c_migrated_condPerson loop
920: if r.parameter_one = 'any_approver' then
921: lmConditionDesc := 'Any approver is person';

Line 926: ,source => 'ame_conditions'

922: else --final_approver
923: lmConditionDesc := 'The final approver is person';
924: end if;
925: addApprover(id => r.person_id
926: ,source => 'ame_conditions'
927: ,source_object => 'condition_id : '||r.condition_id
928: ,description => lmConditionDesc
929: ,approvers => migratedApprovers);
930: end loop;

Line 1036: --ame_conditions

1032: ,description => null
1033: ,approvers => invalidUsers);
1034: end loop;
1035: --
1036: --ame_conditions
1037: --
1038: for r in c_condUser_InvalidUser loop
1039: addApprover(id => r.person_id
1040: ,user_id => r.user_id

Line 1042: ,source => 'ame_conditions'

1038: for r in c_condUser_InvalidUser loop
1039: addApprover(id => r.person_id
1040: ,user_id => r.user_id
1041: ,user_name => r.user_name
1042: ,source => 'ame_conditions'
1043: ,source_object => 'condition_id:'||r.condition_id
1044: ,description => null
1045: ,approvers => invalidUsers);
1046: end loop;