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.

[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_PRICE_DIFFERENTIALS

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

5683: -- Check the bizrule verdict
5684: IF (g_auc_doctype_rule_data.ALLOW_PRICE_DIFFERENTIAL = 'Y') THEN
5685: -- {
5686:
5687: LOG_MESSAGE('copy_price_diff','inserting rows into PON_PRICE_DIFFERENTIALS');
5688:
5689: INSERT
5690: INTO PON_PRICE_DIFFERENTIALS
5691: ( AUCTION_HEADER_ID,

Line 5690: INTO PON_PRICE_DIFFERENTIALS

5686:
5687: LOG_MESSAGE('copy_price_diff','inserting rows into PON_PRICE_DIFFERENTIALS');
5688:
5689: INSERT
5690: INTO PON_PRICE_DIFFERENTIALS
5691: ( AUCTION_HEADER_ID,
5692: LINE_NUMBER,
5693: SHIPMENT_NUMBER,
5694: PRICE_DIFFERENTIAL_NUMBER,

Line 5715: FROM PON_PRICE_DIFFERENTIALS

5711: p_user_id, -- CREATED_BY
5712: SYSDATE, -- LAST_UPDATE_DATE
5713: p_user_id, -- LAST_UPDATED_BY
5714: p_user_id -- LAST_UPDATE_LOGIN
5715: FROM PON_PRICE_DIFFERENTIALS
5716: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
5717: AND LINE_NUMBER >= p_from_line_number
5718: AND LINE_NUMBER <= p_to_line_number) ;
5719: -- }

Line 12305: delete from pon_price_differentials

12301: and ip.group_type in ('LOT', 'LOT_LINE')
12302: or p_group_enabled = 'N'
12303: and ip.group_type in ('GROUP', 'GROUP_LINE')));
12304:
12305: delete from pon_price_differentials
12306: where auction_header_id = p_auction_header_id
12307: and line_number in
12308: (select ip.line_number
12309: from pon_auction_item_prices_all ip