APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_AUCTION_SHIPMENTS

Line 4894: PON_AUCTION_SHIPMENTS_ALL

4890: --
4891: -- Inseting records
4892: --
4893: INSERT INTO
4894: PON_AUCTION_SHIPMENTS_ALL
4895: ( AUCTION_HEADER_ID,
4896: LINE_NUMBER,
4897: SHIPMENT_NUMBER,
4898: SHIPMENT_TYPE,

Line 4941: FROM PON_AUCTION_SHIPMENTS_ALL

4937: 'N'), -- HAS_PRICE_DIFFERENTIALS_FLAG
4938: decode ( g_auc_doctype_rule_data.ALLOW_PRICE_DIFFERENTIAL,
4939: 'Y', DIFFERENTIAL_RESPONSE_TYPE ,
4940: NULL) -- DIFFERENTIAL_RESPONSE_TYPE
4941: FROM PON_AUCTION_SHIPMENTS_ALL
4942: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
4943: AND SHIPMENT_TYPE = 'PRICE BREAK'
4944: AND line_number >= p_from_line_number
4945: AND line_number <= p_to_line_number) ;

Line 4957: PON_AUCTION_SHIPMENTS_ALL

4953: --
4954: -- Inseting records
4955: --
4956: INSERT INTO
4957: PON_AUCTION_SHIPMENTS_ALL
4958: ( AUCTION_HEADER_ID,
4959: LINE_NUMBER,
4960: SHIPMENT_NUMBER,
4961: SHIPMENT_TYPE,

Line 4992: FROM PON_AUCTION_SHIPMENTS_ALL

4988: p_user_id, -- LAST_UPDATED_BY
4989: p_user_id, -- LAST_UPDATE_LOGIN
4990: MAX_QUANTITY, -- Max Quantity for qty based price tiers
4991: 'N' -- HAS_PRICE_DIFFERENTIALS_FLAG
4992: FROM PON_AUCTION_SHIPMENTS_ALL
4993: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
4994: AND SHIPMENT_TYPE = 'QUANTITY BASED'
4995: AND line_number >= p_from_line_number
4996: AND line_number <= p_to_line_number);

Line 10851: delete from pon_auction_shipments

10847: or p_group_enabled = 'N'
10848: and ip.group_type in ('GROUP', 'GROUP_LINE')));
10849:
10850:
10851: delete from pon_auction_shipments
10852: where auction_header_id = p_auction_header_id
10853: and line_number in
10854: (select ip.line_number
10855: from pon_auction_item_prices_all ip