APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_PRICE_DIFFER_INTERFACE

Line 1198: FROM pon_price_differ_interface

1194: SET has_price_differentials_flag = 'Y',
1195: differential_response_type = 'OPTIONAL'
1196: WHERE (line_number) IN
1197: (SELECT interface_line_number
1198: FROM pon_price_differ_interface
1199: WHERE interface_auction_header_id = p_interface_id
1200: AND interface_line_number >= l_batch_start
1201: AND interface_line_number <= l_batch_end
1202: AND interface_shipment_number = -1)

Line 1289: FROM pon_price_differ_interface

1285: SET has_price_differentials_flag = 'Y',
1286: differential_response_type = 'OPTIONAL'
1287: WHERE (shipment_number) IN
1288: (SELECT interface_shipment_number
1289: FROM pon_price_differ_interface
1290: WHERE interface_auction_header_id = p_interface_id
1291: AND interface_shipment_number <> -1)
1292: AND auction_header_id = x_document_number;
1293:

Line 1328: FROM pon_price_differ_interface

1324: Sysdate, -- creation_date
1325: g_header_rec.user_id, -- created_by
1326: Sysdate, -- last_update_date
1327: g_header_rec.user_id -- last_updated_by
1328: FROM pon_price_differ_interface
1329: WHERE interface_auction_header_id = p_interface_id
1330: AND interface_line_number >= l_batch_start
1331: AND interface_line_number <= l_batch_end
1332: AND interface_shipment_number = -1;

Line 1376: FROM pon_price_differ_interface

1372: Sysdate, -- creation_date
1373: g_header_rec.user_id, -- created_by
1374: Sysdate, -- last_update_date
1375: g_header_rec.user_id -- last_updated_by
1376: FROM pon_price_differ_interface
1377: WHERE interface_auction_header_id = p_interface_id
1378: AND interface_line_number >= l_batch_start
1379: AND interface_line_number <= l_batch_end
1380: AND interface_shipment_number <> -1

Line 2347: DELETE FROM pon_price_differ_interface

2343: -- ADDED FOR SERVICES PROCUREMENT PROJECT
2344: -- Delete records from price differentials table
2345: v_debug_status := 'DELETE_PRICE_DIFFERENTIALS';
2346:
2347: DELETE FROM pon_price_differ_interface
2348: WHERE interface_auction_header_id = p_interface_id;
2349:
2350: -- Delete records from attachments table
2351: v_debug_status := ' DELETE_ATTACHMENTS';