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: -- bug 9395808

Line 297: FROM wf_roles

293: -- it should pick up the approver with earliest start date.
294: -- also validating the approver status
295: SELECT name into tmpApprover.name FROM (
296: SELECT name
297: FROM wf_roles
298: WHERE orig_system = tmpApprover.orig_system and orig_system_id = tmpApprover.orig_system_id
299: and status = 'ACTIVE' and trunc (nvl( expiration_date, sysdate)) >= trunc(sysdate)
300: ORDER BY start_date
301: )

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

301: )
302: WHERE rownum = 1;
303:
304: IF tmpApprover.name IS NULL THEN
305: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
306: tmpApprover.orig_system_id || ' -- orig_system :' || tmpApprover.orig_system );
307: END IF;
308:
309: -- call the ame api to set the first authority approver.

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

607: tmpApprover.group_or_chain_id := insertOrder.group_or_chain_id;
608: tmpApprover.api_insertion := insertOrder.api_insertion;
609: tmpApprover.authority := insertOrder.authority;
610:
611: -- retrieve the name from wf_roles table for the given orig_system and orig_system_id values.
612: -- this name field does not refer to neither employee name nor position name
613: -- this name filed is the mandatory key field for the approverrecord2. We should pass this to ame. Otherwise ame will throw exception.
614: -- bug 9395808
615: -- fix The problem of just picking up the first approver randomly when an approver is manually

Line 621: FROM wf_roles

617: -- it should pick up the approver with earliest start date.
618: -- also validating the approver status
619: SELECT name into tmpApprover.name FROM (
620: SELECT name
621: FROM wf_roles
622: WHERE orig_system = tmpApprover.orig_system and orig_system_id = tmpApprover.orig_system_id
623: and status = 'ACTIVE' and trunc (nvl( expiration_date, sysdate)) >= trunc(sysdate)
624: ORDER BY start_date
625: )

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

625: )
626: WHERE rownum = 1;
627:
628: IF tmpApprover.name IS NULL THEN
629: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
630: tmpApprover.orig_system_id || ' -- orig_system :' || tmpApprover.orig_system );
631: END IF;
632:
633: if g_fnd_debug = 'Y' then

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

658: tmpApprover.group_or_chain_id := insertOrder.group_or_chain_id;
659: tmpApprover.api_insertion := insertOrder.api_insertion;
660: tmpApprover.authority := insertOrder.authority;
661:
662: -- retrieve the name from wf_roles table for the given orig_system and orig_system_id values.
663: -- this name field does not refer to neither employee name nor position name
664: -- this name filed is the mandatory key field for the approverrecord2. We should pass this to ame. Otherwise ame will throw exception.
665: -- bug 9395808
666: -- fix The problem of just picking up the first approver randomly when an approver is manually

Line 672: FROM wf_roles

668: -- it should pick up the approver with earliest start date.
669: -- also validating the approver status
670: SELECT name into tmpApprover.name FROM (
671: SELECT name
672: FROM wf_roles
673: WHERE orig_system = tmpApprover.orig_system and orig_system_id = tmpApprover.orig_system_id
674: and status = 'ACTIVE' and trunc (nvl( expiration_date, sysdate)) >= trunc(sysdate)
675: ORDER BY start_date
676: )

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

676: )
677: WHERE rownum = 1;
678:
679: IF tmpApprover.name IS NULL THEN
680: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
681: tmpApprover.orig_system_id || ' -- orig_system :' || tmpApprover.orig_system );
682: END IF;
683:
684: if g_fnd_debug = 'Y' then

Line 2180: 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;

2176:
2177: -- orig_system and orig_system_id should not be null.
2178: -- There is a bug 4403014 for the same. So this is a work-around to achieve the same.
2179: if l_orig_system is null and l_orig_system_id is null then
2180: 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;
2181: end if;
2182:
2183: if l_orig_system is null and l_orig_system_id is null then
2184: raise NO_DATA_FOUND;

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

2223: -- Verify the person_id is not null.
2224: if( l_valid_approver = 'Y' AND ( l_person_id is null or l_full_name is null ))then
2225:
2226: SELECT orig_system_id, display_name, description into l_person_id, l_full_name, l_job_or_position
2227: FROM wf_roles where name = approversTableIn(i).name and rownum = 1;
2228:
2229: -- We raise the exception only for the last approver.
2230: --if l_person_id is null then
2231: if i = upperLimit then