APPS.ICX_CAT_POPULATE_CATG_PVT dependencies on ICX_POR_CATEGORY_DATA_SOURCES

Line 10: -- Insert into icx_por_category_data_sources and icx_por_category_order_map

6: TYPE g_item_csr_type IS REF CURSOR;
7:
8: gTotalRowCount PLS_INTEGER:= 0;
9:
10: -- Insert into icx_por_category_data_sources and icx_por_category_order_map
11: gInsMapRtCategoryIdTbl DBMS_SQL.NUMBER_TABLE;
12: gInsMapCategoryKeyTbl DBMS_SQL.VARCHAR2_TABLE;
13: gInsMapLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
14:

Line 40: -- Insert into icx_por_category_data_sources and icx_por_category_order_map

36: )
37: IS
38: BEGIN
39: IF (p_action_mode IN ('ALL', 'INSERT_MAPPING')) THEN
40: -- Insert into icx_por_category_data_sources and icx_por_category_order_map
41: gInsMapRtCategoryIdTbl.DELETE;
42: gInsMapCategoryKeyTbl.DELETE;
43: gInsMapLanguageTbl.DELETE;
44: END IF;

Line 86: -- Insert into icx_por_category_data_sources and icx_por_category_order_map

82: l_string VARCHAR2(4000);
83: BEGIN
84: l_string := 'logPLSQLTableRow('||p_action_mode||')['||p_index||']--';
85: IF (p_action_mode = 'INSERT_MAPPING') THEN
86: -- Insert into icx_por_category_data_sources and icx_por_category_order_map
87: l_string := l_string || ' gInsMapRtCategoryIdTbl: ' ||
88: ICX_CAT_UTIL_PVT.getTableElement(gInsMapRtCategoryIdTbl, p_index) || ', ';
89: l_string := l_string || ' gInsMapCategoryKeyTbl: ' ||
90: ICX_CAT_UTIL_PVT.getTableElement(gInsMapCategoryKeyTbl, p_index) || ', ';

Line 160: -- Insert into icx_por_category_data_sources and icx_por_category_order_map

156:
157: l_err_loc := 400;
158: IF (p_action_mode = 'INSERT_MAPPING') THEN
159: l_err_loc := 500;
160: -- Insert into icx_por_category_data_sources and icx_por_category_order_map
161: l_log_string := ' gInsMapRtCategoryIdTbl['||p_index||']: ' ||
162: ICX_CAT_UTIL_PVT.getTableElement(gInsMapRtCategoryIdTbl, p_index) || ', ';
163: FND_LOG.string(p_log_level, l_module_name, l_log_string);
164:

Line 294: -- Insert into icx_por_category_data_sources

290: clearTables(l_action_mode);
291:
292: l_err_loc := 400;
293: l_action_mode := 'INSERT_MAPPING';
294: -- Insert into icx_por_category_data_sources
295: FORALL i in 1..gInsMapRtCategoryIdTbl.COUNT
296: INSERT INTO icx_por_category_data_sources (
297: rt_category_id, category_key, external_source, external_source_key,
298: last_update_login, last_updated_by, last_update_date,

Line 296: INSERT INTO icx_por_category_data_sources (

292: l_err_loc := 400;
293: l_action_mode := 'INSERT_MAPPING';
294: -- Insert into icx_por_category_data_sources
295: FORALL i in 1..gInsMapRtCategoryIdTbl.COUNT
296: INSERT INTO icx_por_category_data_sources (
297: rt_category_id, category_key, external_source, external_source_key,
298: last_update_login, last_updated_by, last_update_date,
299: created_by, creation_date, request_id,
300: program_application_id, program_id)

Line 309: FROM icx_por_category_data_sources

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
310: WHERE external_source = 'Oracle'
311: AND external_source_key = key);
312:
313: l_err_loc := 500;