APPS.ICX_POR_DELETE_CATALOG dependencies on DBMS_SQL

Line 64: l_rt_item_ids DBMS_SQL.NUMBER_TABLE;

60: SELECT rt_item_id
61: FROM icx_cat_category_items
62: WHERE rt_category_id = c_rt_category_id;
63:
64: l_rt_item_ids DBMS_SQL.NUMBER_TABLE;
65:
66: xCommitSize PLS_INTEGER := 2000;
67: xErrLoc PLS_INTEGER := 0;
68: BEGIN

Line 146: l_rt_item_ids DBMS_SQL.NUMBER_TABLE;

142: FROM icx_cat_items_b
143: WHERE catalog_name = c_catalog_name
144: AND extractor_updated_flag = 'N';
145:
146: l_rt_item_ids DBMS_SQL.NUMBER_TABLE;
147:
148: xCommitSize PLS_INTEGER := 2000;
149: xErrLoc PLS_INTEGER := 0;
150: BEGIN

Line 228: l_rt_item_ids DBMS_SQL.NUMBER_TABLE;

224: WHERE supplier = c_supplier
225: AND org_id = c_operating_unit_id
226: AND extractor_updated_flag = 'N';
227:
228: l_rt_item_ids DBMS_SQL.NUMBER_TABLE;
229:
230: xCommitSize PLS_INTEGER := 2000;
231: xErrLoc PLS_INTEGER := 0;
232: BEGIN

Line 294: PROCEDURE delPriceHistory(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)

290: /**
291: ** Proc : delPriceHistory
292: ** Desc : Deletes the data from ICX_CAT_PRICE_HISTORY
293: **/
294: PROCEDURE delPriceHistory(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
295: IS
296: xErrLoc PLS_INTEGER := 0;
297: xContinue BOOLEAN := TRUE;
298:

Line 330: PROCEDURE delItemsTLP(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)

326: /**
327: ** Proc : delItemsTLP
328: ** Desc : Deletes the data from ICX_CAT_ITEMS_TLP
329: **/
330: PROCEDURE delItemsTLP(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
331: IS
332: xErrLoc PLS_INTEGER := 0;
333: xContinue BOOLEAN := TRUE;
334:

Line 366: PROCEDURE delExtItemsTLP(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)

362: /**
363: ** Proc : delExtItemsTLP
364: ** Desc : Deletes the data from ICX_CAT_EXT_ITEMS_TLP
365: **/
366: PROCEDURE delExtItemsTLP(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
367: IS
368: xErrLoc PLS_INTEGER := 0;
369: xContinue BOOLEAN := TRUE;
370:

Line 402: PROCEDURE delItemsCtxTLP(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)

398: /**
399: ** Proc : delItemsCtxTLP
400: ** Desc : Deletes the data from ICX_CAT_ITEMS_CTX_TLP
401: **/
402: PROCEDURE delItemsCtxTLP(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
403: IS
404: xErrLoc PLS_INTEGER := 0;
405: xContinue BOOLEAN := TRUE;
406:

Line 438: PROCEDURE delFavoriteList(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)

434: /**
435: ** Proc : delFavoriteList
436: ** Desc : Deletes the data from POR_FAVORITE_LIST_LINES
437: **/
438: PROCEDURE delFavoriteList(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
439: IS
440: xErrLoc PLS_INTEGER := 0;
441: xContinue BOOLEAN := TRUE;
442:

Line 474: PROCEDURE delCategoryItems(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)

470: /**
471: ** Proc : delCategoryItems
472: ** Desc : Deletes the data from ICX_CAT_CATEGORY_ITEMS
473: **/
474: PROCEDURE delCategoryItems(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
475: IS
476: xErrLoc PLS_INTEGER := 0;
477: xContinue BOOLEAN := TRUE;
478:

Line 510: PROCEDURE delPriceLists(pPriceListIds IN DBMS_SQL.NUMBER_TABLE)

506: /**
507: ** Proc : delPriceLists
508: ** Desc : Deletes the data from ICX_CAT_PRICE_LISTS
509: **/
510: PROCEDURE delPriceLists(pPriceListIds IN DBMS_SQL.NUMBER_TABLE)
511: IS
512: xErrLoc PLS_INTEGER := 0;
513: BEGIN
514: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_PRICE_LISTS');

Line 539: PROCEDURE delItemPrices(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)

535: /**
536: ** Proc : delItemPrices
537: ** Desc : Deletes the data from ICX_CAT_ITEM_PRICES
538: **/
539: PROCEDURE delItemPrices(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
540: IS
541: xErrLoc PLS_INTEGER := 0;
542: xContinue BOOLEAN := TRUE;
543: xPriceListIds DBMS_SQL.NUMBER_TABLE;

Line 543: xPriceListIds DBMS_SQL.NUMBER_TABLE;

539: PROCEDURE delItemPrices(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
540: IS
541: xErrLoc PLS_INTEGER := 0;
542: xContinue BOOLEAN := TRUE;
543: xPriceListIds DBMS_SQL.NUMBER_TABLE;
544:
545: BEGIN
546: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEM_PRICES');
547: xErrLoc := 100;

Line 583: PROCEDURE delItemsB(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)

579: /**
580: ** Proc : delItemsB
581: ** Desc : Deletes the data from ICX_CAT_ITEMS_B
582: **/
583: PROCEDURE delItemsB(pRtItemIds IN DBMS_SQL.NUMBER_TABLE)
584: IS
585: xErrLoc PLS_INTEGER := 0;
586: xContinue BOOLEAN := TRUE;
587:

Line 619: PROCEDURE deleteCommonTables(pRtItemIds IN dbms_sql.number_table,

615: /**
616: ** Proc : deleteCommonTables
617: ** Desc : Deletes the data from common tables used by Extractor and DeleteCatalog
618: **/
619: PROCEDURE deleteCommonTables(pRtItemIds IN dbms_sql.number_table,
620: pDeleteOrder IN PLS_INTEGER DEFAULT ITEM_TABLE_LAST)
621: IS
622: xErrLoc PLS_INTEGER := 0;
623: