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_AUCTION_ITEM_PRICES_ALL

Line 2409: FROM pon_auction_item_prices_all

2405: RETURN;
2406: END IF;
2407:
2408: SELECT Max(document_disp_line_number) INTO l_last_line_num
2409: FROM pon_auction_item_prices_all
2410: WHERE auction_header_id = p_auction_header_id
2411: AND parent_line_number IS NULL;
2412:
2413: UPDATE pon_auction_headers_all pah

Line 2417: FROM pon_auction_item_prices_all paip

2413: UPDATE pon_auction_headers_all pah
2414: SET (MAX_INTERNAL_LINE_NUM,
2415: NUMBER_OF_LINES,
2416: last_line_number) = (SELECT Max(line_number), Count(line_number),l_last_line_num
2417: FROM pon_auction_item_prices_all paip
2418: WHERE paip.auction_header_id = p_auction_header_id)
2419: WHERE auction_header_id = p_auction_header_id;
2420:
2421:

Line 3360: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,

3356: papbi.EFFECTIVE_START_DATE sel_effective_start_date ,
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;

Line 3477: or NOT EXISTS(SELECT 1 FROM pon_auction_item_prices_all paip

3473: sysdate , -- LAST_UPDATE_DATE
3474: p_login_id -- LAST_UPDATE_LOGIN
3475: )
3476: WHEN (sel_line_num IS NULL
3477: or NOT EXISTS(SELECT 1 FROM pon_auction_item_prices_all paip
3478: WHERE paip.auction_header_id = p_auction_header_id
3479: AND paip.line_number = sel_line_num ))
3480: THEN INTO PON_INTERFACE_ERRORS
3481: (

Line 3834: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;

3830: x_return_status := FND_API.G_RET_STS_ERROR;
3831: --ROLLBACK TO NEG_CREATION;
3832: IF ( l_auction_header_id IS NOT NULL ) THEN
3833: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
3834: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;
3835: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
3836: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
3837: DELETE FROM pon_auc_payments_shipments WHERE auction_header_id = l_auction_header_id;
3838: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;

Line 3993: FROM pon_auction_item_prices_all

3989:
3990: -- UDA data insertion for lines
3991: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN
3992: SELECT uda_template_id INTO l_uda_template_id
3993: FROM pon_auction_item_prices_all
3994: WHERE auction_header_id = x_auction_header_id
3995: AND ROWNUM=1;
3996:
3997: /* This loop it to check the usage given in po_uda_interface

Line 4002: FOR complex_pricing_rec IN (SELECT clm_idc_type, clm_contract_type, line_number FROM pon_auction_item_prices_all

3998: table for complex pricing details matches with the
3999: attribute group id defined for the idc_type and contract_type
4000: given in the lines table
4001: */
4002: FOR complex_pricing_rec IN (SELECT clm_idc_type, clm_contract_type, line_number FROM pon_auction_item_prices_all
4003: WHERE auction_Header_id = x_auction_header_id
4004: AND clm_cost_constraint NOT IN ('NS','NSP')
4005: AND purchase_basis <> 'GOODS') LOOP
4006: BEGIN

Line 4012: AND usages.attribute1 = (SELECT clm_idc_type FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id AND line_number=complex_pricing_rec.line_number)

4008: usages.attribute_group_id INTO l_attr_group_id
4009: FROM po_uda_ag_template_usages usages
4010: WHERE usages.attribute_category = 'PRICING'
4011: AND usages.template_id = l_uda_template_id
4012: AND usages.attribute1 = (SELECT clm_idc_type FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id AND line_number=complex_pricing_rec.line_number)
4013: AND usages.attribute2 = (SELECT clm_contract_type FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id AND line_number=complex_pricing_rec.line_number);
4014: EXCEPTION
4015: WHEN No_Data_Found THEN
4016: CONTINUE;

Line 4013: AND usages.attribute2 = (SELECT clm_contract_type FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id AND line_number=complex_pricing_rec.line_number);

4009: FROM po_uda_ag_template_usages usages
4010: WHERE usages.attribute_category = 'PRICING'
4011: AND usages.template_id = l_uda_template_id
4012: AND usages.attribute1 = (SELECT clm_idc_type FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id AND line_number=complex_pricing_rec.line_number)
4013: AND usages.attribute2 = (SELECT clm_contract_type FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id AND line_number=complex_pricing_rec.line_number);
4014: EXCEPTION
4015: WHEN No_Data_Found THEN
4016: CONTINUE;
4017: END;

Line 4062: FOR rec IN (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id ) LOOP

4058: END IF;
4059:
4060:
4061:
4062: FOR rec IN (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id ) LOOP
4063: process_uda_attributes(p_batch_id, x_auction_header_id, rec.line_number, l_uda_template_id, 'PON_AUC_PRICES_EXT_ATTRS', x_return_status);
4064: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4065: print_log('failure in Line UDA insertion for line ' || rec.line_number);
4066: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINEUDA_FAIL');

Line 7051: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;

7047: x_return_status := FND_API.G_RET_STS_ERROR;
7048: --ROLLBACK TO NEG_CREATION;
7049: IF ( l_auction_header_id IS NOT NULL ) THEN
7050: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
7051: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;
7052: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
7053: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
7054: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;
7055: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;

Line 7325: FROM pon_auction_item_prices_all

7321: END IF;
7322:
7323: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(l_doctype_id) = 1 ) THEN
7324: SELECT uda_template_id INTO l_uda_template_id
7325: FROM pon_auction_item_prices_all
7326: WHERE auction_header_id = x_auction_header_id
7327: AND ROWNUM=1;
7328:
7329: FOR rec IN (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id ) LOOP

Line 7329: FOR rec IN (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id ) LOOP

7325: FROM pon_auction_item_prices_all
7326: WHERE auction_header_id = x_auction_header_id
7327: AND ROWNUM=1;
7328:
7329: FOR rec IN (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id ) LOOP
7330: process_uda_attributes(p_batch_id, x_auction_header_id, rec.line_number, l_uda_template_id, 'PON_AUC_PRICES_EXT_ATTRS', x_return_status);
7331: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7332: print_log('failure in Line UDA insertion for line ' || rec.line_number);
7333: insert_error ('PON_INT_LINEUDA_FAIL',p_batch_id,'LINE_UDA',