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_SOURCING_OPENAPI_GRP dependencies on PON_AUC_ITEMS_INTERFACE

Line 375: FROM pon_auc_items_interface

371: end if;
372:
373: SELECT count(p_interface_id)
374: INTO l_number_of_lines
375: FROM pon_auc_items_interface
376: WHERE interface_auction_header_id = p_interface_id;
377:
378: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
379: fnd_log.string(fnd_log.level_statement,

Line 415: FROM pon_auc_items_interface paii, po_line_types_b polt

411: -- case the bidders currency gets set as a allowable foreigh currency for bidding.
412: IF (g_header_rec.allow_other_bid_currency_flag = 'Y') THEN
413: -- if there are amount based lines, don't allow other currencies.
414: SELECT count(*) INTO v_amount_based_lines
415: FROM pon_auc_items_interface paii, po_line_types_b polt
416: WHERE paii.interface_auction_header_id = p_interface_id
417: AND paii.line_type_id = polt.line_type_id
418: AND polt.order_type_lookup_code = 'AMOUNT';
419:

Line 1238: SELECT nvl(max(interface_line_number),0) INTO l_max_line_number FROM pon_auc_items_interface

1234: ----------------------------------------------------------------------------------------------------
1235:
1236: --get the number of rows to be copied
1237:
1238: SELECT nvl(max(interface_line_number),0) INTO l_max_line_number FROM pon_auc_items_interface
1239: WHERE interface_auction_header_id = p_interface_id;
1240:
1241: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1242: fnd_log.string(fnd_log.level_statement,

Line 1291: 'Handling Item level data; updating the pon_auc_items_interface table with the correct order_type_lookup_code values');

1287:
1288: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1289: fnd_log.string(fnd_log.level_statement,
1290: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1291: 'Handling Item level data; updating the pon_auc_items_interface table with the correct order_type_lookup_code values');
1292: end if;
1293:
1294:
1295: -- First update the pon_auc_items_interface table with the correct order_type_lookup_code values.

Line 1295: -- First update the pon_auc_items_interface table with the correct order_type_lookup_code values.

1291: 'Handling Item level data; updating the pon_auc_items_interface table with the correct order_type_lookup_code values');
1292: end if;
1293:
1294:
1295: -- First update the pon_auc_items_interface table with the correct order_type_lookup_code values.
1296:
1297: UPDATE pon_auc_items_interface paii
1298: SET paii.order_type_lookup_code =
1299: (SELECT polt.order_type_lookup_code

Line 1297: UPDATE pon_auc_items_interface paii

1293:
1294:
1295: -- First update the pon_auc_items_interface table with the correct order_type_lookup_code values.
1296:
1297: UPDATE pon_auc_items_interface paii
1298: SET paii.order_type_lookup_code =
1299: (SELECT polt.order_type_lookup_code
1300: FROM po_line_types_b polt
1301: WHERE paii.line_type_id = polt.line_type_id)

Line 1383: pon_auc_items_interface.category_id, -- category_id

1379: interface_line_number, -- disp_line_number
1380: 0, -- last_amendment_update
1381: sysdate, -- modified_date
1382: item_description, -- item_description
1383: pon_auc_items_interface.category_id, -- category_id
1384: FND_FLEX_EXT.get_segs('INV', 'MCAT', mtl_categories_kfv.STRUCTURE_ID, mtl_categories_kfv.CATEGORY_ID), -- category_name from mtl_categories_kfv table
1385: pon_auc_items_interface.ip_category_id, -- ip_category_id
1386: Decode (order_type_lookup_code,'AMOUNT',v_uom_code, uom_code), -- uom_code
1387: Decode (order_type_lookup_code,'AMOUNT',1, quantity), -- residual quantity

Line 1385: pon_auc_items_interface.ip_category_id, -- ip_category_id

1381: sysdate, -- modified_date
1382: item_description, -- item_description
1383: pon_auc_items_interface.category_id, -- category_id
1384: FND_FLEX_EXT.get_segs('INV', 'MCAT', mtl_categories_kfv.STRUCTURE_ID, mtl_categories_kfv.CATEGORY_ID), -- category_name from mtl_categories_kfv table
1385: pon_auc_items_interface.ip_category_id, -- ip_category_id
1386: Decode (order_type_lookup_code,'AMOUNT',v_uom_code, uom_code), -- uom_code
1387: Decode (order_type_lookup_code,'AMOUNT',1, quantity), -- residual quantity
1388: 0, -- number_of_bids
1389: Sysdate, -- creation_date

Line 1437: FROM pon_auc_items_interface,

1433: l_line_uda_temp_id,
1434: CLM_CONTRACT_TYPE, -- bug 9914034
1435: CLM_COST_CONSTRAINT,
1436: CLM_IDC_TYPE
1437: FROM pon_auc_items_interface,
1438: mtl_categories_kfv
1439: WHERE interface_auction_header_id = p_interface_id
1440: AND interface_line_number >= l_batch_start
1441: AND interface_line_number <= l_batch_end

Line 1442: AND mtl_categories_kfv.category_id (+) = pon_auc_items_interface.category_id;

1438: mtl_categories_kfv
1439: WHERE interface_auction_header_id = p_interface_id
1440: AND interface_line_number >= l_batch_start
1441: AND interface_line_number <= l_batch_end
1442: AND mtl_categories_kfv.category_id (+) = pon_auc_items_interface.category_id;
1443:
1444:
1445:
1446:

Line 1523: FROM pon_auc_items_interface

1519: -- Insert price breaks information into the transaction table
1520: v_debug_status := 'COPY_LINE_UDA';
1521:
1522: select interface_line_number bulk collect into l_lineno_list
1523: FROM pon_auc_items_interface
1524: WHERE interface_auction_header_id = p_interface_id
1525: AND interface_line_number >= l_batch_start
1526: AND interface_line_number <= l_batch_end;
1527:

Line 1533: select source_line_id into l_poline_id from pon_auc_items_interface where

1529: loop
1530: if ( i = 1 ) Then
1531: select uda_template_id into l_src_template_id from po_lines_all where po_header_id = g_header_rec.source_doc_id and rownum<2;
1532: end if;
1533: select source_line_id into l_poline_id from pon_auc_items_interface where
1534: interface_auction_header_id = p_interface_id and interface_line_number = l_lineno_list(i);
1535:
1536: l_src_pkey := GET_PKEY(l_poline_id,-1);
1537: l_tar_pkey := GET_PKEY(x_document_number,l_lineno_list(i));

Line 1554: SELECT order_type_lookup_code INTO v_order_type_lookup_code from pon_auc_items_interface where

1550: v_msg_data);
1551:
1552: -- bug 9914034 update clm_unit_price and clm_amount columns
1553: IF ( v_return_status <> 'E' ) THEN
1554: SELECT order_type_lookup_code INTO v_order_type_lookup_code from pon_auc_items_interface where
1555: interface_auction_header_id = p_interface_id and interface_line_number = l_lineno_list(i);
1556: IF(v_order_type_lookup_code <> 'QUANTITY') THEN
1557: BEGIN
1558: UPDATE pon_auction_item_prices_all paip

Line 2443: COMMENT : validates the data in the pon_auc_items_interface table

2439: p_interface_id IN interfaceid for the auction that is being validated
2440: x_error_code OUT NOCOPY errcode if any error generate
2441: x_error_message OUT NOCOPY error message if any error
2442:
2443: COMMENT : validates the data in the pon_auc_items_interface table
2444: In this procedure we do column wise validation
2445: ======================================================================*/
2446:
2447: PROCEDURE val_auc_items_interface(p_interface_id NUMBER,

Line 2468: FROM pon_auc_items_interface

2464:
2465: -- validate item org_id is the same as that in the header
2466:
2467: SELECT MIN(interface_line_number) INTO v_invalid_item_recs
2468: FROM pon_auc_items_interface
2469: WHERE interface_auction_header_id = p_interface_id
2470: AND org_id <> g_header_rec.org_id;
2471:
2472: IF (v_invalid_item_recs IS NOT NULL ) THEN

Line 2497: FROM pon_auc_items_interface

2493:
2494: v_debug_status := 'VALIDATE_LINE_ORG_CODE';
2495:
2496: SELECT MIN(interface_line_number) INTO v_invalid_item_recs
2497: FROM pon_auc_items_interface
2498: WHERE interface_auction_header_id = p_interface_id
2499: AND origination_code <> 'BLANKET';
2500:
2501: IF (v_invalid_item_recs IS NOT NULL ) THEN

Line 2526: FROM pon_auc_items_interface

2522:
2523: v_debug_status := 'VALIDATE_PRICE_BREAK_TYPE';
2524:
2525: SELECT MIN(interface_line_number) INTO v_invalid_item_recs
2526: FROM pon_auc_items_interface
2527: WHERE interface_auction_header_id = p_interface_id
2528: AND decode(price_break_type, null, 'NONE', 'NON CUMULATIVE', 'NON-CUMULATIVE', price_break_type) NOT IN ('CUMULATIVE', 'NON-CUMULATIVE','NONE');
2529:
2530: IF (v_invalid_item_recs IS NOT NULL ) THEN

Line 2813: DELETE FROM pon_auc_items_interface

2809:
2810: -- Delete records from item table
2811: v_debug_status := 'DELETE_ITEM';
2812:
2813: DELETE FROM pon_auc_items_interface
2814: WHERE interface_auction_header_id = p_interface_id;
2815:
2816: -- Deletes records from attributes table
2817: v_debug_status := 'DELETE_ATTRIBUTES';

Line 3068: FROM pon_auc_items_interface

3064: v_attr_group_name fnd_lookup_values.meaning%TYPE;
3065:
3066: CURSOR lines IS
3067: SELECT interface_line_number
3068: FROM pon_auc_items_interface
3069: WHERE interface_auction_header_id = p_interface_id
3070: AND interface_line_number >= p_from_line_number
3071: AND interface_line_number <= p_to_line_number;
3072:

Line 3452: FROM pon_auc_items_interface

3448:
3449:
3450: CURSOR interface_lines IS
3451: SELECT interface_line_number, source_line_id
3452: FROM pon_auc_items_interface
3453: WHERE interface_auction_header_id = p_interface_id;
3454:
3455:
3456: BEGIN

Line 3461: UPDATE pon_auc_items_interface

3457: -- logme('in maintain_clm_relations');
3458:
3459: FOR oneline IN interface_lines
3460: LOOP
3461: UPDATE pon_auc_items_interface
3462: SET group_line_id = oneline.interface_line_number
3463: WHERE interface_auction_header_id = p_interface_id
3464: AND group_line_id = oneline.source_line_id;
3465:

Line 3466: UPDATE pon_auc_items_interface

3462: SET group_line_id = oneline.interface_line_number
3463: WHERE interface_auction_header_id = p_interface_id
3464: AND group_line_id = oneline.source_line_id;
3465:
3466: UPDATE pon_auc_items_interface
3467: SET clm_base_line_num = oneline.interface_line_number
3468: WHERE interface_auction_header_id = p_interface_id
3469: AND clm_base_line_num = oneline.source_line_id;
3470: