APPS.ICX_POR_CTX_DESC dependencies on ICX_CAT_ITEMS_B

Line 281: from icx_cat_category_items cit, icx_cat_items_b it

277: where des.rt_category_id = cat.rt_category_id
278: and des.language = cat.language
279: and des.searchable = 1)
280: AND exists (select 'X'
281: from icx_cat_category_items cit, icx_cat_items_b it
282: where cit.rt_category_id = cat.rt_category_id
283: and cit.rt_item_id = it.rt_item_id
284: and it.request_id = p_jobNum);
285: BEGIN

Line 313: vSqlString := 'SELECT tlp.rowid,tlp.rt_item_id,tlp.language FROM ICX_CAT_EXT_ITEMS_TLP tlp, icx_cat_items_b it where tlp.rt_category_id = :category_id and it.rt_item_id=tlp.rt_item_id and it.request_id=:request_id';

309: vCategoryId := catRec.rt_category_id;
310: vItemSourceCursor := DBMS_SQL.OPEN_CURSOR;
311: xErrLoc := 220;
312: -- OEX_IP_PORTING
313: vSqlString := 'SELECT tlp.rowid,tlp.rt_item_id,tlp.language FROM ICX_CAT_EXT_ITEMS_TLP tlp, icx_cat_items_b it where tlp.rt_category_id = :category_id and it.rt_item_id=tlp.rt_item_id and it.request_id=:request_id';
314: xErrLoc := 230;
315: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);
316: xErrLoc := 235;
317: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',vCategoryId);