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_BREAKS_INTERFACE

Line 2648: FROM pon_auc_price_breaks_interface ppbi

2644: l_line_number numbers;
2645: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2646: /*CURSOR price_break_with_pd_cur IS
2647: SELECT auction_header_id, auction_line_number, shipment_number
2648: FROM pon_auc_price_breaks_interface ppbi
2649: WHERE ppbi.batch_id = p_batch_id
2650: AND Nvl(HAS_PRICE_DIFFERENTIALS_FLAG,'N') = 'Y'
2651: */
2652: BEGIN

Line 2735: FROM pon_auc_price_breaks_interface ppbi,

2731: fnd_global.login_id ,
2732: Nvl(ppbi.HAS_PRICE_DIFFERENTIALS_FLAG,'N'),
2733: ppbi.DIFFERENTIAL_RESPONSE_TYPE ,
2734: ppbi.MAX_QUANTITY
2735: FROM pon_auc_price_breaks_interface ppbi,
2736: pon_item_prices_interface pipi
2737: WHERE ppbi.batch_id = p_batch_id
2738: AND ppbi.batch_id = pipi.batch_id
2739: AND ppbi.auction_line_number = pipi.auction_line_number

Line 2770: pon_auc_price_breaks_interface ppb_int

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
2774: AND pdf_int.auction_line_number = ppb_int.auction_line_number

Line 2805: UPDATE pon_auc_price_breaks_interface pb_int

2801: -- PRAGMA AUTONOMOUS_TRANSACTION;
2802: --l_temp NUMBER;
2803: BEGIN
2804:
2805: UPDATE pon_auc_price_breaks_interface pb_int
2806: SET org_id =
2807: (SELECT ORG_ID
2808: FROM pon_auction_headers_all
2809: WHERE auction_header_id = pb_int.auction_header_id

Line 2813: UPDATE pon_auc_price_breaks_interface pb_int

2809: WHERE auction_header_id = pb_int.auction_header_id
2810: )
2811: WHERE batch_id = p_batch_id;
2812:
2813: UPDATE pon_auc_price_breaks_interface pb_int
2814: SET SHIP_TO_ORGANIZATION_ID =
2815: (SELECT ORGANIZATION_ID
2816: FROM hr_all_organization_units
2817: WHERE name = pb_int.SHIP_TO_ORGANIZATION

Line 2822: UPDATE pon_auc_price_breaks_interface pb_int

2818: )
2819: WHERE batch_id = p_batch_id
2820: AND SHIP_TO_ORGANIZATION IS NOT NULL;
2821:
2822: UPDATE pon_auc_price_breaks_interface pb_int
2823: SET ship_to_location_id =
2824: (SELECT MAX(location_id)
2825: FROM po_ship_to_loc_org_v po_v
2826: WHERE po_v.location_code = pb_int.ship_to_location

Line 3361: pon_auc_price_breaks_interface papbi

3357: papbi.SHIP_TO_LOCATION_ID sel_ship_to_location_id ,
3358: papbi.SHIP_TO_ORGANIZATION_ID sel_ship_to_organization_id ,
3359: papbi.DIFFERENTIAL_RESPONSE_TYPE sel_differential_response_type
3360: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,
3361: pon_auc_price_breaks_interface papbi
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:

Line 3513: AND NOT EXISTS(SELECT 1 FROM pon_auc_price_breaks_interface pas

3509: sysdate , -- LAST_UPDATE_DATE
3510: p_login_id -- LAST_UPDATE_LOGIN
3511: )
3512: WHEN (sel_ship_num IS NOT NULL AND sel_ship_num <> -1
3513: AND NOT EXISTS(SELECT 1 FROM pon_auc_price_breaks_interface pas
3514: WHERE pas.auction_header_id = p_auction_header_id
3515: AND pas.auction_line_number = sel_line_num
3516: AND pas.shipment_number = sel_ship_num ))
3517: THEN INTO PON_INTERFACE_ERRORS

Line 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;

3904: EXCEPTION
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

Line 4909: update pon_auc_price_breaks_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;

4905: update pon_attribute_scores_interface 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:

Line 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;

7128: update pon_attribute_scores_interface SET batch_id = p_batch_id, 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,

Line 7212: update pon_auc_price_breaks_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;

7208: update pon_attribute_scores_interface 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');