APPS.PO_AUTO_HEADER_PROCESS_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 1188: DESC: Insert/update header records into po_headers_draft_all table.

1184: END validate_header;
1185:
1186: /* ============================================================================
1187: NAME: merge_to_headers_draft
1188: DESC: Insert/update header records into po_headers_draft_all table.
1189: ARGS: IN OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type
1190: NOTE: if NEW DOCUMENT
1191: 1. Create a draft record
1192: 2. Create headers_draft record

Line 1244: UPDATE po_headers_draft_all

1240: WHERE draft_id = x_headers.draft_id;
1241:
1242: l_progress := '021';
1243: -- Update the PO Headers Draft
1244: UPDATE po_headers_draft_all
1245: SET last_update_date = x_headers.last_update_date,
1246: last_updated_by = x_headers.last_updated_by,
1247: last_update_login = x_headers.last_update_login
1248: WHERE draft_id = x_headers.draft_id;

Line 1318: -- Insert esisting records from PO into po_headers_draft_all

1314: x_headers.clm_contract_officer --Bug13547051
1315: );
1316:
1317: l_progress := '040';
1318: -- Insert esisting records from PO into po_headers_draft_all
1319: INSERT
1320: INTO po_headers_draft_all
1321: (
1322: draft_id,

Line 1320: INTO po_headers_draft_all

1316:
1317: l_progress := '040';
1318: -- Insert esisting records from PO into po_headers_draft_all
1319: INSERT
1320: INTO po_headers_draft_all
1321: (
1322: draft_id,
1323: org_id,
1324: delete_flag,

Line 1567: UPDATE po_headers_draft_all

1563: FROM po_headers_all
1564: WHERE po_header_id = x_headers.po_header_id;
1565:
1566: l_progress := '050';
1567: UPDATE po_headers_draft_all
1568: SET last_update_date = x_headers.last_update_date,
1569: last_updated_by = x_headers.last_updated_by,
1570: authorization_status = NULL,
1571: last_update_login = x_headers.last_update_login

Line 1625: -- Insert new documents attribute values into po_headers_draft_all

1621: x_headers.request_id
1622: );
1623:
1624: l_progress := '040';
1625: -- Insert new documents attribute values into po_headers_draft_all
1626: INSERT
1627: INTO po_headers_draft_all
1628: (
1629: draft_id,

Line 1627: INTO po_headers_draft_all

1623:
1624: l_progress := '040';
1625: -- Insert new documents attribute values into po_headers_draft_all
1626: INSERT
1627: INTO po_headers_draft_all
1628: (
1629: draft_id,
1630: org_id,
1631: delete_flag,