eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_AME_APPROVAL_LIST dependencies on WF_ROLES

Line 286: -- retrieve the name from wf_roles table for the given orig_system and orig_system_id values.

282: tmpApprover.item_id := currentFirstApprover.item_id ;
283: tmpApprover.action_type_id := currentFirstApprover.action_type_id ;
284: tmpApprover.group_or_chain_id := currentFirstApprover.group_or_chain_id ;
285:
286: -- retrieve the name from wf_roles table for the given orig_system and orig_system_id values.
287: -- this name field does not refer to neither employee name nor position name
288: -- this name filed is the mandatory key field for the approverrecord2. We should pass this to ame. Otherwise ame will throw exception.
289:
290: SELECT name into tmpApprover.name FROM wf_roles

Line 290: SELECT name into tmpApprover.name FROM wf_roles

286: -- retrieve the name from wf_roles table for the given orig_system and orig_system_id values.
287: -- this name field does not refer to neither employee name nor position name
288: -- this name filed is the mandatory key field for the approverrecord2. We should pass this to ame. Otherwise ame will throw exception.
289:
290: SELECT name into tmpApprover.name FROM wf_roles
291: WHERE orig_system = tmpApprover.orig_system and orig_system_id = tmpApprover.orig_system_id and rownum = 1;
292:
293: IF tmpApprover.name IS NULL THEN
294: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||

Line 294: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||

290: SELECT name into tmpApprover.name FROM wf_roles
291: WHERE orig_system = tmpApprover.orig_system and orig_system_id = tmpApprover.orig_system_id and rownum = 1;
292:
293: IF tmpApprover.name IS NULL THEN
294: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
295: tmpApprover.orig_system_id || ' -- orig_system :' || tmpApprover.orig_system );
296: END IF;
297:
298: -- call the ame api to set the first authority approver.

Line 600: -- retrieve the name from wf_roles table for the given orig_system and orig_system_id values.

596: tmpApprover.group_or_chain_id := insertOrder.group_or_chain_id;
597: tmpApprover.api_insertion := insertOrder.api_insertion;
598: tmpApprover.authority := insertOrder.authority;
599:
600: -- retrieve the name from wf_roles table for the given orig_system and orig_system_id values.
601: -- this name field does not refer to neither employee name nor position name
602: -- this name filed is the mandatory key field for the approverrecord2. We should pass this to ame. Otherwise ame will throw exception.
603:
604: SELECT name into tmpApprover.name FROM wf_roles

Line 604: SELECT name into tmpApprover.name FROM wf_roles

600: -- retrieve the name from wf_roles table for the given orig_system and orig_system_id values.
601: -- this name field does not refer to neither employee name nor position name
602: -- this name filed is the mandatory key field for the approverrecord2. We should pass this to ame. Otherwise ame will throw exception.
603:
604: SELECT name into tmpApprover.name FROM wf_roles
605: WHERE orig_system = tmpApprover.orig_system and orig_system_id = tmpApprover.orig_system_id and rownum = 1;
606:
607: IF tmpApprover.name IS NULL THEN
608: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||

Line 608: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||

604: SELECT name into tmpApprover.name FROM wf_roles
605: WHERE orig_system = tmpApprover.orig_system and orig_system_id = tmpApprover.orig_system_id and rownum = 1;
606:
607: IF tmpApprover.name IS NULL THEN
608: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
609: tmpApprover.orig_system_id || ' -- orig_system :' || tmpApprover.orig_system );
610: END IF;
611:
612: if g_fnd_debug = 'Y' then

Line 641: -- retrieve the name from wf_roles table for the given orig_system and orig_system_id values.

637: tmpApprover.group_or_chain_id := insertOrder.group_or_chain_id;
638: tmpApprover.api_insertion := insertOrder.api_insertion;
639: tmpApprover.authority := insertOrder.authority;
640:
641: -- retrieve the name from wf_roles table for the given orig_system and orig_system_id values.
642: -- this name field does not refer to neither employee name nor position name
643: -- this name filed is the mandatory key field for the approverrecord2. We should pass this to ame. Otherwise ame will throw exception.
644:
645: SELECT name into tmpApprover.name FROM wf_roles

Line 645: SELECT name into tmpApprover.name FROM wf_roles

641: -- retrieve the name from wf_roles table for the given orig_system and orig_system_id values.
642: -- this name field does not refer to neither employee name nor position name
643: -- this name filed is the mandatory key field for the approverrecord2. We should pass this to ame. Otherwise ame will throw exception.
644:
645: SELECT name into tmpApprover.name FROM wf_roles
646: WHERE orig_system = tmpApprover.orig_system and orig_system_id = tmpApprover.orig_system_id and rownum = 1;
647:
648: IF tmpApprover.name IS NULL THEN
649: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||

Line 649: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||

645: SELECT name into tmpApprover.name FROM wf_roles
646: WHERE orig_system = tmpApprover.orig_system and orig_system_id = tmpApprover.orig_system_id and rownum = 1;
647:
648: IF tmpApprover.name IS NULL THEN
649: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
650: tmpApprover.orig_system_id || ' -- orig_system :' || tmpApprover.orig_system );
651: END IF;
652:
653: if g_fnd_debug = 'Y' then

Line 2110: SELECT orig_system, orig_system_id into l_orig_system, l_orig_system_id FROM wf_roles where name = approversTableIn(i).name and rownum = 1;

2106:
2107: -- orig_system and orig_system_id should not be null.
2108: -- There is a bug 4403014 for the same. So this is a work-around to achieve the same.
2109: if l_orig_system is null and l_orig_system_id is null then
2110: SELECT orig_system, orig_system_id into l_orig_system, l_orig_system_id FROM wf_roles where name = approversTableIn(i).name and rownum = 1;
2111: end if;
2112:
2113: if l_orig_system is null and l_orig_system_id is null then
2114: raise NO_DATA_FOUND;

Line 2157: FROM wf_roles where name = approversTableIn(i).name and rownum = 1;

2153: -- Verify the person_id is not null.
2154: if( l_valid_approver = 'Y' AND ( l_person_id is null or l_full_name is null ))then
2155:
2156: SELECT orig_system_id, display_name, description into l_person_id, l_full_name, l_job_or_position
2157: FROM wf_roles where name = approversTableIn(i).name and rownum = 1;
2158:
2159: -- We raise the exception only for the last approver.
2160: --if l_person_id is null then
2161: if i = upperLimit then