APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_AUCTION_SHIPMENTS

Line 6025: PON_AUCTION_SHIPMENTS_ALL

6021: --
6022: -- Inseting records
6023: --
6024: INSERT INTO
6025: PON_AUCTION_SHIPMENTS_ALL
6026: ( AUCTION_HEADER_ID,
6027: LINE_NUMBER,
6028: SHIPMENT_NUMBER,
6029: SHIPMENT_TYPE,

Line 6072: FROM PON_AUCTION_SHIPMENTS_ALL

6068: 'N'), -- HAS_PRICE_DIFFERENTIALS_FLAG
6069: decode ( g_auc_doctype_rule_data.ALLOW_PRICE_DIFFERENTIAL,
6070: 'Y', DIFFERENTIAL_RESPONSE_TYPE ,
6071: NULL) -- DIFFERENTIAL_RESPONSE_TYPE
6072: FROM PON_AUCTION_SHIPMENTS_ALL
6073: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
6074: AND SHIPMENT_TYPE = 'PRICE BREAK'
6075: AND line_number >= p_from_line_number
6076: AND line_number <= p_to_line_number) ;

Line 6088: PON_AUCTION_SHIPMENTS_ALL

6084: --
6085: -- Inseting records
6086: --
6087: INSERT INTO
6088: PON_AUCTION_SHIPMENTS_ALL
6089: ( AUCTION_HEADER_ID,
6090: LINE_NUMBER,
6091: SHIPMENT_NUMBER,
6092: SHIPMENT_TYPE,

Line 6123: FROM PON_AUCTION_SHIPMENTS_ALL

6119: p_user_id, -- LAST_UPDATED_BY
6120: p_user_id, -- LAST_UPDATE_LOGIN
6121: MAX_QUANTITY, -- Max Quantity for qty based price tiers
6122: 'N' -- HAS_PRICE_DIFFERENTIALS_FLAG
6123: FROM PON_AUCTION_SHIPMENTS_ALL
6124: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
6125: AND SHIPMENT_TYPE = 'QUANTITY BASED'
6126: AND line_number >= p_from_line_number
6127: AND line_number <= p_to_line_number);

Line 12292: delete from pon_auction_shipments

12288: or p_group_enabled = 'N'
12289: and ip.group_type in ('GROUP', 'GROUP_LINE')));
12290:
12291:
12292: delete from pon_auction_shipments
12293: where auction_header_id = p_auction_header_id
12294: and line_number in
12295: (select ip.line_number
12296: from pon_auction_item_prices_all ip