DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_HEADERS_ALL_EXT_B

Line 147: DELETE FROM po_headers_all_ext_b

143: WHERE draft_id = p_draft_id;
144: --End Deleting Headers/Lines/Shipments/Distributions
145:
146: --Start Deleting UDA Atribs
147: DELETE FROM po_headers_all_ext_b
148: WHERE draft_id = p_draft_id;
149:
150: DELETE FROM po_lines_all_ext_b
151: WHERE draft_id = p_draft_id;

Line 3884: -- PO_HEADERS_ALL_EXT_B / PO_HEADERS_ALL_EXT_TL

3880: --Start of Comments
3881: --Name: SYNC_UDA_ATTRIBS
3882: --Pre-reqs: None
3883: --Modifies:
3884: -- PO_HEADERS_ALL_EXT_B / PO_HEADERS_ALL_EXT_TL
3885: -- PO_LINES_ALL_EXT_B / PO_LINES_ALL_EXT_TL
3886: -- PO_LINE_LOCATIONS_ALL_EXT_B / PO_LINE_LOCATIONS_ALL_EXT_TL
3887: --Locks:
3888: -- None.

Line 3938: FROM PO_HEADERS_ALL_EXT_B_ARCHIVE

3934: l_new_line_loc_ext_id_tbl PO_TBL_NUMBER;
3935:
3936: CURSOR po_headers_ext_cursor IS
3937: SELECT extension_id, EGO_EXTFWK_S.NEXTVAL
3938: FROM PO_HEADERS_ALL_EXT_B_ARCHIVE
3939: WHERE po_header_id = p_document_id
3940: AND draft_id = -1
3941: AND revision_num = p_revision_num;
3942:

Line 4013: -- Start Sync PO_HEADERS_ALL_EXT_B

4009: OPEN po_headers_ext_cursor;
4010: FETCH po_headers_ext_cursor BULK COLLECT INTO l_old_hdr_ext_id_tbl, l_new_hdr_ext_id_tbl;
4011: CLOSE po_headers_ext_cursor;
4012:
4013: -- Start Sync PO_HEADERS_ALL_EXT_B
4014: d_position := 40;
4015: IF PO_LOG.d_stmt THEN
4016: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_B');
4017: END IF;

Line 4016: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_B');

4012:
4013: -- Start Sync PO_HEADERS_ALL_EXT_B
4014: d_position := 40;
4015: IF PO_LOG.d_stmt THEN
4016: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_B');
4017: END IF;
4018:
4019: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count
4020: INSERT INTO PO_HEADERS_ALL_EXT_B

Line 4020: INSERT INTO PO_HEADERS_ALL_EXT_B

4016: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_B');
4017: END IF;
4018:
4019: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count
4020: INSERT INTO PO_HEADERS_ALL_EXT_B
4021: (EXTENSION_ID
4022: ,ATTR_GROUP_ID
4023: ,PO_HEADER_ID
4024: ,DATA_LEVEL_ID

Line 4235: FROM PO_HEADERS_ALL_EXT_B_ARCHIVE

4231: ,D_EXT_ATTR9
4232: ,D_EXT_ATTR10
4233: ,UDA_TEMPLATE_ID
4234: ,p_draft_id
4235: FROM PO_HEADERS_ALL_EXT_B_ARCHIVE
4236: WHERE extension_id = l_old_hdr_ext_id_tbl(i)
4237: AND revision_num = p_revision_num;
4238:
4239: d_position := 50;

Line 4243: -- End PO_HEADERS_ALL_EXT_B

4239: d_position := 50;
4240: IF PO_LOG.d_stmt THEN
4241: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4242: END IF;
4243: -- End PO_HEADERS_ALL_EXT_B
4244:
4245: -- Start PO_HEADERS_ALL_EXT_TL
4246: d_position := 60;
4247: IF PO_LOG.d_stmt THEN