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_REQAPPROVAL_ACTION dependencies on PO_DOCUMENT_TYPES_ALL

Line 680: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

676: l_doc_string varchar2(200);
677: l_preparer_user_name varchar2(100);
678: doc_manager_exception exception;
679:
680: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
681: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
682: l_document_id NUMBER;
683: l_approver_id NUMBER;
684: l_preparer_id NUMBER;

Line 681: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

677: l_preparer_user_name varchar2(100);
678: doc_manager_exception exception;
679:
680: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
681: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
682: l_document_id NUMBER;
683: l_approver_id NUMBER;
684: l_preparer_id NUMBER;
685: l_insert_owner_app Boolean := true;

Line 1522: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

1518: FUNCTION StateCheckApprove(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
1519:
1520: --
1521:
1522: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1523: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1524: l_document_id NUMBER;
1525:
1526: l_ret_sts VARCHAR2(1);

Line 1523: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

1519:
1520: --
1521:
1522: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1523: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1524: l_document_id NUMBER;
1525:
1526: l_ret_sts VARCHAR2(1);
1527: l_exc_msg VARCHAR2(2000);

Line 1619: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

1615: FUNCTION StateCheckReject(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
1616:
1617: --
1618:
1619: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1620: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1621: l_document_id NUMBER;
1622:
1623: l_ret_sts VARCHAR2(1);

Line 1620: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

1616:
1617: --
1618:
1619: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1620: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1621: l_document_id NUMBER;
1622:
1623: l_ret_sts VARCHAR2(1);
1624: l_exc_msg VARCHAR2(2000);

Line 2128: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2124: RETURN VARCHAR2
2125: IS
2126:
2127: --
2128: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2129: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2130: l_document_id NUMBER;
2131: l_note PO_ACTION_HISTORY.note%TYPE;
2132: l_approval_path_id NUMBER;

Line 2129: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2125: IS
2126:
2127: --
2128: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2129: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2130: l_document_id NUMBER;
2131: l_note PO_ACTION_HISTORY.note%TYPE;
2132: l_approval_path_id NUMBER;
2133:

Line 2244: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2240: --
2241: FUNCTION ApproveAndForward(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2242:
2243: --
2244: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2245: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2246: l_document_id NUMBER;
2247: l_note PO_ACTION_HISTORY.note%TYPE;
2248: l_approval_path_id NUMBER;

Line 2245: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2241: FUNCTION ApproveAndForward(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2242:
2243: --
2244: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2245: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2246: l_document_id NUMBER;
2247: l_note PO_ACTION_HISTORY.note%TYPE;
2248: l_approval_path_id NUMBER;
2249: l_forward_to_id NUMBER;

Line 2355: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2351: FUNCTION ForwardDocInProcess(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2352:
2353: --
2354:
2355: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2356: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2357: l_document_id NUMBER;
2358: l_note PO_ACTION_HISTORY.note%TYPE;
2359: l_approval_path_id NUMBER;

Line 2356: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2352:
2353: --
2354:
2355: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2356: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2357: l_document_id NUMBER;
2358: l_note PO_ACTION_HISTORY.note%TYPE;
2359: l_approval_path_id NUMBER;
2360: l_forward_to_id NUMBER;

Line 2465: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2461: FUNCTION ForwardDocPreApproved(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2462:
2463: --
2464:
2465: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2466: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2467: l_document_id NUMBER;
2468: l_note PO_ACTION_HISTORY.note%TYPE;
2469: l_approval_path_id NUMBER;

Line 2466: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2462:
2463: --
2464:
2465: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2466: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2467: l_document_id NUMBER;
2468: l_note PO_ACTION_HISTORY.note%TYPE;
2469: l_approval_path_id NUMBER;
2470: l_forward_to_id NUMBER;

Line 2576: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2572: --
2573: FUNCTION RejectDoc(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2574:
2575: --
2576: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2577: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2578: l_document_id NUMBER;
2579: l_note PO_ACTION_HISTORY.note%TYPE;
2580: l_approval_path_id NUMBER;

Line 2577: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2573: FUNCTION RejectDoc(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2574:
2575: --
2576: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2577: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2578: l_document_id NUMBER;
2579: l_note PO_ACTION_HISTORY.note%TYPE;
2580: l_approval_path_id NUMBER;
2581:

Line 2738: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2734: FUNCTION VerifyAuthority(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2735:
2736: --
2737:
2738: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2739: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2740: l_document_id NUMBER;
2741: l_employee_id NUMBER;
2742:

Line 2739: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2735:
2736: --
2737:
2738: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2739: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2740: l_document_id NUMBER;
2741: l_employee_id NUMBER;
2742:
2743: l_ret_sts VARCHAR2(1);

Line 2836: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2832: --
2833: FUNCTION OpenDocumentState(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2834:
2835: --
2836: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2837: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2838: l_document_id NUMBER;
2839:
2840: l_ret_code VARCHAR2(25);

Line 2837: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2833: FUNCTION OpenDocumentState(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2834:
2835: --
2836: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2837: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2838: l_document_id NUMBER;
2839:
2840: l_ret_code VARCHAR2(25);
2841: l_ret_sts VARCHAR2(1);

Line 3210: l_document_type po_document_types_all.document_type_code%TYPE;--

3206: )
3207: IS
3208:
3209: x_progress VARCHAR2(400);
3210: l_document_type po_document_types_all.document_type_code%TYPE;--
3211:
3212: BEGIN
3213:
3214: x_progress := 'PO_REQAPPROVAL_ACTION.get_advisory_warning.010.ON_LINE_REPORT_ID= '