DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PON_AUCTION_PKG

Line 2382: 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

2378: IF (NVL(l_progress_payment_type,'NONE') = 'NONE') THEN
2379: update pon_item_prices_interface p1
2380: set ip_category_name = (select category_name
2381: from icx_cat_categories_v
2382: 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
2383: language = p_language)
2384: where batch_id = p_batch_id and
2385: (action is null or action = '+') and
2386: p1.category_id <> -1 and