APPS.PON_NEGOTIATION_HELPER_PVT dependencies on FND_PROFILE

Line 1676: IF (FND_PROFILE.VALUE('POS_SM_ENABLE_SPM_EXTENSION') = 'Y') THEN

1672: END IF;
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

Line 2156: IF (FND_PROFILE.VALUE('POS_SM_ENABLE_SPM_EXTENSION') = 'Y') THEN

2152: END IF;
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');

Line 2680: IF (FND_PROFILE.VALUE('POS_SM_ENABLE_SPM_EXTENSION') = 'Y') THEN

2676: message => 'Deleting the lines');
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