APPS.ICX_POR_SCHEMA_UPLOAD dependencies on ICX_CAT_ITEMS_TLP

Line 98: FROM icx_cat_items_tlp tl,

94:
95: -- get sql table for base attributes
96: OPEN items_tl_cv FOR
97: SELECT tl.rowid, tl.rt_item_id, tl.language
98: FROM icx_cat_items_tlp tl,
99: icx_cat_categories_tl ctl
100: where tl.primary_category_id = ctl.rt_category_id
101: and tl.language = ctl.language
102: and ctl.request_id = p_request_id

Line 125: --vSqlString := 'SELECT rowid,rt_item_id,language FROM ICX_CAT_ITEMS_TLP '||

121: vItemSourceCursor := DBMS_SQL.OPEN_CURSOR;
122: xErrLoc := 520;
123:
124: --Changes for populate_ctx_desc_indexes to not throw invalid ROWID exception
125: --vSqlString := 'SELECT rowid,rt_item_id,language FROM ICX_CAT_ITEMS_TLP '||
126: -- ' WHERE primary_category_id = :catid';
127: vSqlString := 'SELECT rowid,rt_item_id,language FROM ICX_CAT_EXT_ITEMS_TLP '||
128: ' WHERE rt_category_id = :catid';
129: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);

Line 815: -- update icx_cat_items_tlp only if it's a genus category

811: AND LANGUAGE = xLangArray(i);
812:
813: xErrLoc := 140;
814:
815: -- update icx_cat_items_tlp only if it's a genus category
816: IF (p_type = 2) THEN
817: -- set the commit size
818: fnd_profile.get('POR_LOAD_PURGE_COMMIT_SIZE', xCommitSize);
819: xContinue := TRUE;

Line 822: -- Add update for primary_category_name in icx_cat_items_tlp;

818: fnd_profile.get('POR_LOAD_PURGE_COMMIT_SIZE', xCommitSize);
819: xContinue := TRUE;
820: WHILE xContinue LOOP
821: xErrLoc := 150;
822: -- Add update for primary_category_name in icx_cat_items_tlp;
823: UPDATE ICX_CAT_ITEMS_TLP
824: SET primary_category_name = p_name
825: WHERE primary_category_id = p_category_id
826: AND language = xLangArray(i)

Line 823: UPDATE ICX_CAT_ITEMS_TLP

819: xContinue := TRUE;
820: WHILE xContinue LOOP
821: xErrLoc := 150;
822: -- Add update for primary_category_name in icx_cat_items_tlp;
823: UPDATE ICX_CAT_ITEMS_TLP
824: SET primary_category_name = p_name
825: WHERE primary_category_id = p_category_id
826: AND language = xLangArray(i)
827: AND primary_category_name <> p_name

Line 2349: l_stored_in_table := 'ICX_CAT_ITEMS_TLP';

2345: -- descriptor..
2346: -- The stored in table depends on category_id
2347: -- and stored in column depends on descriptor type
2348: if (p_category_id = 0) then
2349: l_stored_in_table := 'ICX_CAT_ITEMS_TLP';
2350: l_column_prefix := 'BASE';
2351: else
2352: l_stored_in_table := 'ICX_CAT_EXT_ITEMS_TLP';
2353: l_column_prefix := 'CAT';

Line 2601: l_stored_in_table := 'ICX_CAT_ITEMS_TLP';

2597: -- The stored in table depends on category_id
2598: -- and stored in column depends on descriptor type
2599:
2600: if (p_category_id = 0) then
2601: l_stored_in_table := 'ICX_CAT_ITEMS_TLP';
2602: l_column_prefix := 'BASE';
2603:
2604: if (p_descriptor_id > NUM_SEEDED_DESCRIPTORS) then
2605: v_section_tag := v_section_tag - 1000;

Line 3099: update_tlp_sql_string := 'UPDATE ICX_CAT_ITEMS_TLP SET ';

3095: -- Process the category read.
3096: xErrLoc := 700;
3097:
3098: IF vRtCategoryIds(i) = 0 THEN
3099: update_tlp_sql_string := 'UPDATE ICX_CAT_ITEMS_TLP SET ';
3100: update_tlp_sql_string := update_tlp_sql_string ||' ('||update_tlp_set_string||' ) = (select ' || update_tlp_value_string|| ' from dual) where primary_category_id = :cat_id';
3101: xErrLoc := 750;
3102: DBMS_SQL.parse(v_cursor_id, update_tlp_sql_string, dbms_sql.native);
3103: -- Reset the values for reading next set of Base attributes for

Line 3225: UPDATE icx_cat_items_tlp

3221: xContinue := TRUE;
3222:
3223: xErrLoc := 120;
3224: WHILE xContinue LOOP
3225: UPDATE icx_cat_items_tlp
3226: SET primary_category_name = p_category_name,
3227: request_id = p_request_id
3228: WHERE primary_category_id=p_category_id
3229: AND language = xLangArray(i)