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_VALIDATE_SHIPMENTS_INT dependencies on PON_AUC_PRICE_BREAKS_INTERFACE

Line 74: UPDATE pon_auc_price_breaks_interface pb_int

70: SELECT price_tiers_indicator INTO l_price_tiers_indicator
71: FROM pon_auction_headers_all WHERE auction_header_id = p_auction_header_id;
72:
73: IF(l_is_fed = 'Y') THEN
74: UPDATE pon_auc_price_breaks_interface pb_int
75: SET auction_line_number =
76: (SELECT line_number
77: FROM pon_auction_item_prices_all
78: WHERE LINE_NUM_DISPLAY = pb_int.DOCUMENT_DISP_LINE_NUMBER

Line 84: UPDATE pon_auc_price_breaks_interface pb_int

80: )
81: WHERE batch_id = p_batch_id;
82:
83: ELSE
84: UPDATE pon_auc_price_breaks_interface pb_int
85: SET auction_line_number =
86: (SELECT line_number
87: FROM pon_auction_item_prices_all
88: WHERE DOCUMENT_DISP_LINE_NUMBER = pb_int.DOCUMENT_DISP_LINE_NUMBER

Line 125: FROM pon_auc_price_breaks_interface

121:
122: CURSOR c_interface_lines
123: IS
124: SELECT DISTINCT auction_line_number
125: FROM pon_auc_price_breaks_interface
126: WHERE BATCH_ID = p_batch_Id
127: AND AUCTION_HEADER_ID = p_auction_header_id;
128:
129: CURSOR c_interface_ship_count(l_line_number number)

Line 132: FROM pon_auc_price_breaks_interface

128:
129: CURSOR c_interface_ship_count(l_line_number number)
130: IS
131: SELECT interface_line_id
132: FROM pon_auc_price_breaks_interface
133: WHERE BATCH_ID =p_batch_Id
134: AND AUCTION_HEADER_ID = p_auction_header_id
135: AND auction_line_number = l_line_number
136: AND Nvl(shipment_number,-1) NOT IN(SELECT shipment_number FROM pon_auction_shipments_all

Line 167: UPDATE pon_auc_price_breaks_interface SET shipment_number = l_shipment_number

163: EXIT
164: WHEN c_interface_ship_count%NOTFOUND;
165: BEGIN
166: l_shipment_number:=l_shipment_number+1;
167: UPDATE pon_auc_price_breaks_interface SET shipment_number = l_shipment_number
168: WHERE batch_id= p_batch_id
169: AND auction_header_id = p_auction_header_id
170: AND interface_line_id = c_interface_ship_count_rec.interface_line_id;
171:

Line 236: FROM pon_auc_price_breaks_interface pasi,

232: pasi.effective_start_date,
233: pasi.effective_end_date,
234: paip.price_break_type,
235: pah.price_tiers_indicator
236: FROM pon_auc_price_breaks_interface pasi,
237: pon_auction_item_prices_all paip,
238: pon_auction_headers_all pah
239: WHERE pasi.batch_id = p_batch_id
240: AND pasi.auction_header_id = p_auction_header_id

Line 315: AND line_number IN(SELECT line_number FROM pon_auc_price_breaks_interface

311: -- Update lines table
312: UPDATE pon_auction_item_prices_all
313: SET has_shipments_flag= 'Y'
314: WHERE auction_header_id= p_auction_header_id
315: AND line_number IN(SELECT line_number FROM pon_auc_price_breaks_interface
316: WHERE batch_id = p_batch_id
317: AND auction_header_id = p_auction_header_id);
318:
319:

Line 321: delete from pon_auc_price_breaks_interface where batch_id = p_batch_id;

317: AND auction_header_id = p_auction_header_id);
318:
319:
320: -- Clear the interface tables
321: delete from pon_auc_price_breaks_interface where batch_id = p_batch_id;
322:
323:
324: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
325: l_progress := 'delete from pon_auc_shipments_interface completed for p_batch_id = '||p_batch_id;

Line 375: UPDATE pon_auc_price_breaks_interface pb_int

371:
372: SELECT price_tiers_indicator INTO l_price_tiers_indicator
373: FROM pon_auction_headers_all WHERE auction_header_id = p_auction_header_id;
374:
375: UPDATE pon_auc_price_breaks_interface pb_int
376: SET SHIP_TO_ORGANIZATION_ID =
377: (SELECT ORGANIZATION_ID
378: FROM org_organization_definitions
379: WHERE organization_code = pb_int.SHIP_TO_ORGANIZATION

Line 384: UPDATE pon_auc_price_breaks_interface pb_int

380: )
381: WHERE batch_id = p_batch_id
382: AND SHIP_TO_ORGANIZATION IS NOT NULL;
383: /* bug#16839410 user will not be able to enter tab in the ship_to_location value so replacing the tab using fnd_global.local_chr */
384: UPDATE pon_auc_price_breaks_interface pb_int
385: SET ship_to_location_id =
386: (SELECT MAX(location_id)
387: FROM po_ship_to_loc_org_v po_v
388: WHERE replace(po_v.location_code,fnd_global.local_chr(9),'') = pb_int.ship_to_location

Line 1279: pon_auc_price_breaks_interface papbi,

1275: papbi.ship_to_organization sel_ship_to_organization,
1276: papbi.ship_to_location sel_ship_to_location,
1277: paha.close_bidding_date sel_close_bidding_date
1278: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,
1279: pon_auc_price_breaks_interface papbi,
1280: pon_auction_headers_all paha
1281: WHERE PAIP.AUCTION_HEADER_ID(+) = p_auction_header_id
1282: AND papbi.AUCTION_HEADER_ID = p_auction_header_id
1283: AND paha.AUCTION_HEADER_ID = p_auction_header_id

Line 1628: pon_auc_price_breaks_interface papbi,

1624: paip.PURCHASE_BASIS sel_PURCHASE_BASIS,
1625: paip.clm_info_flag sel_clm_info_flag,
1626: paha.close_bidding_date sel_close_bidding_date
1627: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,
1628: pon_auc_price_breaks_interface papbi,
1629: pon_auction_headers_all paha
1630: WHERE PAIP.AUCTION_HEADER_ID(+) = p_auction_header_id
1631: AND papbi.AUCTION_HEADER_ID = p_auction_header_id
1632: AND paha.AUCTION_HEADER_ID = p_auction_header_id

Line 1666: FROM pon_auc_price_breaks_interface paip

1662: sysdate, -- CREATION_DATE
1663: l_user_id, -- LAST_UPDATED_BY
1664: LAST_UPDATE_DATE,
1665: l_login_id -- LAST_UPDATE_LOGIN
1666: FROM pon_auc_price_breaks_interface paip
1667: WHERE paip.auction_header_id = p_auction_header_id
1668: AND paip.batch_id = p_batch_id
1669: AND paip.auction_line_number IN
1670: ( (

Line 1673: FROM pon_auc_price_breaks_interface pasa1,

1669: AND paip.auction_line_number IN
1670: ( (
1671:
1672: SELECT pasa1.auction_line_number
1673: FROM pon_auc_price_breaks_interface pasa1,
1674: pon_auc_price_breaks_interface pasa
1675: WHERE pasa1.auction_header_id = p_auction_header_id
1676: and pasa.auction_header_id = p_auction_header_id
1677: AND pasa.auction_line_number = pasa1.auction_line_number

Line 1674: pon_auc_price_breaks_interface pasa

1670: ( (
1671:
1672: SELECT pasa1.auction_line_number
1673: FROM pon_auc_price_breaks_interface pasa1,
1674: pon_auc_price_breaks_interface pasa
1675: WHERE pasa1.auction_header_id = p_auction_header_id
1676: and pasa.auction_header_id = p_auction_header_id
1677: AND pasa.auction_line_number = pasa1.auction_line_number
1678: AND pasa1.batch_id = p_batch_id

Line 1687: FROM pon_auc_price_breaks_interface pasa1,

1683:
1684: UNION
1685:
1686: (SELECT pasa1.auction_line_number
1687: FROM pon_auc_price_breaks_interface pasa1,
1688: pon_auction_shipments_all pasa
1689: WHERE pasa1.auction_header_id = p_auction_header_id
1690: and pasa.auction_header_id = p_auction_header_id
1691: AND pasa1.batch_id = p_batch_id