eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_CAT_POPULATE_CTXSTRING_PVT dependencies on ICX_CAT_ITEMS_CTX_DTLS_TLP

Line 398: INSERT INTO icx_cat_items_ctx_dtls_tlp

394:
395: l_err_loc := 2500;
396: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
397: l_err_loc := 2600;
398: INSERT INTO icx_cat_items_ctx_dtls_tlp
399: (inventory_item_id, po_line_id, req_template_name,
400: req_template_line_num, org_id, language,
401: last_update_login, last_updated_by, last_update_date,
402: internal_request_id, request_id, created_by, creation_date,

Line 409: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs

405: dtls.req_template_line_num, hdrs.org_id, dtls.language,
406: dtls.last_update_login, dtls.last_updated_by, dtls.last_update_date,
407: dtls.internal_request_id, dtls.request_id, dtls.created_by, dtls.creation_date,
408: dtls.sequence, dtls.ctx_desc
409: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs
410: WHERE hdrs.source_type = 'GLOBAL_BLANKET'
411: AND hdrs.inventory_item_id = dtls.inventory_item_id
412: AND hdrs.po_line_id = dtls.po_line_id
413: AND hdrs.req_template_name = dtls.req_template_name

Line 568: INSERT INTO icx_cat_items_ctx_dtls_tlp

564:
565: l_err_loc := 2100;
566: IF (p_doc_source = ICX_CAT_UTIL_PVT.g_PODoc_const) THEN
567: l_err_loc := 2200;
568: INSERT INTO icx_cat_items_ctx_dtls_tlp
569: (inventory_item_id, po_line_id, req_template_name,
570: req_template_line_num, org_id, language,
571: last_update_login, last_updated_by, last_update_date,
572: internal_request_id, request_id, created_by, creation_date,

Line 579: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs

575: dtls.req_template_line_num, hdrs.org_id, dtls.language,
576: dtls.last_update_login, dtls.last_updated_by, dtls.last_update_date,
577: dtls.internal_request_id, dtls.request_id, dtls.created_by, dtls.creation_date,
578: dtls.sequence, dtls.ctx_desc
579: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs
580: WHERE hdrs.source_type = 'GLOBAL_BLANKET'
581: AND hdrs.inventory_item_id = dtls.inventory_item_id
582: AND hdrs.po_line_id = dtls.po_line_id
583: AND hdrs.req_template_name = dtls.req_template_name

Line 955: INSERT INTO icx_cat_items_ctx_dtls_tlp

951: --loaded in the current internal_request_id
952: l_start_catg_att_seq := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartRegularCatgRow + 1;
953: l_end_catg_att_seq := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndRegularCatgRow;
954: l_err_loc := 3100;
955: INSERT INTO icx_cat_items_ctx_dtls_tlp
956: (inventory_item_id, po_line_id, req_template_name,
957: req_template_line_num, org_id, language,
958: last_update_login, last_updated_by, last_update_date,
959: internal_request_id, request_id, created_by, creation_date,

Line 966: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs

962: dtls.req_template_line_num, hdrs.org_id, dtls.language,
963: dtls.last_update_login, dtls.last_updated_by, dtls.last_update_date,
964: dtls.internal_request_id, dtls.request_id, dtls.created_by, dtls.creation_date,
965: dtls.sequence, dtls.ctx_desc
966: FROM icx_cat_items_ctx_dtls_tlp dtls, icx_cat_items_ctx_hdrs_tlp hdrs
967: WHERE hdrs.source_type = 'GLOBAL_BLANKET'
968: AND hdrs.internal_request_id = p_internal_request_id
969: AND hdrs.inventory_item_id = dtls.inventory_item_id
970: AND hdrs.po_line_id = dtls.po_line_id

Line 1059: INSERT INTO icx_cat_items_ctx_dtls_tlp

1055: EXIT WHEN l_rowid_tbl.COUNT = 0;
1056:
1057: l_err_loc := 600;
1058: FORALL i IN 1..l_rowid_tbl.COUNT
1059: INSERT INTO icx_cat_items_ctx_dtls_tlp
1060: (inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1061: last_update_login, last_updated_by, last_update_date, created_by, creation_date, sequence, ctx_desc)
1062: SELECT inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1063: last_update_login, last_updated_by, last_update_date, created_by, creation_date, 10000, ''

Line 1069: INSERT INTO icx_cat_items_ctx_dtls_tlp

1065: WHERE hdrs.rowid = l_rowid_tbl(i);
1066:
1067: l_err_loc := 700;
1068: FORALL i IN 1..l_rowid_tbl.COUNT
1069: INSERT INTO icx_cat_items_ctx_dtls_tlp
1070: (inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1071: last_update_login, last_updated_by, last_update_date, created_by, creation_date, sequence, ctx_desc)
1072: SELECT inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1073: last_update_login, last_updated_by, last_update_date, created_by, creation_date, 10001, to_char(org_id)

Line 1079: INSERT INTO icx_cat_items_ctx_dtls_tlp

1075: WHERE hdrs.rowid = l_rowid_tbl(i);
1076:
1077: l_err_loc := 800;
1078: FORALL i IN 1..l_rowid_tbl.COUNT
1079: INSERT INTO icx_cat_items_ctx_dtls_tlp
1080: (inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1081: last_update_login, last_updated_by, last_update_date, created_by, creation_date, sequence, ctx_desc)
1082: SELECT inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1083: last_update_login, last_updated_by, last_update_date, created_by, creation_date, 15000, ''

Line 1089: INSERT INTO icx_cat_items_ctx_dtls_tlp

1085: WHERE hdrs.rowid = l_rowid_tbl(i);
1086:
1087: l_err_loc := 900;
1088: FORALL i IN 1..l_rowid_tbl.COUNT
1089: INSERT INTO icx_cat_items_ctx_dtls_tlp
1090: (inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1091: last_update_login, last_updated_by, last_update_date, created_by, creation_date, sequence, ctx_desc)
1092: SELECT inventory_item_id, po_line_id, req_template_name, req_template_line_num, org_id, language,
1093: last_update_login, last_updated_by, last_update_date, created_by, creation_date, 15001,

Line 1264: DELETE FROM icx_cat_items_ctx_dtls_tlp

1260: l_start_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartRegularCatgRow + 1;
1261: l_end_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndRegularCatgRow;
1262: l_err_loc := 800;
1263: FORALL i IN 1..l_rowid_tbl.COUNT
1264: DELETE FROM icx_cat_items_ctx_dtls_tlp
1265: WHERE po_line_id = l_po_line_id_tbl(i)
1266: AND inventory_item_id = l_inventory_item_id_tbl(i)
1267: AND req_template_name = l_req_template_name_tbl(i)
1268: AND req_template_line_num = l_req_template_line_num_tbl(i)

Line 1285: DELETE FROM icx_cat_items_ctx_dtls_tlp

1281: IF p_attribute_key IN ('SUPPLIER_PART_NUM', 'SUPPLIER_PART_AUXID') THEN
1282: l_err_loc := 1100;
1283: -- Delete the row with sequence 1 for re-populate
1284: FORALL i IN 1..l_rowid_tbl.COUNT
1285: DELETE FROM icx_cat_items_ctx_dtls_tlp
1286: WHERE po_line_id = l_po_line_id_tbl(i)
1287: AND inventory_item_id = l_inventory_item_id_tbl(i)
1288: AND req_template_name = l_req_template_name_tbl(i)
1289: AND req_template_line_num = l_req_template_line_num_tbl(i)

Line 1304: DELETE FROM icx_cat_items_ctx_dtls_tlp

1300: ELSIF (p_attribute_key = 'SUPPLIER') THEN
1301: l_err_loc := 1300;
1302: -- Delete the row with sequence 2 for re-populate
1303: FORALL i IN 1..l_rowid_tbl.COUNT
1304: DELETE FROM icx_cat_items_ctx_dtls_tlp
1305: WHERE po_line_id = l_po_line_id_tbl(i)
1306: AND inventory_item_id = l_inventory_item_id_tbl(i)
1307: AND req_template_name = l_req_template_name_tbl(i)
1308: AND req_template_line_num = l_req_template_line_num_tbl(i)

Line 1323: DELETE FROM icx_cat_items_ctx_dtls_tlp

1319: ELSIF (p_attribute_key = 'INTERNAL_ITEM_NUM') THEN
1320: l_err_loc := 1500;
1321: -- Delete the row with sequence 3 for re-populate
1322: FORALL i IN 1..l_rowid_tbl.COUNT
1323: DELETE FROM icx_cat_items_ctx_dtls_tlp
1324: WHERE po_line_id = l_po_line_id_tbl(i)
1325: AND inventory_item_id = l_inventory_item_id_tbl(i)
1326: AND req_template_name = l_req_template_name_tbl(i)
1327: AND req_template_line_num = l_req_template_line_num_tbl(i)

Line 1342: DELETE FROM icx_cat_items_ctx_dtls_tlp

1338: ELSIF (p_attribute_key = 'SOURCE') THEN
1339: l_err_loc := 1700;
1340: -- Delete the row with sequence 4 for re-populate
1341: FORALL i IN 1..l_rowid_tbl.COUNT
1342: DELETE FROM icx_cat_items_ctx_dtls_tlp
1343: WHERE po_line_id = l_po_line_id_tbl(i)
1344: AND inventory_item_id = l_inventory_item_id_tbl(i)
1345: AND req_template_name = l_req_template_name_tbl(i)
1346: AND req_template_line_num = l_req_template_line_num_tbl(i)

Line 1361: DELETE FROM icx_cat_items_ctx_dtls_tlp

1357: ELSIF (p_attribute_key = 'ITEM_REVISION') THEN
1358: l_err_loc := 1900;
1359: -- Delete the row with sequence 5 for re-populate
1360: FORALL i IN 1..l_rowid_tbl.COUNT
1361: DELETE FROM icx_cat_items_ctx_dtls_tlp
1362: WHERE po_line_id = l_po_line_id_tbl(i)
1363: AND inventory_item_id = l_inventory_item_id_tbl(i)
1364: AND req_template_name = l_req_template_name_tbl(i)
1365: AND req_template_line_num = l_req_template_line_num_tbl(i)

Line 1380: DELETE FROM icx_cat_items_ctx_dtls_tlp

1376: ELSIF (p_attribute_key = 'SHOPPING_CATEGORY') THEN
1377: l_err_loc := 2100;
1378: -- Delete the row with sequence 6 for re-populate
1379: FORALL i IN 1..l_rowid_tbl.COUNT
1380: DELETE FROM icx_cat_items_ctx_dtls_tlp
1381: WHERE po_line_id = l_po_line_id_tbl(i)
1382: AND inventory_item_id = l_inventory_item_id_tbl(i)
1383: AND req_template_name = l_req_template_name_tbl(i)
1384: AND req_template_line_num = l_req_template_line_num_tbl(i)

Line 1402: DELETE FROM icx_cat_items_ctx_dtls_tlp

1398: l_start_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartReqularBaseRow + 1;
1399: l_end_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndReqularBaseRow;
1400: l_err_loc := 2400;
1401: FORALL i IN 1..l_rowid_tbl.COUNT
1402: DELETE FROM icx_cat_items_ctx_dtls_tlp
1403: WHERE po_line_id = l_po_line_id_tbl(i)
1404: AND inventory_item_id = l_inventory_item_id_tbl(i)
1405: AND req_template_name = l_req_template_name_tbl(i)
1406: AND req_template_line_num = l_req_template_line_num_tbl(i)

Line 1585: -- delete the appropriate row/rows from icx_cat_items_ctx_dtls_tlp

1581: END IF;
1582:
1583: l_err_loc := 400;
1584: -- update the ctx_desc in icx_cat_items_ctx_hdrs_tlp and
1585: -- delete the appropriate row/rows from icx_cat_items_ctx_dtls_tlp
1586: updateItemsCtxHdrsTlp(0, l_internal_request_id, p_attribute_key);
1587:
1588: l_err_loc := 500;
1589: -- Need to insert the appropriate row/rows back into

Line 1590: -- icx_cat_items_ctx_dtls_tlp depending upon the source and p_attribute_key

1586: updateItemsCtxHdrsTlp(0, l_internal_request_id, p_attribute_key);
1587:
1588: l_err_loc := 500;
1589: -- Need to insert the appropriate row/rows back into
1590: -- icx_cat_items_ctx_dtls_tlp depending upon the source and p_attribute_key
1591: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
1592: (0, l_special_metadata_tbl, l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl);
1593:
1594: l_err_loc := 600;

Line 1857: UPDATE icx_cat_items_ctx_dtls_tlp

1853: l_err_loc := 1000;
1854: IF (l_searchable = 1) THEN
1855: l_err_loc := 1100;
1856: FORALL i IN 1..l_rowid_tbl.COUNT
1857: UPDATE icx_cat_items_ctx_dtls_tlp
1858: SET ctx_desc = '<' || l_section_tag || '>' ||
1859: replace(replace(p_category_name, '<', ' '), '>', ' ') ||
1860: ''
1861: WHERE po_line_id = l_po_line_id_tbl(i)

Line 1881: 'so no changes needed in icx_cat_items_ctx_dtls_tlp; ' ||

1877: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1879: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1880: 'Shopping Category attribute is not searchable, ' ||
1881: 'so no changes needed in icx_cat_items_ctx_dtls_tlp; ' ||
1882: 'l_searchable:' || l_searchable || ', l_section_tag:' || l_section_tag );
1883: END IF;
1884: END IF; -- IF (l_searchable = 1) THEN
1885: