DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_AUCTION_ATTR_MAPPING_B

Line 1677: DELETE FROM pon_auction_attr_mapping_b

1673: END IF;
1674:
1675: /* Begin Supplier Management: Mapping */
1676: IF (FND_PROFILE.VALUE('POS_SM_ENABLE_SPM_EXTENSION') = 'Y') THEN
1677: DELETE FROM pon_auction_attr_mapping_b
1678: WHERE auction_header_id = p_auction_header_id
1679: AND line_number >= l_batch_start
1680: AND line_number <= l_batch_end
1681: AND mapping_type IN ('ITEM_LINE', 'CAT_LINE');

Line 2157: DELETE FROM pon_auction_attr_mapping_b

2153: END IF;
2154:
2155: /* Begin Supplier Management: Mapping */
2156: IF (FND_PROFILE.VALUE('POS_SM_ENABLE_SPM_EXTENSION') = 'Y') THEN
2157: DELETE FROM pon_auction_attr_mapping_b
2158: WHERE auction_header_id = p_auction_header_id
2159: AND line_number = p_line_number
2160: AND mapping_type IN ('ITEM_LINE', 'CAT_LINE');
2161: END IF;

Line 2681: DELETE FROM pon_auction_attr_mapping_b

2677: END IF;
2678:
2679: /* Begin Supplier Management: Mapping */
2680: IF (FND_PROFILE.VALUE('POS_SM_ENABLE_SPM_EXTENSION') = 'Y') THEN
2681: DELETE FROM pon_auction_attr_mapping_b
2682: WHERE auction_header_id = p_auction_header_id
2683: AND (line_number = p_line_number OR
2684: ( line_number IN ( SELECT line_number
2685: FROM pon_auction_item_prices_all