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.PON_AWARD_APPROVAL_PKG dependencies on WF_ROLES

Line 1662: SELECT name into l_forwardee.name FROM wf_roles

1658: l_forwardee.approver_category := l_approver.approver_category;
1659: l_forwardee.item_class := l_approver.item_class ;
1660: l_forwardee.item_id := l_approver.item_id ;
1661:
1662: SELECT name into l_forwardee.name FROM wf_roles
1663: WHERE orig_system = l_forwardee.orig_system and orig_system_id = l_forwardee.orig_system_id and rownum = 1;
1664:
1665: IF l_forwardee.name IS NULL THEN
1666: resultout := 'INVALID_FORWARD';

Line 1822: SELECT name into l_approver.name FROM wf_roles

1818: l_approver.group_or_chain_id := l_insertion_order.group_or_chain_id;
1819: l_approver.api_insertion := l_insertion_order.api_insertion;
1820: l_approver.authority := l_insertion_order.authority;
1821:
1822: SELECT name into l_approver.name FROM wf_roles
1823: WHERE orig_system = l_approver.orig_system and orig_system_id = l_approver.orig_system_id and rownum = 1;
1824:
1825: IF l_approver.name IS NULL THEN
1826: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||

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

1822: SELECT name into l_approver.name FROM wf_roles
1823: WHERE orig_system = l_approver.orig_system and orig_system_id = l_approver.orig_system_id and rownum = 1;
1824:
1825: IF l_approver.name IS NULL THEN
1826: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
1827: l_approver.orig_system_id || ' -- orig_system :' || l_approver.orig_system );
1828: END IF;
1829:
1830: EXIT;

Line 2048: SELECT name into l_approver.name FROM wf_roles

2044:
2045: -- set first authority approver
2046: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.setFirstAuthorityApprover with ' || fnd_global.newline || format_ame_approver(l_approver));
2047:
2048: SELECT name into l_approver.name FROM wf_roles
2049: WHERE orig_system = l_approver.orig_system and orig_system_id = l_approver.orig_system_id and rownum = 1;
2050:
2051: IF l_approver.name IS NULL THEN
2052: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||

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

2048: SELECT name into l_approver.name FROM wf_roles
2049: WHERE orig_system = l_approver.orig_system and orig_system_id = l_approver.orig_system_id and rownum = 1;
2050:
2051: IF l_approver.name IS NULL THEN
2052: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
2053: l_approver.orig_system_id || ' -- orig_system :' || l_approver.orig_system );
2054: END IF;
2055:
2056: ame_api2.setFirstAuthorityApprover(applicationIdIn => APPLICATION_ID,