DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_LINE_UCAS

Line 5169: --Po_line_ucas

5165: --Start of Comments
5166: --Name: SYNC_LINE_UCAS
5167: --Pre-reqs: None
5168: --Modifies:
5169: --Po_line_ucas
5170: --Locks:
5171: -- None.
5172: --Function:
5173: -- Syncs Line UCas

Line 5194: INSERT INTO po_line_ucas

5190: d_position NUMBER;
5191:
5192: BEGIN
5193: d_position := 10;
5194: INSERT INTO po_line_ucas
5195: (po_line_uca_id,
5196: po_header_id,
5197: po_line_id,
5198: undef_draft_id,

Line 5215: SELECT po_line_ucas_s.NEXTVAL,

5211: last_update_login,
5212: undef_clm_document_number,
5213: limit_gov_liability_amt,
5214: def_par_draft_id)
5215: SELECT po_line_ucas_s.NEXTVAL,
5216: po_header_id,
5217: po_line_id,
5218: p_draft_id,
5219: undef_amount,

Line 5235: FROM po_line_ucas

5231: last_update_login,
5232: undef_clm_document_number,
5233: limit_gov_liability_amt,
5234: def_par_draft_id
5235: FROM po_line_ucas
5236: WHERE po_header_id = p_document_id
5237: AND undef_draft_id = -1;
5238: d_position :=20;
5239: IF (PO_LOG.d_stmt) THEN