APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_PRICE_DIFFERENTIALS

Line 4640: LOG_MESSAGE('copy_price_diff','inserting rows into PON_PRICE_DIFFERENTIALS');

4636: -- Check the bizrule verdict
4637: IF (g_auc_doctype_rule_data.ALLOW_PRICE_DIFFERENTIAL = 'Y') THEN
4638: -- {
4639:
4640: LOG_MESSAGE('copy_price_diff','inserting rows into PON_PRICE_DIFFERENTIALS');
4641:
4642: INSERT
4643: INTO PON_PRICE_DIFFERENTIALS
4644: ( AUCTION_HEADER_ID,

Line 4643: INTO PON_PRICE_DIFFERENTIALS

4639:
4640: LOG_MESSAGE('copy_price_diff','inserting rows into PON_PRICE_DIFFERENTIALS');
4641:
4642: INSERT
4643: INTO PON_PRICE_DIFFERENTIALS
4644: ( AUCTION_HEADER_ID,
4645: LINE_NUMBER,
4646: SHIPMENT_NUMBER,
4647: PRICE_DIFFERENTIAL_NUMBER,

Line 4668: FROM PON_PRICE_DIFFERENTIALS

4664: p_user_id, -- CREATED_BY
4665: SYSDATE, -- LAST_UPDATE_DATE
4666: p_user_id, -- LAST_UPDATED_BY
4667: p_user_id -- LAST_UPDATE_LOGIN
4668: FROM PON_PRICE_DIFFERENTIALS
4669: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
4670: AND LINE_NUMBER >= p_from_line_number
4671: AND LINE_NUMBER <= p_to_line_number) ;
4672: -- }

Line 10864: delete from pon_price_differentials

10860: and ip.group_type in ('LOT', 'LOT_LINE')
10861: or p_group_enabled = 'N'
10862: and ip.group_type in ('GROUP', 'GROUP_LINE')));
10863:
10864: delete from pon_price_differentials
10865: where auction_header_id = p_auction_header_id
10866: and line_number in
10867: (select ip.line_number
10868: from pon_auction_item_prices_all ip