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.PO_APPROVAL_REMINDER_SV dependencies on PO_DOCUMENT_TYPES

Line 2363: po_document_types.can_change_forward_from_flag%type;

2359: where employee_id = p_PreparerID;
2360:
2361: /* RETROACTIVE FPI START */
2362: l_can_change_forward_from_flag
2363: po_document_types.can_change_forward_from_flag%type;
2364: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2365: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2366: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2367: l_default_approval_path_id po_document_types.default_approval_path_id%type;

Line 2364: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;

2360:
2361: /* RETROACTIVE FPI START */
2362: l_can_change_forward_from_flag
2363: po_document_types.can_change_forward_from_flag%type;
2364: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2365: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2366: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2367: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2368: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;

Line 2365: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;

2361: /* RETROACTIVE FPI START */
2362: l_can_change_forward_from_flag
2363: po_document_types.can_change_forward_from_flag%type;
2364: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2365: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2366: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2367: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2368: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2369: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;

Line 2366: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;

2362: l_can_change_forward_from_flag
2363: po_document_types.can_change_forward_from_flag%type;
2364: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2365: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2366: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2367: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2368: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2369: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
2370: l_type_name po_document_types.type_name%type;

Line 2367: l_default_approval_path_id po_document_types.default_approval_path_id%type;

2363: po_document_types.can_change_forward_from_flag%type;
2364: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2365: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2366: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2367: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2368: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2369: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
2370: l_type_name po_document_types.type_name%type;
2371:

Line 2368: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;

2364: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2365: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2366: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2367: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2368: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2369: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
2370: l_type_name po_document_types.type_name%type;
2371:
2372: /* RETROACTIVE FPI END */

Line 2369: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;

2365: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2366: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2367: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2368: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2369: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
2370: l_type_name po_document_types.type_name%type;
2371:
2372: /* RETROACTIVE FPI END */
2373:

Line 2370: l_type_name po_document_types.type_name%type;

2366: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2367: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2368: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2369: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
2370: l_type_name po_document_types.type_name%type;
2371:
2372: /* RETROACTIVE FPI END */
2373:
2374: BEGIN

Line 2401: ** Desc: Changed PO_DOCUMENT_TYPES_V to PO_DOCUMENT_TYPES to improve

2397: l_ItemKey := to_char(p_DocumentID) || '-' || l_seq;
2398: -- Bug 3240928 end
2399:
2400: /* Bug# 1691814: kagarwal
2401: ** Desc: Changed PO_DOCUMENT_TYPES_V to PO_DOCUMENT_TYPES to improve
2402: ** the perfomance of the SQL.
2403: */
2404: /* Bug 2780033.
2405: * We need to get the default communication method and

Line 2450: * wf_approval_process from PO_DOCUMENT_TYPES. Instead call the

2446:
2447:
2448: /* RETROACTIVE FPI START.
2449: * Deleted the sql query which selected wf_approval_itemtype and
2450: * wf_approval_process from PO_DOCUMENT_TYPES. Instead call the
2451: * new overloaded procedure po_approve_sv.get_document_types.
2452: * We call this here even though this is called in start_wf_process
2453: * since we need these values to set some workflow attributes
2454: * before we call start_Wf_process.