54:
55: -- PO_HEADERS_ALL.type_lookup_code
56: c_STANDARD CONSTANT VARCHAR2(10) := 'STANDARD';
57:
58: -- PO_LINES_ALL.order_type_lookup_code
59: c_RATE CONSTANT VARCHAR2(5) := 'RATE';
60:
61: -- RCV_TRANSACTIONS_INTERFACE.transaction_status_code
62: c_PENDING CONSTANT VARCHAR2(10) := 'PENDING';
66:
67: -- PO_HEADERS_ALL.authorization_status
68: c_INCOMPLETE CONSTANT VARCHAR2(30) := 'INCOMPLETE';
69:
70: -- PO_LINES_ALL.price_break_lookup_code
71: c_NON_CUMULATIVE CONSTANT VARCHAR2(30) := 'NON CUMULATIVE';
72:
73: -------------------------------------------------------------------------------
74: --Start of Comments
371: , p_line_id_tbl(i)
372: , c_UNIT_PRICE
373: , NULL -- TODO: Get message from PM.
374: FROM
375: PO_LINES_ALL LINE
376: , PO_HEADERS_ALL HEADER
377: WHERE
378: LINE.po_line_id = p_line_id_tbl(i)
379: AND HEADER.po_header_id = LINE.po_header_id
508: , l_type_lookup_code_tbl
509: , l_expense_accrual_code_tbl
510: FROM
511: PO_SESSION_GT SES
512: , PO_LINES_ALL LINE
513: , PO_HEADERS_ALL HEADER
514: , PO_SYSTEM_PARAMETERS_ALL PARAMS
515: WHERE
516: SES.key = l_data_key
840: l_line_id_tbl
841: , l_price_break_lookup_code_tbl
842: FROM
843: PO_SESSION_GT SES
844: , PO_LINES_ALL LINE
845: , PO_HEADERS_ALL HEADER
846: WHERE
847: SES.key = l_data_key
848: AND LINE.po_line_id = SES.num1