APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on ICX_CAT_CATEGORIES_V

Line 2584: from icx_cat_categories_v

2580: -- is optional
2581: IF (NVL(l_progress_payment_type,'NONE') = 'NONE') THEN
2582: update pon_item_prices_interface p1
2583: set ip_category_name = (select category_name
2584: from icx_cat_categories_v
2585: where rt_category_id = decode(pon_auction_pkg.get_mapped_ip_category(p1.category_id), -2, null, pon_auction_pkg.get_mapped_ip_category(p1.category_id)) and
2586: language = p_language)
2587: where batch_id = p_batch_id and
2588: (action is null or action = '+') and

Line 2612: from icx_cat_categories_v icx

2608: where p1.batch_id = p_batch_id and
2609: p1.ip_category_name is not null and
2610: p1.ip_category_name <> 'IP_CAT_NONE_ENTERED' and
2611: not exists (select null
2612: from icx_cat_categories_v icx
2613: where icx.category_name = p1.ip_category_name and
2614: icx.language = p_language)
2615: AND Nvl(clm_info_flag,'N') <> 'Y';
2616:

Line 2625: from icx_cat_categories_v icx

2621: where p1.batch_id = p_batch_id and
2622: p1.ip_category_name is not null and
2623: p1.ip_category_name <> 'IP_CAT_NONE_ENTERED' and
2624: not exists (select null
2625: from icx_cat_categories_v icx
2626: where icx.category_name = p1.ip_category_name and
2627: icx.language = p_language);
2628:
2629: -- set ip category id

Line 2632: from icx_cat_categories_v icx

2628:
2629: -- set ip category id
2630: update pon_item_prices_interface p1
2631: set ip_category_id = (select rt_category_id
2632: from icx_cat_categories_v icx
2633: where icx.category_name = p1.ip_category_name and
2634: language = p_language and rownum=1 )
2635: where p1.batch_id = p_batch_id and
2636: p1.ip_category_name is not null and