APPS.AME_MIGRATION_REPORT dependencies on AME_CONFIG_VARS

Line 484: -- ame_config_vars (adminApprover)

480: and (wf.expiration_date is null or
481: sysdate < wf.expiration_date)
482: and rownum < 2);
483: --
484: -- ame_config_vars (adminApprover)
485: --
486: cursor c_configVar_NoWfRoles is
487: select substrb(config1.variable_value, 11, instrb(config1.variable_value,',')-11) person_id
488: from ame_config_vars config1

Line 488: from ame_config_vars config1

484: -- ame_config_vars (adminApprover)
485: --
486: cursor c_configVar_NoWfRoles is
487: select substrb(config1.variable_value, 11, instrb(config1.variable_value,',')-11) person_id
488: from ame_config_vars config1
489: where config1.variable_name = 'adminApprover'
490: and config1.variable_value like 'person_id%'
491: and not exists (select null from ame_config_vars config2
492: where config2.rowid = config1.rowid

Line 491: and not exists (select null from ame_config_vars config2

487: select substrb(config1.variable_value, 11, instrb(config1.variable_value,',')-11) person_id
488: from ame_config_vars config1
489: where config1.variable_name = 'adminApprover'
490: and config1.variable_value like 'person_id%'
491: and not exists (select null from ame_config_vars config2
492: where config2.rowid = config1.rowid
493: --and config2.variable_value like 'person_id:,user_id%'
494: and substrb(config2.variable_value,1,12) in ('person_id:,u','person_id:0,'))
495: and not exists (select null from wf_roles wf

Line 639: --ame_config_vars (adminApprover)

635: and (wf.expiration_date is null or
636: sysdate < wf.expiration_date)
637: and rownum < 2);
638: --
639: --ame_config_vars (adminApprover)
640: --
641: cursor c_migrated_configVar is
642: select substrb(config1.variable_value, instrb(config1.variable_value,'AME_MIGRATION_')+14) person_id
643: from ame_config_vars config1

Line 643: from ame_config_vars config1

639: --ame_config_vars (adminApprover)
640: --
641: cursor c_migrated_configVar is
642: select substrb(config1.variable_value, instrb(config1.variable_value,'AME_MIGRATION_')+14) person_id
643: from ame_config_vars config1
644: where config1.variable_name = 'adminApprover'
645: and config1.variable_value like 'AME_MIGRATION%'
646: and exists (select null from wf_roles wf
647: where name = config1.variable_value

Line 765: --ame_config_vars (adminApprover)

761: and grp.start_date = (select max(start_date)
762: from ame_approval_groups
763: where approval_group_id = grp.approval_group_id);
764: --
765: --ame_config_vars (adminApprover)
766: --
767: cursor c_configVar_InvalidUser is
768: select distinct substrb(config1.variable_value, instrb(config1.variable_value,':',-1)+1 ) user_id
769: ,fnd.employee_id person_id

Line 771: from ame_config_vars config1

767: cursor c_configVar_InvalidUser is
768: select distinct substrb(config1.variable_value, instrb(config1.variable_value,':',-1)+1 ) user_id
769: ,fnd.employee_id person_id
770: ,fnd.user_name
771: from ame_config_vars config1
772: ,fnd_user fnd
773: where config1.variable_name = 'adminApprover'
774: and config1.variable_value like 'person_id:%'
775: and lengthb(substrb(config1.variable_value, instrb(config1.variable_value,':',-1)+1 )) > 0

Line 814: --ame_config_vars - to be migrated

810: --
811: -- ************* Approvers To be Migrated *************
812: --
813: --
814: --ame_config_vars - to be migrated
815: --
816: for r in c_configVar_NoWfRoles loop
817: addApprover(id => r.person_id
818: ,source => 'ame_config_vars'

Line 818: ,source => 'ame_config_vars'

814: --ame_config_vars - to be migrated
815: --
816: for r in c_configVar_NoWfRoles loop
817: addApprover(id => r.person_id
818: ,source => 'ame_config_vars'
819: ,source_object => 'n/a'
820: ,description => 'n/a'
821: ,approvers => approversToBeMigrated);
822: end loop;

Line 907: --ame_config_vars - already migrated

903: -- ************ Approvers - Already Migrated ************
904: --
905: if is11510Applied is not null then
906: --
907: --ame_config_vars - already migrated
908: --
909: for r in c_migrated_configVar loop
910: addApprover(id => r.person_id
911: ,source => 'ame_config_vars'

Line 911: ,source => 'ame_config_vars'

907: --ame_config_vars - already migrated
908: --
909: for r in c_migrated_configVar loop
910: addApprover(id => r.person_id
911: ,source => 'ame_config_vars'
912: ,source_object => 'n/a'
913: ,description => 'n/a'
914: ,approvers => migratedApprovers);
915: end loop;

Line 1072: --ame_config_vars (adminApprover)

1068: ,description => null
1069: ,approvers => invalidUsers);
1070: end loop;
1071: --
1072: --ame_config_vars (adminApprover)
1073: --
1074: for r in c_configVar_InvalidUser loop
1075: addApprover(id => r.person_id
1076: ,user_id => r.user_id

Line 1079: ,source_object => 'ame_config_vars'

1075: addApprover(id => r.person_id
1076: ,user_id => r.user_id
1077: ,user_name => r.user_name
1078: ,source => 'AME Configuration Table'
1079: ,source_object => 'ame_config_vars'
1080: ,description => null
1081: ,approvers => invalidUsers);
1082: end loop;
1083: --