APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_AUC_SHIPMENTS_INTERFACE

Line 978: FROM pon_auc_shipments_interface

974:
975: UPDATE pon_auction_headers_all
976: SET price_tiers_indicator = 'PRICE_BREAKS'
977: Where exists (SELECT 'Y'
978: FROM pon_auc_shipments_interface
979: WHERE interface_auction_header_id = p_interface_id
980: AND rownum=1)
981: AND auction_header_id = x_document_number;
982:

Line 1179: FROM pon_auc_shipments_interface

1175: UPDATE pon_auction_item_prices_all
1176: SET has_shipments_flag = 'Y'
1177: WHERE (line_number) IN
1178: (SELECT interface_line_number
1179: FROM pon_auc_shipments_interface
1180: WHERE interface_auction_header_id = p_interface_id
1181: AND interface_line_number >= l_batch_start
1182: AND interface_line_number <= l_batch_end)
1183: AND auction_header_id = x_document_number;

Line 1276: FROM pon_auc_shipments_interface

1272: g_header_rec.user_id, -- created_by
1273: Sysdate, -- last_update_date
1274: g_header_rec.user_id, -- last_updated_by
1275: 'N'
1276: FROM pon_auc_shipments_interface
1277: WHERE interface_auction_header_id = p_interface_id
1278: AND interface_line_number >= l_batch_start
1279: AND interface_line_number <= l_batch_end
1280: GROUP BY interface_line_number,ship_to_organization_id, ship_to_location_id, quantity;

Line 1382: FROM pon_auc_shipments_interface

1378: AND interface_line_number >= l_batch_start
1379: AND interface_line_number <= l_batch_end
1380: AND interface_shipment_number <> -1
1381: AND interface_shipment_number IN (SELECT min(interface_ship_number)
1382: FROM pon_auc_shipments_interface
1383: WHERE interface_auction_header_id = p_interface_id
1384: GROUP BY interface_line_number,ship_to_organization_id, ship_to_location_id, quantity);
1385:
1386: -- Copy over the attachments from the PON_ATTACHMENTS_INTERFACE table

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

2079: p_interface_id IN interfaceid for the auction that is being validated
2080: x_error_code OUT NOCOPY errcode if any error generate
2081: x_error_message OUT NOCOPY error message if any error
2082:
2083: COMMENT : validates the data in the pon_auc_shipments_interface table
2084: ======================================================================*/
2085:
2086: PROCEDURE val_auc_shipments_interface(p_interface_id NUMBER,
2087: x_error_code OUT NOCOPY VARCHAR2,

Line 2107: FROM pon_auc_shipments_interface

2103: -- validate item org_id is the same as that in the header
2104:
2105: SELECT MIN (To_char(interface_line_number) || '-' || To_char(interface_ship_number))
2106: INTO v_shipment_rec
2107: FROM pon_auc_shipments_interface
2108: WHERE interface_auction_header_id = p_interface_id
2109: AND org_id <> g_header_rec.org_id;
2110:
2111: IF (v_shipment_rec IS NOT null) THEN

Line 2136: FROM pon_auc_shipments_interface

2132:
2133: v_debug_status := 'VALIDATE_SHIPMENT_TYPE';
2134: SELECT MIN(To_char(interface_line_number) || '-' || To_char(interface_ship_number))
2135: INTO v_shipment_rec
2136: FROM pon_auc_shipments_interface
2137: WHERE interface_auction_header_id = p_interface_id
2138: AND shipment_type <> 'PRICE BREAK';
2139:
2140: IF (v_shipment_rec IS NOT NULL ) THEN

Line 2340: DELETE FROM pon_auc_shipments_interface

2336:
2337: -- Delete records from shipments table
2338: v_debug_status := 'DELETE_SHIPMENTS';
2339:
2340: DELETE FROM pon_auc_shipments_interface
2341: WHERE interface_auction_header_id = p_interface_id;
2342:
2343: -- ADDED FOR SERVICES PROCUREMENT PROJECT
2344: -- Delete records from price differentials table