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

Line 3112: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

3108: x_progress VARCHAR2(100);
3109: l_doc_string VARCHAR2(200);
3110: l_preparer_user_name VARCHAR2(100);
3111: /* <> */
3112: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
3113: l_document_id NUMBER;
3114: l_is_clm_doc VARCHAR2(1) := NULL ;
3115: /* <> */
3116: BEGIN

Line 3413: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

3409: l_create_sr_asl VARCHAR2(2);
3410: x_progress VARCHAR2(300);
3411: l_doc_string VARCHAR2(200);
3412: l_preparer_user_name VARCHAR2(100);
3413: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
3414: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
3415: l_resp_id NUMBER;
3416: l_user_id NUMBER;
3417: l_appl_id NUMBER;

Line 3414: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;

3410: x_progress VARCHAR2(300);
3411: l_doc_string VARCHAR2(200);
3412: l_preparer_user_name VARCHAR2(100);
3413: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
3414: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
3415: l_resp_id NUMBER;
3416: l_user_id NUMBER;
3417: l_appl_id NUMBER;
3418: BEGIN

Line 7985: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

7981: l_massupdate_releases VARCHAR2(2);
7982: l_progress VARCHAR2(300);
7983: l_doc_string VARCHAR2(200);
7984: l_preparer_user_name VARCHAR2(100);
7985: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
7986: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
7987: l_resp_id NUMBER;
7988: l_user_id NUMBER;
7989: l_appl_id NUMBER;

Line 7986: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;

7982: l_progress VARCHAR2(300);
7983: l_doc_string VARCHAR2(200);
7984: l_preparer_user_name VARCHAR2(100);
7985: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
7986: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
7987: l_resp_id NUMBER;
7988: l_user_id NUMBER;
7989: l_appl_id NUMBER;
7990: BEGIN

Line 8130: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

8126: IS
8127: l_retro_change VARCHAR2(1);
8128: l_supplier_comm VARCHAR2(1) := 'Y'; --default has to be Y
8129: l_progress VARCHAR2(300);
8130: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
8131: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
8132: BEGIN
8133: l_progress := 'PO_REQAPPROVAL_INIT1.Send_Supplier_Comm_Yes_No: 01';
8134: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CO_R_RETRO_CHANGE');

Line 8131: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;

8127: l_retro_change VARCHAR2(1);
8128: l_supplier_comm VARCHAR2(1) := 'Y'; --default has to be Y
8129: l_progress VARCHAR2(300);
8130: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
8131: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
8132: BEGIN
8133: l_progress := 'PO_REQAPPROVAL_INIT1.Send_Supplier_Comm_Yes_No: 01';
8134: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CO_R_RETRO_CHANGE');
8135: -- Bug 3694128 : get the document type and subtype