APPS.ICX_CAT_POPULATE_CATG_PVT dependencies on ICX_POR_CATEGORY_ORDER_MAP

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 323: -- Insert into icx_por_category_order_map

319: END IF;
320: END IF;
321:
322: l_err_loc := 600;
323: -- Insert into icx_por_category_order_map
324: FORALL i IN 1..gInsMapRtCategoryIdTbl.COUNT
325: INSERT INTO icx_por_category_order_map (
326: rt_category_id, external_source, external_source_key,
327: last_update_login, last_updated_by, last_update_date,

Line 325: INSERT INTO icx_por_category_order_map (

321:
322: l_err_loc := 600;
323: -- Insert into icx_por_category_order_map
324: FORALL i IN 1..gInsMapRtCategoryIdTbl.COUNT
325: INSERT INTO icx_por_category_order_map (
326: rt_category_id, external_source, external_source_key,
327: last_update_login, last_updated_by, last_update_date,
328: created_by, creation_date)
329: VALUES(gInsMapRtCategoryIdTbl(i), 'Oracle', gInsMapCategoryKeyTbl(i),