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_AUC_PRICE_DIFFER_INT

Line 2769: FROM pon_auc_price_differ_int pdf_int,

2765: fnd_global.USER_id ,
2766: sysdate ,
2767: fnd_global.USER_id ,
2768: fnd_global.login_id
2769: FROM pon_auc_price_differ_int pdf_int,
2770: pon_auc_price_breaks_interface ppb_int
2771: WHERE pdf_int.batch_id = p_batch_id
2772: AND NVL(ppb_int.HAS_PRICE_DIFFERENTIALS_FLAG,'N') = 'Y'
2773: AND pdf_int.batch_id = ppb_int.batch_id

Line 3139: FROM pon_auc_price_differ_int PPD

3135: -- RESPONSE TYPE if entered should have price differentials
3136: WHEN ( sel_differential_response_type IS NOT NULL
3137: AND NOT EXISTS
3138: (SELECT 1
3139: FROM pon_auc_price_differ_int PPD
3140: WHERE ppd.batch_id = p_batch_id
3141: AND PPD.AUCTION_HEADER_ID = p_auction_header_id
3142: AND PPD.auction_LINE_NUMBER = sel_line_number
3143: AND PPD.auction_SHIPMENT_NUMBER = sel_shipment_number

Line 3366: UPDATE pon_auc_price_differ_int diff

3362: WHERE PAIP.AUCTION_HEADER_ID = p_auction_header_id
3363: AND papbi.AUCTION_HEADER_ID = p_auction_header_id
3364: AND PAIP.LINE_NUMBER = papbi.auction_LINE_NUMBER;
3365:
3366: UPDATE pon_auc_price_differ_int diff
3367: SET price_type = (SELECT price_type FROM po_price_diff_lookups_v WHERE price_type_name = diff.price_type )
3368: WHERE diff.auction_header_id = p_auction_header_id
3369: AND diff.price_type_name IS NOT null;
3370:

Line 3397: 'PON_AUC_PRICE_DIFFER_INT', -- ENTITY_TYPE

3393: 'PON_FIELD_MUST_BE_ENTERED' , -- ERROR_MESSAGE_NAME
3394: 'SEQUENCE_NUMBER',
3395: p_request_id , -- REQUEST_ID
3396: p_batch_id , -- BATCH_ID
3397: 'PON_AUC_PRICE_DIFFER_INT', -- ENTITY_TYPE
3398: p_auction_header_id , -- AUCTION_HEADER_ID
3399: sel_line_num , -- LINE_NUMBER
3400: sel_ship_num , -- SHIPMENT_NUMBER
3401: p_user_id , -- CREATED_BY

Line 3431: 'PON_AUC_PRICE_DIFFER_INT' , -- ENTITY_TYPE

3427: g_interface_type , --INTERFACE_TYPE
3428: 'PON_IMPORT_PRICEDIFF_TYPE' , -- ERROR_MESSAGE_NAME
3429: p_request_id , -- REQUEST_ID
3430: p_batch_id , -- BATCH_ID
3431: 'PON_AUC_PRICE_DIFFER_INT' , -- ENTITY_TYPE
3432: p_auction_header_id , -- AUCTION_HEADER_ID
3433: sel_line_num , -- LINE_NUMBER
3434: sel_ship_num , -- SHIPMENT_NUMBER
3435: p_user_id , -- CREATED_BY

Line 3466: 'PON_AUC_PRICE_DIFFER_INT' , -- ENTITY_TYPE

3462: 'PON_FIELD_MUST_BE_ENTERED' , -- ERROR_MESSAGE_NAME
3463: 'MULTIPLIER',
3464: p_request_id , -- REQUEST_ID
3465: p_batch_id , -- BATCH_ID
3466: 'PON_AUC_PRICE_DIFFER_INT' , -- ENTITY_TYPE
3467: p_auction_header_id , -- AUCTION_HEADER_ID
3468: sel_line_num , -- LINE_NUMBER
3469: sel_ship_num , -- SHIPMENT_NUMBER
3470: p_user_id , -- CREATED_BY

Line 3502: 'PON_AUC_PRICE_DIFFER_INT' , -- ENTITY_TYPE

3498: g_interface_type , --INTERFACE_TYPE
3499: 'PON_IMPORT_PRICEDIFF_LINE' , -- ERROR_MESSAGE_NAME
3500: p_request_id , -- REQUEST_ID
3501: p_batch_id , -- BATCH_ID
3502: 'PON_AUC_PRICE_DIFFER_INT' , -- ENTITY_TYPE
3503: p_auction_header_id , -- AUCTION_HEADER_ID
3504: sel_line_num , -- LINE_NUMBER
3505: sel_ship_num , -- SHIPMENT_NUMBER
3506: p_user_id , -- CREATED_BY

Line 3539: 'PON_AUC_PRICE_DIFFER_INT' , -- ENTITY_TYPE

3535: g_interface_type , --INTERFACE_TYPE
3536: 'PON_IMPORT_PRICEDIFF_SHIP' , -- ERROR_MESSAGE_NAME
3537: p_request_id , -- REQUEST_ID
3538: p_batch_id , -- BATCH_ID
3539: 'PON_AUC_PRICE_DIFFER_INT' , -- ENTITY_TYPE
3540: p_auction_header_id , -- AUCTION_HEADER_ID
3541: sel_line_num , -- LINE_NUMBER
3542: sel_ship_num , -- SHIPMENT_NUMBER
3543: p_user_id , -- CREATED_BY

Line 3554: FROM PON_AUC_PRICE_DIFFER_INT ppd

3550: ppd.sequence_number sel_seq_num,
3551: ppd.auction_line_number sel_line_num,
3552: ppd.multiplier sel_multiplier,
3553: ppd.auction_shipment_number sel_ship_num
3554: FROM PON_AUC_PRICE_DIFFER_INT ppd
3555: WHERE ppd.auction_header_id = p_auction_header_id;
3556:
3557: END VAL_PRICE_BREAKS;
3558:

Line 3909: update pon_auc_price_differ_int SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;

3905: WHEN OTHERS THEN
3906: print_log('sqlerrm ' || SQLERRM || ' ' || SQLCODE );
3907: END;
3908: update pon_auc_price_breaks_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3909: update pon_auc_price_differ_int SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3910:
3911: BEGIN
3912: SELECT 1
3913: INTO dummy1

Line 4910: update pon_auc_price_differ_int SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;

4906: update pon_bid_parties_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4907: update PON_NEG_TEAM_INTERFACE SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4908: update PON_AUC_PRICE_ELEMENTS_INT SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4909: update pon_auc_price_breaks_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4910: update pon_auc_price_differ_int SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4911: --x_auction_header_id := neg_header_record_data.auction_header_id;
4912:
4913:
4914: print_log('Header information created for batch id ' || p_batch_id || ' auction_header_id ' || neg_header_record_data.auction_header_id);

Line 7133: update pon_auc_price_differ_int SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;

7129: update pon_bid_parties_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
7130: update PON_NEG_TEAM_INTERFACE SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
7131: update PON_AUC_PRICE_ELEMENTS_INT SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7132: update pon_auc_price_breaks_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7133: update pon_auc_price_differ_int SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7134:
7135:
7136: SELECT auction_header_id, award_approval_flag,
7137: retain_clause_flag,update_clause_flag, retain_attachments_flag,

Line 7213: update pon_auc_price_differ_int SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;

7209: update pon_bid_parties_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7210: update PON_NEG_TEAM_INTERFACE SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7211: update PON_AUC_PRICE_ELEMENTS_INT SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7212: update pon_auc_price_breaks_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7213: update pon_auc_price_differ_int SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7214: ELSE
7215: print_log('Amendment creation failed for batch ' || p_batch_id);
7216: FND_MESSAGE.SET_NAME('PON','PON_INT_AMEND_FAIL');
7217: FND_MSG_PUB.ADD;