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_ITEM_PRICES_INTERFACE

Line 2221: pon_item_prices_interface p1

2217: SELECT paa_int.attribute_name att_name,
2218: paa_int.auction_line_number line_num ,
2219: paa_int.sequence_number
2220: FROM pon_auc_attributes_interface paa_int,
2221: pon_item_prices_interface p1
2222: WHERE paa_int.batch_id = p_batch_id
2223: AND p1.batch_id = paa_int.batch_id
2224: AND p1.action = g_update_action
2225: AND paa_int.auction_line_number = p1.auction_line_number

Line 2239: FROM pon_item_prices_interface

2235: paa_int.sequence_number FOR UPDATE OF sequence_number ;
2236:
2237: CURSOR line_cur IS
2238: SELECT interface_line_id,group_type
2239: FROM pon_item_prices_interface
2240: WHERE batch_id = p_batch_id
2241: FOR UPDATE OF disp_line_number,document_disp_line_number,
2242: sub_line_sequence_number,parent_line_number
2243: ORDER BY interface_line_id;

Line 2351: UPDATE pon_item_prices_interface

2347: FOR rec IN line_cur LOOP
2348:
2349: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN
2350:
2351: UPDATE pon_item_prices_interface
2352: SET disp_line_number = rec.interface_line_id,
2353: sub_line_sequence_number = rec.interface_line_id,
2354: document_disp_line_number = rec.interface_line_id
2355: WHERE CURRENT OF line_cur;

Line 2368: UPDATE pon_item_prices_interface t1

2364: is_child := 'Y';
2365: child_seq := child_seq + 1;
2366: END IF;
2367:
2368: UPDATE pon_item_prices_interface t1
2369: SET disp_line_number = rec.interface_line_id,
2370: sub_line_sequence_number = Decode (is_child,'N',parent_seq,child_seq),
2371: document_disp_line_number = Decode (is_child,'N',parent_seq,parent_seq || '.' || child_seq),
2372: parent_line_number=Decode(is_child,'Y',parent_line)

Line 2669: pon_item_prices_interface line_interface

2665: line_number bulk collect
2666: INTO l_shipment_number,
2667: l_line_number
2668: FROM pon_auction_shipments_all auction_shipments,
2669: pon_item_prices_interface line_interface
2670: WHERE line_interface.action = g_update_action
2671: AND line_interface.batch_id = p_batch_id
2672: AND line_interface.auction_header_id = p_auction_header_id
2673: AND auction_shipments.auction_header_id = line_interface.auction_header_id

Line 2736: pon_item_prices_interface pipi

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
2740: AND Nvl(pipi.action,g_add_action) IN (g_add_action,g_update_action);

Line 3896: update pon_item_prices_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;

3892: --x_return_status := FND_API.G_RET_STS_SUCCESS;
3893: neg_header_record_data := l_empty_header_rec;
3894:
3895: update pon_auction_headers_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
3896: update pon_item_prices_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3897: update PON_AUC_ATTRIBUTES_INTERFACE SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3898: update pon_attribute_scores_interface SET batch_id = p_batch_id, LINE_NUMBER = interface_line_id WHERE interface_header_id = p_batch_id;
3899: update pon_bid_parties_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
3900: update PON_NEG_TEAM_INTERFACE SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;

Line 3962: SELECT auction_header_id INTO dummy2 FROM pon_item_prices_interface

3958: print_log('Header UDA information inserted' );
3959: END IF;
3960:
3961: BEGIN
3962: SELECT auction_header_id INTO dummy2 FROM pon_item_prices_interface
3963: WHERE batch_id = p_batch_id
3964: AND ROWNUM=1;
3965: EXCEPTION
3966: WHEN No_Data_Found THEN

Line 4903: update pon_item_prices_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;

4899: ,neg_header_record_data.CD_GENERATED_FLAG
4900: ,neg_header_record_data.AMENDUPDATED_AFTERCDGENERATED
4901: );
4902:
4903: update pon_item_prices_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4904: update PON_AUC_ATTRIBUTES_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;

Line 7126: update pon_item_prices_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;

7122: print_log('In Create Ammendment procedure');
7123: x_return_status := 'S';
7124:
7125: update pon_auction_headers_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
7126: update pon_item_prices_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7127: update PON_AUC_ATTRIBUTES_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;

Line 7206: update pon_item_prices_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;

7202: print_log('Ammendment Copied ' || x_return_status);
7203:
7204: IF ( x_return_status = 'S' ) THEN
7205: print_log(' Updating interface tables with auction_header_id ' || x_auction_header_id);
7206: update pon_item_prices_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7207: update PON_AUC_ATTRIBUTES_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;

Line 7614: AND NOT EXISTS (SELECT interface_line_id FROM pon_item_prices_interface t2

7610: BEGIN
7611:
7612: INSERT ALL
7613: WHEN (sel_line_id > 1
7614: AND NOT EXISTS (SELECT interface_line_id FROM pon_item_prices_interface t2
7615: WHERE t2.batch_id = p_batch_id
7616: AND t2.interface_line_id = (sel_line_id - 1)) )
7617: THEN INTO PON_INTERFACE_ERRORS
7618: (

Line 7635: 'PON_ITEM_PRICES_INTERFACE',

7631: 'LINES',
7632: 'PON_IMPORT_LINE_NUM_ERR',
7633: p_batch_id,
7634: sel_line_id,
7635: 'PON_ITEM_PRICES_INTERFACE',
7636: fnd_global.user_id,
7637: SYSDATE,
7638: fnd_global.user_id,
7639: SYSDATE,

Line 7661: 'PON_ITEM_PRICES_INTERFACE',

7657: 'LINES',
7658: 'PON_IMPORT_LINE_NUM_ERR',
7659: p_batch_id,
7660: sel_line_id,
7661: 'PON_ITEM_PRICES_INTERFACE',
7662: fnd_global.user_id,
7663: SYSDATE,
7664: fnd_global.user_id,
7665: SYSDATE,

Line 7668: AND EXISTS (SELECT interface_line_id FROM pon_item_prices_interface t2

7664: fnd_global.user_id,
7665: SYSDATE,
7666: fnd_global.login_id)
7667: WHEN (sel_line_id > 1
7668: AND EXISTS (SELECT interface_line_id FROM pon_item_prices_interface t2
7669: WHERE t2.batch_id = p_batch_id
7670: AND t2.interface_line_id = (sel_line_id - 1)
7671: AND
7672: (

Line 7697: 'PON_ITEM_PRICES_INTERFACE',

7693: 'LINES',
7694: 'PON_IMPORT_LINE_ORDER_ERR',
7695: p_batch_id,
7696: sel_line_id,
7697: 'PON_ITEM_PRICES_INTERFACE',
7698: fnd_global.user_id,
7699: SYSDATE,
7700: fnd_global.user_id,
7701: SYSDATE,

Line 7706: FROM pon_item_prices_interface

7702: fnd_global.login_id)
7703: SELECT
7704: interface_line_id sel_line_id,
7705: group_type sel_group_type
7706: FROM pon_item_prices_interface
7707: WHERE batch_id = p_batch_id;
7708:
7709: BEGIN
7710:

Line 7712: WHERE NOT EXISTS (SELECT interface_line_id FROM pon_item_prices_interface

7708:
7709: BEGIN
7710:
7711: SELECT 1 INTO dummy FROM dual
7712: WHERE NOT EXISTS (SELECT interface_line_id FROM pon_item_prices_interface
7713: WHERE batch_id = p_batch_id AND interface_line_id = 1);
7714:
7715: INSERT INTO PON_INTERFACE_ERRORS
7716: (

Line 7731: 'PON_ITEM_PRICES_INTERFACE',

7727: VALUES(
7728: 'LINES',
7729: 'PON_IMPORT_LINE_NUM_ERR',
7730: p_batch_id,
7731: 'PON_ITEM_PRICES_INTERFACE',
7732: fnd_global.user_id,
7733: SYSDATE,
7734: fnd_global.user_id,
7735: SYSDATE,

Line 7765: 'PON_ITEM_PRICES_INTERFACE',

7761: 'LINES',
7762: 'PON_IMPORT_LINE_GRP_ERR',
7763: p_batch_id,
7764: sel_line_id,
7765: 'PON_ITEM_PRICES_INTERFACE',
7766: fnd_global.user_id,
7767: SYSDATE,
7768: fnd_global.user_id,
7769: SYSDATE,

Line 7792: 'PON_ITEM_PRICES_INTERFACE',

7788: 'PON_FIELD_MUST_BE_ENTERED',
7789: 'CLM_INFO_FLAG',
7790: p_batch_id,
7791: sel_line_id,
7792: 'PON_ITEM_PRICES_INTERFACE',
7793: fnd_global.user_id,
7794: SYSDATE,
7795: fnd_global.user_id,
7796: SYSDATE,

Line 7821: 'PON_ITEM_PRICES_INTERFACE',

7817: 'LINES',
7818: 'PON_IMPORT_INFOLINE_ERR',
7819: p_batch_id,
7820: sel_line_id,
7821: 'PON_ITEM_PRICES_INTERFACE',
7822: fnd_global.user_id,
7823: SYSDATE,
7824: fnd_global.user_id,
7825: SYSDATE,

Line 7829: AND (EXISTS (SELECT interface_line_id FROM pon_item_prices_interface t2

7825: SYSDATE,
7826: fnd_global.login_id)
7827:
7828: WHEN (sel_group_Line_id IS NOT NULL
7829: AND (EXISTS (SELECT interface_line_id FROM pon_item_prices_interface t2
7830: WHERE t2.interface_line_id = sel_group_line_id
7831: AND Nvl(t2.clm_info_flag,'N') = 'N'
7832: AND Nvl(sel_info_flag,'N') = 'N' )
7833: OR sel_line_id = 1)) -- first line can't be slin

Line 7852: 'PON_ITEM_PRICES_INTERFACE',

7848: 'LINES',
7849: 'PON_IMPORT_CLINSLIN_ERR',
7850: p_batch_id,
7851: sel_line_id,
7852: 'PON_ITEM_PRICES_INTERFACE',
7853: fnd_global.user_id,
7854: SYSDATE,
7855: fnd_global.user_id,
7856: SYSDATE,

Line 7868: FROM pon_item_prices_interface

7864: price sel_price,
7865: quantity sel_qty,
7866: category_name sel_category,
7867: line_type sel_line_type
7868: FROM pon_item_prices_interface
7869: WHERE batch_id = p_batch_id;
7870:
7871: END IF;
7872: