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_AUCTION_HEADERS_ALL

Line 36: l_price_Tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;

32: l_interface_type VARCHAR2(15);
33: l_module CONSTANT VARCHAR2(32) := 'VALIDATE_CREATION';
34: l_progress VARCHAR2(200);
35: p_request_id NUMBER;
36: l_price_Tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
37: l_is_fed VARCHAR2(1);
38: l_doctype_id NUMBER;
39:
40:

Line 54: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auction_header_id;

50: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
51: print_debug_log(l_module,'Before insert all valiations of validate_creation for p_batch_id = '||p_batch_id);
52: END IF;
53:
54: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auction_header_id;
55:
56: BEGIN
57: SELECT
58: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed

Line 71: FROM pon_auction_headers_all WHERE auction_header_id = p_auction_header_id;

67: l_is_fed := 'N';
68: END;
69:
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 =

Line 238: pon_auction_headers_all pah

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
241: AND pasi.auction_header_id = paip.auction_header_id
242: AND pasi.auction_line_number = paip.line_number

Line 356: l_price_Tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;

352: l_interface_type VARCHAR2(15);
353: l_module CONSTANT VARCHAR2(32) := 'VALIDATE_CREATION';
354: l_progress VARCHAR2(200);
355: p_request_id NUMBER;
356: l_price_Tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
357:
358:
359: BEGIN
360:

Line 373: FROM pon_auction_headers_all WHERE auction_header_id = p_auction_header_id;

369: print_debug_log(l_module,'Validating price breaks for p_batch_id = '||p_batch_id);
370: END IF;
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

Line 1280: pon_auction_headers_all paha

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
1284: AND PAIP.LINE_NUMBER(+) = papbi.auction_LINE_NUMBER

Line 1304: l_price_Tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;

1300: l_interface_type VARCHAR2(15);
1301: l_module CONSTANT VARCHAR2(32) := 'VALIDATE_CREATION';
1302: l_progress VARCHAR2(200);
1303: p_request_id NUMBER;
1304: l_price_Tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
1305:
1306:
1307: BEGIN
1308:

Line 1322: FROM pon_auction_headers_all WHERE auction_header_id = p_auction_header_id;

1318: END IF;
1319:
1320:
1321: SELECT price_tiers_indicator INTO l_price_tiers_indicator
1322: FROM pon_auction_headers_all WHERE auction_header_id = p_auction_header_id;
1323:
1324:
1325:
1326: INSERT ALL

Line 1629: pon_auction_headers_all paha

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
1633: AND PAIP.LINE_NUMBER(+) = papbi.auction_LINE_NUMBER