APPS.ICX_POR_EXT_TEST dependencies on ICX_CAT_ITEMS_TLP

Line 766: 'Delete test data from icx_cat_items_tlp');

762: CLOSE cTestRows;
763:
764: xErrLoc:= 500;
765: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
766: 'Delete test data from icx_cat_items_tlp');
767: xErrLoc:= 520;
768: xRowCount := 0;
769: OPEN cTestRows FOR
770: SELECT ROWID FROM icx_cat_items_tlp

Line 770: SELECT ROWID FROM icx_cat_items_tlp

766: 'Delete test data from icx_cat_items_tlp');
767: xErrLoc:= 520;
768: xRowCount := 0;
769: OPEN cTestRows FOR
770: SELECT ROWID FROM icx_cat_items_tlp
771: WHERE last_updated_by = TEST_USER_ID;
772: xErrLoc := 540;
773: LOOP
774: xRowIds.DELETE;

Line 783: DELETE icx_cat_items_tlp

779: EXIT WHEN xRowIds.COUNT = 0;
780: xRowCount := xRowCount + xRowIds.COUNT;
781: xErrLoc := 580;
782: FORALL i IN 1..xRowIds.COUNT
783: DELETE icx_cat_items_tlp
784: WHERE rowid = xRowIds(i);
785: COMMIT;
786: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.INFO_LEVEL,
787: 'Processed records: ' || xRowCount);

Line 3478: FROM icx_cat_items_tlp

3474: BEGIN
3475: xErrLoc:= 100;
3476: SELECT primary_category_id
3477: INTO p_primary_category_id
3478: FROM icx_cat_items_tlp
3479: WHERE rt_item_id = p_rt_item_id
3480: AND language = p_language
3481: AND item_source_type = p_item_source_type
3482: AND search_type = p_search_type

Line 3520: '] exists in ICX_CAT_ITEMS_TLP');

3516: ', SUPPLIER_PART_NUM: ' || p_supplier_part_num ||
3517: ', DESCRIPTION: ' || p_description ||
3518: ', PICTURE: ' || p_picture ||
3519: ', PICTURE_URL: ' || p_picture_url ||
3520: '] exists in ICX_CAT_ITEMS_TLP');
3521:
3522: xErrLoc:= 200;
3523: RETURN TRUE;
3524: EXCEPTION

Line 3542: '] does not exist in ICX_CAT_ITEMS_TLP');

3538: ', SUPPLIER_PART_NUM: ' || p_supplier_part_num ||
3539: ', DESCRIPTION: ' || p_description ||
3540: ', PICTURE: ' || p_picture ||
3541: ', PICTURE_URL: ' || p_picture_url ||
3542: '] does not exist in ICX_CAT_ITEMS_TLP');
3543: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3544: 'ItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3545: ', LANGUAGE: ' || p_language ||
3546: ', ITEM_SOURCE_TYPE: ' || p_item_source_type ||

Line 3558: '] does not exist in ICX_CAT_ITEMS_TLP');

3554: ', SUPPLIER_PART_NUM: ' || p_supplier_part_num ||
3555: ', DESCRIPTION: ' || p_description ||
3556: ', PICTURE: ' || p_picture ||
3557: ', PICTURE_URL: ' || p_picture_url ||
3558: '] does not exist in ICX_CAT_ITEMS_TLP');
3559: RETURN FALSE;
3560: WHEN OTHERS THEN
3561: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.existItemsTLP-'||
3562: xErrLoc||' '||SQLERRM);

Line 3576: FROM icx_cat_items_tlp

3572: BEGIN
3573: xErrLoc:= 100;
3574: SELECT 0
3575: INTO xResult
3576: FROM icx_cat_items_tlp
3577: WHERE rt_item_id = p_rt_item_id
3578: AND language = p_language;
3579:
3580: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,

Line 3583: '] does not exist in ICX_CAT_ITEMS_TLP');

3579:
3580: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
3581: 'ItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3582: ', LANGUAGE: ' || p_language ||
3583: '] does not exist in ICX_CAT_ITEMS_TLP');
3584: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3585: 'ItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3586: ', LANGUAGE: ' || p_language ||
3587: '] does not exist in ICX_CAT_ITEMS_TLP');

Line 3587: '] does not exist in ICX_CAT_ITEMS_TLP');

3583: '] does not exist in ICX_CAT_ITEMS_TLP');
3584: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
3585: 'ItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3586: ', LANGUAGE: ' || p_language ||
3587: '] does not exist in ICX_CAT_ITEMS_TLP');
3588:
3589: xErrLoc:= 200;
3590: RETURN FALSE;
3591: EXCEPTION

Line 3597: '] exists in ICX_CAT_ITEMS_TLP');

3593: xResult:= 0;
3594: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ANLYS_LEVEL,
3595: 'ItemsTLP[RT_ITEM_ID: ' || p_rt_item_id ||
3596: ', LANGUAGE: ' || p_language ||
3597: '] exists in ICX_CAT_ITEMS_TLP');
3598: RETURN TRUE;
3599: WHEN OTHERS THEN
3600: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.notExistItemsTLP-'||
3601: xErrLoc||' '||SQLERRM);