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_CATEGORIES_TL

Line 15: -- Insert into icx_cat_categories_tl

11: gInsMapRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
12: gInsMapCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
13: gInsMapLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
14:
15: -- Insert into icx_cat_categories_tl
16: gInsRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
17: gInsCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
18: gInsCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
19: gInsLanguageTbl DBMS_SQL.VARCHAR2_TABLE;

Line 25: -- Update icx_cat_categories_tl

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;
27: gUpdCategoryNameTbl DBMS_SQL.VARCHAR2_TABLE;
28: gUpdLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
29: gUpdSourceLangTbl DBMS_SQL.VARCHAR2_TABLE;

Line 47: -- Insert into icx_cat_categories_tl

43: gInsMapLanguageTbl.DELETE;
44: END IF;
45:
46: IF (p_action_mode IN ('ALL', 'INSERT_CATEGORY')) THEN
47: -- Insert into icx_cat_categories_tl
48: gInsRtCategoryIdTbl.DELETE;
49: gInsCategoryKeyTbl.DELETE;
50: gInsCategoryNameTbl.DELETE;
51: gInsLanguageTbl.DELETE;

Line 61: -- Update icx_cat_categories_tl

57: gInsPOCategoryIdTbl.DELETE;
58: END IF;
59:
60: IF (p_action_mode IN ('ALL', 'UPDATE_CATEGORY')) THEN
61: -- Update icx_cat_categories_tl
62: gUpdRtCategoryIdTbl.DELETE;
63: gUpdCategoryNameTbl.DELETE;
64: gUpdLanguageTbl.DELETE;
65: gUpdSourceLangTbl.DELETE;

Line 96: -- Insert into icx_cat_categories_tl

92: ICX_CAT_UTIL_PVT.getTableElement(gInsMapLanguageTbl, p_index) || ', ';
93: END IF;
94:
95: IF (p_action_mode = 'INSERT_CATEGORY') THEN
96: -- Insert into icx_cat_categories_tl
97: l_string := l_string || ' gInsRtCategoryIdTbl: ' ||
98: ICX_CAT_UTIL_PVT.getTableElement(gInsRtCategoryIdTbl, p_index) || ', ';
99: l_string := l_string || ' gInsCategoryKeyTbl: ' ||
100: ICX_CAT_UTIL_PVT.getTableElement(gInsCategoryKeyTbl, p_index) || ', ';

Line 116: -- Update icx_cat_categories_tl

112: ICX_CAT_UTIL_PVT.getTableElement(gInsPOCategoryIdTbl, p_index) || ', ';
113: END IF;
114:
115: IF (p_action_mode = 'UPDATE_CATEGORY') THEN
116: -- Update icx_cat_categories_tl
117: l_string := l_string || ' gUpdRtCategoryIdTbl: ' ||
118: ICX_CAT_UTIL_PVT.getTableElement(gUpdRtCategoryIdTbl, p_index) || ', ';
119: l_string := l_string || ' gUpdCategoryNameTbl: ' ||
120: ICX_CAT_UTIL_PVT.getTableElement(gUpdCategoryNameTbl, p_index) || ', ';

Line 178: -- Insert into icx_cat_categories_tl

174: l_err_loc := 600;
175:
176: IF (p_action_mode = 'INSERT_CATEGORY') THEN
177: l_err_loc := 700;
178: -- Insert into icx_cat_categories_tl
179: FND_LOG.string(p_log_level, l_module_name, l_log_string);
180:
181: l_log_string := ' gInsRtCategoryIdTbl['||p_index||']: ' ||
182: ICX_CAT_UTIL_PVT.getTableElement(gInsRtCategoryIdTbl, p_index) || ', ';

Line 218: -- Update icx_cat_categories_tl

214: l_err_loc := 900;
215:
216: IF (p_action_mode = 'UPDATE_CATEGORY') THEN
217: l_err_loc := 1000;
218: -- Update icx_cat_categories_tl
219: FND_LOG.string(p_log_level, l_module_name, l_log_string);
220:
221: l_log_string := ' gUpdRtCategoryIdTbl['||p_index||']: ' ||
222: ICX_CAT_UTIL_PVT.getTableElement(gUpdRtCategoryIdTbl, p_index) || ', ';

Line 263: -- Insert into icx_cat_categories_tl

259: l_action_mode VARCHAR2(80);
260: BEGIN
261: l_err_loc := 100;
262: l_action_mode := 'INSERT_CATEGORY';
263: -- Insert into icx_cat_categories_tl
264: FORALL i IN 1..gInsRtCategoryIdTbl.COUNT
265: INSERT INTO icx_cat_categories_tl(
266: rt_category_id, category_name, key, title, type, language,
267: source_lang, upper_category_name, upper_key, section_map,

Line 265: INSERT INTO icx_cat_categories_tl(

261: l_err_loc := 100;
262: l_action_mode := 'INSERT_CATEGORY';
263: -- Insert into icx_cat_categories_tl
264: FORALL i IN 1..gInsRtCategoryIdTbl.COUNT
265: INSERT INTO icx_cat_categories_tl(
266: rt_category_id, category_name, key, title, type, language,
267: source_lang, upper_category_name, upper_key, section_map,
268: last_update_login, last_updated_by, last_update_date,
269: created_by, creation_date, request_id,

Line 305: FROM icx_cat_categories_tl

301: SELECT rt_category_id, key, 'Oracle', key,
302: ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id, sysdate,
303: ICX_CAT_UTIL_PVT.g_who_columns_rec.user_id, sysdate, ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
304: ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id, ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id
305: FROM icx_cat_categories_tl
306: WHERE rt_category_id = gInsMapRtCategoryIdTbl(i)
307: AND language = gInsMapLanguageTbl(i)
308: AND NOT EXISTS (SELECT 1
309: FROM icx_por_category_data_sources

Line 519: -- Update icx_cat_categories_tl

515: l_err_loc := 1300;
516: END LOOP;
517:
518: l_err_loc := 1400;
519: -- Update icx_cat_categories_tl
520: FORALL i IN 1..gUpdRtCategoryIdTbl.COUNT
521: UPDATE icx_cat_categories_tl
522: SET category_name = gUpdCategoryNameTbl(i),
523: upper_category_name = upper(gUpdCategoryNameTbl(i)),

Line 521: UPDATE icx_cat_categories_tl

517:
518: l_err_loc := 1400;
519: -- Update icx_cat_categories_tl
520: FORALL i IN 1..gUpdRtCategoryIdTbl.COUNT
521: UPDATE icx_cat_categories_tl
522: SET category_name = gUpdCategoryNameTbl(i),
523: upper_category_name = upper(gUpdCategoryNameTbl(i)),
524: source_lang = gUpdSourceLangTbl(i),
525: last_update_login = ICX_CAT_UTIL_PVT.g_who_columns_rec.login_id,

Line 540: 'Num. of rows updated in icx_cat_categories_tl:' ||SQL%ROWCOUNT);

536: IF (gUpdRtCategoryIdTbl.COUNT > 0) THEN
537: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
539: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
540: 'Num. of rows updated in icx_cat_categories_tl:' ||SQL%ROWCOUNT);
541: END IF;
542: END IF;
543:
544: l_err_loc := 1600;

Line 770: FROM icx_cat_categories_tl

766: BEGIN
767: IF (p_rt_category_id IS NULL) THEN
768: SELECT count(1)
769: INTO l_num_val
770: FROM icx_cat_categories_tl
771: WHERE upper_category_name = UPPER(p_category_name);
772: ELSE
773: SELECT count(1)
774: INTO l_num_val

Line 775: FROM icx_cat_categories_tl

771: WHERE upper_category_name = UPPER(p_category_name);
772: ELSE
773: SELECT count(1)
774: INTO l_num_val
775: FROM icx_cat_categories_tl
776: WHERE upper_category_name = UPPER(p_category_name)
777: AND rt_category_id <> p_rt_category_id;
778: END IF;
779:

Line 1058: icx_cat_categories_tl icat,

1054: nvl(mck.end_date_active, SYSDATE+1), nvl(mck.disable_date, SYSDATE+1),
1055: SYSDATE system_date
1056: FROM mtl_categories_kfv mck,
1057: mtl_categories_tl mctl,
1058: icx_cat_categories_tl icat,
1059: icx_cat_categories_tl icat2
1060: WHERE mck.category_id = P_CATEGORY_ID
1061: AND mck.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
1062: AND mctl.category_id = mck.category_id

Line 1059: icx_cat_categories_tl icat2

1055: SYSDATE system_date
1056: FROM mtl_categories_kfv mck,
1057: mtl_categories_tl mctl,
1058: icx_cat_categories_tl icat,
1059: icx_cat_categories_tl icat2
1060: WHERE mck.category_id = P_CATEGORY_ID
1061: AND mck.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
1062: AND mctl.category_id = mck.category_id
1063: AND mctl.language IN (SELECT language_code FROM fnd_languages WHERE installed_flag IN ('B', 'I'))

Line 1119: icx_cat_categories_tl icat,

1115: SYSDATE system_date
1116: FROM mtl_categories_kfv mck,
1117: mtl_categories_tl mctl,
1118: mtl_category_set_valid_cats mcsvc,
1119: icx_cat_categories_tl icat,
1120: icx_cat_categories_tl icat2
1121: WHERE mck.category_id = P_CATEGORY_ID
1122: AND mck.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
1123: AND mctl.category_id = mck.category_id

Line 1120: icx_cat_categories_tl icat2

1116: FROM mtl_categories_kfv mck,
1117: mtl_categories_tl mctl,
1118: mtl_category_set_valid_cats mcsvc,
1119: icx_cat_categories_tl icat,
1120: icx_cat_categories_tl icat2
1121: WHERE mck.category_id = P_CATEGORY_ID
1122: AND mck.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
1123: AND mctl.category_id = mck.category_id
1124: AND mctl.language IN (SELECT language_code FROM fnd_languages WHERE installed_flag IN ('B', 'I'))