APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_PRICE_DIFFER_INTERFACE

Line 1478: FROM pon_price_differ_interface

1474: SET has_price_differentials_flag = 'Y',
1475: differential_response_type = 'OPTIONAL'
1476: WHERE (line_number) IN
1477: (SELECT interface_line_number
1478: FROM pon_price_differ_interface
1479: WHERE interface_auction_header_id = p_interface_id
1480: AND interface_line_number >= l_batch_start
1481: AND interface_line_number <= l_batch_end
1482: AND interface_shipment_number = -1)

Line 1713: FROM pon_price_differ_interface

1709: SET has_price_differentials_flag = 'Y',
1710: differential_response_type = 'OPTIONAL'
1711: WHERE (shipment_number) IN
1712: (SELECT interface_shipment_number
1713: FROM pon_price_differ_interface
1714: WHERE interface_auction_header_id = p_interface_id
1715: AND interface_shipment_number <> -1)
1716: AND auction_header_id = x_document_number;
1717:

Line 1752: FROM pon_price_differ_interface

1748: Sysdate, -- creation_date
1749: g_header_rec.user_id, -- created_by
1750: Sysdate, -- last_update_date
1751: g_header_rec.user_id -- last_updated_by
1752: FROM pon_price_differ_interface
1753: WHERE interface_auction_header_id = p_interface_id
1754: AND interface_line_number >= l_batch_start
1755: AND interface_line_number <= l_batch_end
1756: AND interface_shipment_number = -1;

Line 1800: FROM pon_price_differ_interface

1796: Sysdate, -- creation_date
1797: g_header_rec.user_id, -- created_by
1798: Sysdate, -- last_update_date
1799: g_header_rec.user_id -- last_updated_by
1800: FROM pon_price_differ_interface
1801: WHERE interface_auction_header_id = p_interface_id
1802: AND interface_line_number >= l_batch_start
1803: AND interface_line_number <= l_batch_end
1804: AND interface_shipment_number <> -1

Line 2832: DELETE FROM pon_price_differ_interface

2828: -- ADDED FOR SERVICES PROCUREMENT PROJECT
2829: -- Delete records from price differentials table
2830: v_debug_status := 'DELETE_PRICE_DIFFERENTIALS';
2831:
2832: DELETE FROM pon_price_differ_interface
2833: WHERE interface_auction_header_id = p_interface_id;
2834:
2835: -- Delete records from attachments table
2836: v_debug_status := ' DELETE_ATTACHMENTS';