APPS.PO_MULTI_MOD_PVT dependencies on PO_HEADERS_ALL_EXT_TL

Line 1042: -- Start PO_HEADERS_ALL_EXT_TL

1038: FROM PO_HEADERS_ALL_EXT_B
1039: WHERE extension_id = l_old_hdr_ext_id_tbl(i);
1040: -- End PO_HEADERS_ALL_EXT_B
1041:
1042: -- Start PO_HEADERS_ALL_EXT_TL
1043: d_position := 40;
1044: debug(d_module, d_position, 'Insert into Address Ext TL');
1045:
1046: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count

Line 1047: INSERT INTO PO_HEADERS_ALL_EXT_TL

1043: d_position := 40;
1044: debug(d_module, d_position, 'Insert into Address Ext TL');
1045:
1046: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count
1047: INSERT INTO PO_HEADERS_ALL_EXT_TL
1048: (EXTENSION_ID
1049: ,ATTR_GROUP_ID
1050: ,PO_HEADER_ID
1051: ,DATA_LEVEL_ID

Line 1166: FROM PO_HEADERS_ALL_EXT_TL

1162: ,TL_EXT_ATTR39
1163: ,TL_EXT_ATTR40
1164: ,UDA_TEMPLATE_ID
1165: ,p_draft_id
1166: FROM PO_HEADERS_ALL_EXT_TL
1167: WHERE extension_id = l_old_hdr_ext_id_tbl(i);
1168: --AND language = userenv('LANG');
1169: -- End PO_HEADERS_ALL_EXT_TL
1170:

Line 1169: -- End PO_HEADERS_ALL_EXT_TL

1165: ,p_draft_id
1166: FROM PO_HEADERS_ALL_EXT_TL
1167: WHERE extension_id = l_old_hdr_ext_id_tbl(i);
1168: --AND language = userenv('LANG');
1169: -- End PO_HEADERS_ALL_EXT_TL
1170:
1171: -- Merge the Multi-Mod Addresses only if there exists at least one address change on the Multi-Mod
1172: IF (p_addr_change_flag = 'Y') THEN
1173:

Line 1378: UPDATE po_headers_all_ext_tl PHAT1

1374:
1375: d_position := 60;
1376: debug(d_module, d_position, 'Merge records in Address TL Table');
1377:
1378: UPDATE po_headers_all_ext_tl PHAT1
1379: SET(
1380: TL_EXT_ATTR1
1381: ,TL_EXT_ATTR2
1382: ,TL_EXT_ATTR3

Line 1462: FROM po_headers_all_ext_tl PHAT2

1458: ,Nvl(PHAT2.TL_EXT_ATTR37, PHAT1.TL_EXT_ATTR37)
1459: ,Nvl(PHAT2.TL_EXT_ATTR38, PHAT1.TL_EXT_ATTR38)
1460: ,Nvl(PHAT2.TL_EXT_ATTR39, PHAT1.TL_EXT_ATTR39)
1461: ,Nvl(PHAT2.TL_EXT_ATTR40, PHAT1.TL_EXT_ATTR40)
1462: FROM po_headers_all_ext_tl PHAT2
1463: WHERE PHAT2.po_header_id = p_uda_key_po_header_id
1464: AND PHAT2.draft_id = p_uda_key_draft_id
1465: AND PHAT2.attr_group_id = l_addr_attr_group_id
1466: AND PHAT1.attr_group_id = PHAT2.attr_group_id