APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_HEADERS_ALL_EXT_TL

Line 156: DELETE FROM po_headers_all_ext_tl

152:
153: DELETE FROM po_line_locations_all_ext_b
154: WHERE draft_id = p_draft_id;
155:
156: DELETE FROM po_headers_all_ext_tl
157: WHERE draft_id = p_draft_id;
158:
159: DELETE FROM po_lines_all_ext_tl
160: 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 4245: -- Start PO_HEADERS_ALL_EXT_TL

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
4248: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_TL');
4249: END IF;

Line 4248: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_TL');

4244:
4245: -- Start PO_HEADERS_ALL_EXT_TL
4246: d_position := 60;
4247: IF PO_LOG.d_stmt THEN
4248: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_TL');
4249: END IF;
4250:
4251: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count
4252: INSERT INTO PO_HEADERS_ALL_EXT_TL

Line 4252: INSERT INTO PO_HEADERS_ALL_EXT_TL

4248: PO_LOG.stmt(d_mod,d_position,'Sync PO_HEADERS_ALL_EXT_TL');
4249: END IF;
4250:
4251: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count
4252: INSERT INTO PO_HEADERS_ALL_EXT_TL
4253: (EXTENSION_ID
4254: ,ATTR_GROUP_ID
4255: ,PO_HEADER_ID
4256: ,DATA_LEVEL_ID

Line 4371: FROM PO_HEADERS_ALL_EXT_TL_ARCHIVE

4367: ,TL_EXT_ATTR39
4368: ,TL_EXT_ATTR40
4369: ,UDA_TEMPLATE_ID
4370: ,p_draft_id
4371: FROM PO_HEADERS_ALL_EXT_TL_ARCHIVE
4372: WHERE extension_id = l_old_hdr_ext_id_tbl(i)
4373: AND language = userenv('LANG')
4374: AND revision_num = p_revision_num;
4375:

Line 4380: -- End PO_HEADERS_ALL_EXT_TL

4376: d_position := 70;
4377: IF PO_LOG.d_stmt THEN
4378: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4379: END IF;
4380: -- End PO_HEADERS_ALL_EXT_TL
4381:
4382: -- Sync UDA Line and Line Locations data only for PO or PA BLANKETS
4383: IF (p_document_type = 'PO') OR
4384: (p_document_type = 'PA' AND p_document_subtype='BLANKET') THEN