eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_AUCTION_SHIPMENTS_ALL

Line 2627: the price breaks for those lines will be picked and inserted into pon_auction_shipments_all table.

2623:
2624: /*
2625: This procedure will add price breaks from interface table to txn table.
2626: For all lines marked with '+' action in lines interface table,
2627: the price breaks for those lines will be picked and inserted into pon_auction_shipments_all table.
2628: For amendments, all the existing price breaks will be deleted from pon_auction_shipments_all table
2629: for those lines marked with '#' action in lines interface table.
2630: Then only those price breaks given in interface tables will be added.
2631: Also this procedure inserts data from price differentials interface table

Line 2628: For amendments, all the existing price breaks will be deleted from pon_auction_shipments_all table

2624: /*
2625: This procedure will add price breaks from interface table to txn table.
2626: For all lines marked with '+' action in lines interface table,
2627: the price breaks for those lines will be picked and inserted into pon_auction_shipments_all table.
2628: For amendments, all the existing price breaks will be deleted from pon_auction_shipments_all table
2629: for those lines marked with '#' action in lines interface table.
2630: Then only those price breaks given in interface tables will be added.
2631: Also this procedure inserts data from price differentials interface table
2632: to main txn table for price breaks with price differentials.

Line 2668: FROM pon_auction_shipments_all auction_shipments,

2664: SELECT shipment_number,
2665: line_number bulk collect
2666: INTO l_shipment_number,
2667: l_line_number
2668: FROM pon_auction_shipments_all auction_shipments,
2669: pon_item_prices_interface line_interface
2670: WHERE line_interface.action = g_update_action
2671: AND line_interface.batch_id = p_batch_id
2672: AND line_interface.auction_header_id = p_auction_header_id

Line 2685: FROM pon_auction_shipments_all auction_shipments

2681: AND price_diffs.shipment_number = l_shipment_number(x);
2682:
2683: FORALL x IN 1..l_line_number.COUNT
2684: DELETE
2685: FROM pon_auction_shipments_all auction_shipments
2686: WHERE auction_shipments.auction_header_id = p_auction_header_id
2687: AND auction_shipments.line_number = l_line_number(x)
2688: AND auction_shipments.shipment_number = l_shipment_number(x);
2689: EXCEPTION

Line 2694: INTO pon_auction_shipments_all

2690: WHEN OTHERS THEN
2691: NULL;
2692: END; -- end of amendments specific code
2693: INSERT
2694: INTO pon_auction_shipments_all
2695: (
2696: auction_header_id ,
2697: line_number ,
2698: shipment_number ,

Line 3836: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;

3832: IF ( l_auction_header_id IS NOT NULL ) THEN
3833: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
3834: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;
3835: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
3836: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
3837: DELETE FROM pon_auc_payments_shipments WHERE auction_header_id = l_auction_header_id;
3838: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;
3839: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;
3840: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;

Line 7053: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;

7049: IF ( l_auction_header_id IS NOT NULL ) THEN
7050: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
7051: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;
7052: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
7053: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
7054: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;
7055: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;
7056: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;
7057: DELETE FROM pon_attribute_scores WHERE auction_header_id = l_auction_header_id;