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 2397: po_document_types.can_change_forward_from_flag%type;

2393: where employee_id = p_PreparerID;
2394:
2395: /* RETROACTIVE FPI START */
2396: l_can_change_forward_from_flag
2397: po_document_types.can_change_forward_from_flag%type;
2398: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2399: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2400: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2401: l_default_approval_path_id po_document_types.default_approval_path_id%type;

Line 2398: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;

2394:
2395: /* RETROACTIVE FPI START */
2396: l_can_change_forward_from_flag
2397: po_document_types.can_change_forward_from_flag%type;
2398: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2399: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2400: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2401: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2402: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;

Line 2399: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;

2395: /* RETROACTIVE FPI START */
2396: l_can_change_forward_from_flag
2397: po_document_types.can_change_forward_from_flag%type;
2398: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2399: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2400: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2401: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2402: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2403: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;

Line 2400: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;

2396: l_can_change_forward_from_flag
2397: po_document_types.can_change_forward_from_flag%type;
2398: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2399: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2400: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2401: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2402: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2403: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
2404: l_type_name po_document_types.type_name%type;

Line 2401: l_default_approval_path_id po_document_types.default_approval_path_id%type;

2397: po_document_types.can_change_forward_from_flag%type;
2398: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2399: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2400: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2401: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2402: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2403: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
2404: l_type_name po_document_types.type_name%type;
2405:

Line 2402: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;

2398: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
2399: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2400: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2401: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2402: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2403: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
2404: l_type_name po_document_types.type_name%type;
2405:
2406: /* RETROACTIVE FPI END */

Line 2403: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;

2399: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
2400: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2401: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2402: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2403: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
2404: l_type_name po_document_types.type_name%type;
2405:
2406: /* RETROACTIVE FPI END */
2407:

Line 2404: l_type_name po_document_types.type_name%type;

2400: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
2401: l_default_approval_path_id po_document_types.default_approval_path_id%type;
2402: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
2403: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
2404: l_type_name po_document_types.type_name%type;
2405:
2406: /* RETROACTIVE FPI END */
2407:
2408: BEGIN

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

2431: l_ItemKey := to_char(p_DocumentID) || '-' || l_seq;
2432: -- Bug 3240928 end
2433:
2434: /* Bug# 1691814: kagarwal
2435: ** Desc: Changed PO_DOCUMENT_TYPES_V to PO_DOCUMENT_TYPES to improve
2436: ** the perfomance of the SQL.
2437: */
2438: /* Bug 2780033.
2439: * We need to get the default communication method and

Line 2484: * wf_approval_process from PO_DOCUMENT_TYPES. Instead call the

2480:
2481:
2482: /* RETROACTIVE FPI START.
2483: * Deleted the sql query which selected wf_approval_itemtype and
2484: * wf_approval_process from PO_DOCUMENT_TYPES. Instead call the
2485: * new overloaded procedure po_approve_sv.get_document_types.
2486: * We call this here even though this is called in start_wf_process
2487: * since we need these values to set some workflow attributes
2488: * before we call start_Wf_process.