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 1697: SELECT name into l_forwardee.name FROM wf_roles

1693: l_forwardee.approver_category := l_approver.approver_category;
1694: l_forwardee.item_class := l_approver.item_class ;
1695: l_forwardee.item_id := l_approver.item_id ;
1696:
1697: SELECT name into l_forwardee.name FROM wf_roles
1698: WHERE orig_system = l_forwardee.orig_system and orig_system_id = l_forwardee.orig_system_id and rownum = 1;
1699:
1700: IF l_forwardee.name IS NULL THEN
1701: resultout := 'INVALID_FORWARD';

Line 1857: SELECT name into l_approver.name FROM wf_roles

1853: l_approver.group_or_chain_id := l_insertion_order.group_or_chain_id;
1854: l_approver.api_insertion := l_insertion_order.api_insertion;
1855: l_approver.authority := l_insertion_order.authority;
1856:
1857: SELECT name into l_approver.name FROM wf_roles
1858: WHERE orig_system = l_approver.orig_system and orig_system_id = l_approver.orig_system_id and rownum = 1;
1859:
1860: IF l_approver.name IS NULL THEN
1861: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||

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

1857: SELECT name into l_approver.name FROM wf_roles
1858: WHERE orig_system = l_approver.orig_system and orig_system_id = l_approver.orig_system_id and rownum = 1;
1859:
1860: IF l_approver.name IS NULL THEN
1861: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
1862: l_approver.orig_system_id || ' -- orig_system :' || l_approver.orig_system );
1863: END IF;
1864:
1865: EXIT;

Line 2083: SELECT name into l_approver.name FROM wf_roles

2079:
2080: -- set first authority approver
2081: 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));
2082:
2083: SELECT name into l_approver.name FROM wf_roles
2084: WHERE orig_system = l_approver.orig_system and orig_system_id = l_approver.orig_system_id and rownum = 1;
2085:
2086: IF l_approver.name IS NULL THEN
2087: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||

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

2083: SELECT name into l_approver.name FROM wf_roles
2084: WHERE orig_system = l_approver.orig_system and orig_system_id = l_approver.orig_system_id and rownum = 1;
2085:
2086: IF l_approver.name IS NULL THEN
2087: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
2088: l_approver.orig_system_id || ' -- orig_system :' || l_approver.orig_system );
2089: END IF;
2090:
2091: ame_api2.setFirstAuthorityApprover(applicationIdIn => APPLICATION_ID,