APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_AUC_SHIPMENTS_INTERFACE

Line 1227: FROM pon_auc_shipments_interface

1223:
1224: UPDATE pon_auction_headers_all
1225: SET price_tiers_indicator = 'PRICE_BREAKS'
1226: Where exists (SELECT 'Y'
1227: FROM pon_auc_shipments_interface
1228: WHERE interface_auction_header_id = p_interface_id
1229: AND rownum=1)
1230: AND auction_header_id = x_document_number;
1231:

Line 1459: FROM pon_auc_shipments_interface

1455: UPDATE pon_auction_item_prices_all
1456: SET has_shipments_flag = 'Y'
1457: WHERE (line_number) IN
1458: (SELECT interface_line_number
1459: FROM pon_auc_shipments_interface
1460: WHERE interface_auction_header_id = p_interface_id
1461: AND interface_line_number >= l_batch_start
1462: AND interface_line_number <= l_batch_end)
1463: AND auction_header_id = x_document_number;

Line 1700: FROM pon_auc_shipments_interface

1696: g_header_rec.user_id, -- created_by
1697: Sysdate, -- last_update_date
1698: g_header_rec.user_id, -- last_updated_by
1699: 'N'
1700: FROM pon_auc_shipments_interface
1701: WHERE interface_auction_header_id = p_interface_id
1702: AND interface_line_number >= l_batch_start
1703: AND interface_line_number <= l_batch_end
1704: GROUP BY interface_line_number,ship_to_organization_id, ship_to_location_id, quantity;

Line 1806: FROM pon_auc_shipments_interface

1802: AND interface_line_number >= l_batch_start
1803: AND interface_line_number <= l_batch_end
1804: AND interface_shipment_number <> -1
1805: AND interface_shipment_number IN (SELECT min(interface_ship_number)
1806: FROM pon_auc_shipments_interface
1807: WHERE interface_auction_header_id = p_interface_id
1808: GROUP BY interface_line_number,ship_to_organization_id, ship_to_location_id, quantity);
1809:
1810: -- Copy over the attachments from the PON_ATTACHMENTS_INTERFACE table

Line 2568: COMMENT : validates the data in the pon_auc_shipments_interface table

2564: p_interface_id IN interfaceid for the auction that is being validated
2565: x_error_code OUT NOCOPY errcode if any error generate
2566: x_error_message OUT NOCOPY error message if any error
2567:
2568: COMMENT : validates the data in the pon_auc_shipments_interface table
2569: ======================================================================*/
2570:
2571: PROCEDURE val_auc_shipments_interface(p_interface_id NUMBER,
2572: x_error_code OUT NOCOPY VARCHAR2,

Line 2592: FROM pon_auc_shipments_interface

2588: -- validate item org_id is the same as that in the header
2589:
2590: SELECT MIN (To_char(interface_line_number) || '-' || To_char(interface_ship_number))
2591: INTO v_shipment_rec
2592: FROM pon_auc_shipments_interface
2593: WHERE interface_auction_header_id = p_interface_id
2594: AND org_id <> g_header_rec.org_id;
2595:
2596: IF (v_shipment_rec IS NOT null) THEN

Line 2621: FROM pon_auc_shipments_interface

2617:
2618: v_debug_status := 'VALIDATE_SHIPMENT_TYPE';
2619: SELECT MIN(To_char(interface_line_number) || '-' || To_char(interface_ship_number))
2620: INTO v_shipment_rec
2621: FROM pon_auc_shipments_interface
2622: WHERE interface_auction_header_id = p_interface_id
2623: AND shipment_type <> 'PRICE BREAK';
2624:
2625: IF (v_shipment_rec IS NOT NULL ) THEN

Line 2825: DELETE FROM pon_auc_shipments_interface

2821:
2822: -- Delete records from shipments table
2823: v_debug_status := 'DELETE_SHIPMENTS';
2824:
2825: DELETE FROM pon_auc_shipments_interface
2826: WHERE interface_auction_header_id = p_interface_id;
2827:
2828: -- ADDED FOR SERVICES PROCUREMENT PROJECT
2829: -- Delete records from price differentials table