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_CATG_PVT dependencies on ICX_CAT_ITEMS_CTX_DTLS_TLP

Line 22: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

18: gInsCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
19: gInsLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
20: gInsSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
21:
22: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
23: gInsPOCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
24:
25: -- Update icx_cat_categories_tl
26: gUpdRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;

Line 31: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

27: gUpdCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
28: gUpdLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
29: gUpdSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;
30:
31: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
32: gDelPoCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
33:
34: PROCEDURE clearTables
35: ( p_action_mode IN VARCHAR2

Line 56: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

52: gInsSourceLangTbl.DELETE;
53: END IF;
54:
55: IF (p_action_mode IN ('ALL', 'INSERT_ITEM_CATEGORY')) THEN
56: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
57: gInsPOCategoryIdTbl.DELETE;
58: END IF;
59:
60: IF (p_action_mode IN ('ALL', 'UPDATE_CATEGORY')) THEN

Line 69: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

65: gUpdSourceLangTbl.DELETE;
66: END IF;
67:
68: IF (p_action_mode IN ('ALL', 'DELETE_CATEGORY')) THEN
69: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
70: gDelPoCategoryIdTbl.DELETE;
71: END IF;
72:
73: END clearTables;

Line 110: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

106: ICX_CAT_UTIL_PVT.getTableElement(gInsSourceLangTbl, p_index) || ', ';
107: END IF;
108:
109: IF (p_action_mode IN ('ALL', 'INSERT_ITEM_CATEGORY')) THEN
110: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
111: l_string := l_string || ' gInsPOCategoryIdTbl: ' ||
112: ICX_CAT_UTIL_PVT.getTableElement(gInsPOCategoryIdTbl, p_index) || ', ';
113: END IF;
114:

Line 128: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

124: ICX_CAT_UTIL_PVT.getTableElement(gUpdSourceLangTbl, p_index) || ', ';
125: END IF;
126:
127: IF (p_action_mode = 'DELETE_CATEGORY') THEN
128: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
129: l_string := l_string || ' gDelPoCategoryIdTbl: ' ||
130: ICX_CAT_UTIL_PVT.getTableElement(gDelPoCategoryIdTbl, p_index) || ', ';
131: END IF;
132:

Line 206: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

202: l_err_loc := 800;
203:
204: IF (p_action_mode = 'INSERT_ITEM_CATEGORY') THEN
205: l_err_loc := 900;
206: -- Insert items into icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
207: FND_LOG.string(p_log_level, l_module_name, l_log_string);
208:
209: l_log_string := ' gInsPOCategoryIdTbl['||p_index||']: ' ||
210: ICX_CAT_UTIL_PVT.getTableElement(gInsPOCategoryIdTbl, p_index) || ', ';

Line 242: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables

238: l_err_loc := 1100;
239:
240: IF (p_action_mode = 'DELETE_CATEGORY') THEN
241: l_err_loc := 1200;
242: -- Delete from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp tables
243: FND_LOG.string(p_log_level, l_module_name, l_log_string);
244:
245: l_log_string := ' gDelPoCategoryIdTbl['||p_index||']: ' ||
246: ICX_CAT_UTIL_PVT.getTableElement(gDelPoCategoryIdTbl, p_index) || ', ';

Line 457: UPDATE icx_cat_items_ctx_dtls_tlp dtls

453:
454: l_err_loc := 1000;
455: IF (l_searchable = 1) THEN
456: FORALL j IN 1..l_rowid_tbl.COUNT
457: UPDATE icx_cat_items_ctx_dtls_tlp dtls
458: SET ctx_desc = (SELECT '<' ||to_char(l_section_tag) ||'>' ||
459: gUpdCategoryNameTbl(i) || ''
460: FROM icx_cat_items_ctx_hdrs_tlp hdrs
461: WHERE hdrs.rowid = l_rowid_tbl(j)

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

489: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
491: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
492: 'Shopping Category attribute is not searchable, ' ||
493: 'so no changes needed in icx_cat_items_ctx_dtls_tlp; ' ||
494: 'l_searchable:' || l_searchable || ', l_section_tag:' || l_section_tag );
495: END IF;
496: END IF; -- IF (l_searchable = 1) THEN
497:

Line 618: DELETE FROM icx_cat_items_ctx_dtls_tlp

614: END IF;
615:
616: l_err_loc := 600;
617: FORALL j IN 1..l_po_line_id_tbl.COUNT
618: DELETE FROM icx_cat_items_ctx_dtls_tlp
619: WHERE po_line_id = l_po_line_id_tbl(j)
620: AND req_template_name = l_req_template_name_tbl(j)
621: AND req_template_line_num = l_req_template_line_num_tbl(j)
622: AND inventory_item_id = l_inventory_item_id_tbl(j)