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_HDRS_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 410: UPDATE icx_cat_items_ctx_hdrs_tlp

406: l_err_loc := 400;
407: l_rowid_tbl.DELETE;
408:
409: l_err_loc := 500;
410: UPDATE icx_cat_items_ctx_hdrs_tlp
411: SET ctx_desc = null,
412: ip_category_name = gUpdCategoryNameTbl(i),
413: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,
414: last_updated_by = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,

Line 460: FROM icx_cat_items_ctx_hdrs_tlp hdrs

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)
462: AND hdrs.po_line_id = dtls.po_line_id
463: AND hdrs.req_template_name = dtls.req_template_name
464: AND hdrs.req_template_line_num = dtls.req_template_line_num

Line 469: AND EXISTS ( SELECT 'x' FROM icx_cat_items_ctx_hdrs_tlp hdrs

465: AND hdrs.inventory_item_id = dtls.inventory_item_id
466: AND hdrs.org_id = dtls.org_id
467: AND hdrs.language = dtls.language)
468: WHERE sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow
469: AND EXISTS ( SELECT 'x' FROM icx_cat_items_ctx_hdrs_tlp hdrs
470: WHERE hdrs.po_line_id = dtls.po_line_id
471: AND hdrs.req_template_name = dtls.req_template_name
472: AND hdrs.req_template_line_num = dtls.req_template_line_num
473: AND hdrs.inventory_item_id = dtls.inventory_item_id

Line 595: DELETE FROM icx_cat_items_ctx_hdrs_tlp

591: l_language_tbl.DELETE;
592:
593: l_err_loc := 400;
594: -- Category deletion, in R12 we only delete the master items
595: DELETE FROM icx_cat_items_ctx_hdrs_tlp
596: WHERE po_category_id = gDelPoCategoryIdTbl(i)
597: AND source_type = 'MASTER_ITEM'
598: AND rownum <= ICX_CAT_UTIL_PVT.g_batch_size
599: RETURNING po_line_id, req_template_name, req_template_line_num,