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 336: FROM pon_auc_items_interface

332: end if;
333:
334: SELECT count(p_interface_id)
335: INTO l_number_of_lines
336: FROM pon_auc_items_interface
337: WHERE interface_auction_header_id = p_interface_id;
338:
339: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
340: fnd_log.string(fnd_log.level_statement,

Line 376: FROM pon_auc_items_interface paii, po_line_types_b polt

372: -- case the bidders currency gets set as a allowable foreigh currency for bidding.
373: IF (g_header_rec.allow_other_bid_currency_flag = 'Y') THEN
374: -- if there are amount based lines, don't allow other currencies.
375: SELECT count(*) INTO v_amount_based_lines
376: FROM pon_auc_items_interface paii, po_line_types_b polt
377: WHERE paii.interface_auction_header_id = p_interface_id
378: AND paii.line_type_id = polt.line_type_id
379: AND polt.order_type_lookup_code = 'AMOUNT';
380:

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

985: ----------------------------------------------------------------------------------------------------
986:
987: --get the number of rows to be copied
988:
989: SELECT nvl(max(interface_line_number),0) INTO l_max_line_number FROM pon_auc_items_interface
990: WHERE interface_auction_header_id = p_interface_id;
991:
992: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
993: fnd_log.string(fnd_log.level_statement,

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

1038:
1039: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1040: fnd_log.string(fnd_log.level_statement,
1041: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1042: 'Handling Item level data; updating the pon_auc_items_interface table with the correct order_type_lookup_code values');
1043: end if;
1044:
1045:
1046: -- First update the pon_auc_items_interface table with the correct order_type_lookup_code values.

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

1042: 'Handling Item level data; updating the pon_auc_items_interface table with the correct order_type_lookup_code values');
1043: end if;
1044:
1045:
1046: -- First update the pon_auc_items_interface table with the correct order_type_lookup_code values.
1047:
1048: UPDATE pon_auc_items_interface paii
1049: SET paii.order_type_lookup_code =
1050: (SELECT polt.order_type_lookup_code

Line 1048: UPDATE pon_auc_items_interface paii

1044:
1045:
1046: -- First update the pon_auc_items_interface table with the correct order_type_lookup_code values.
1047:
1048: UPDATE pon_auc_items_interface paii
1049: SET paii.order_type_lookup_code =
1050: (SELECT polt.order_type_lookup_code
1051: FROM po_line_types_b polt
1052: WHERE paii.line_type_id = polt.line_type_id)

Line 1120: pon_auc_items_interface.category_id, -- category_id

1116: interface_line_number, -- disp_line_number
1117: 0, -- last_amendment_update
1118: sysdate, -- modified_date
1119: item_description, -- item_description
1120: pon_auc_items_interface.category_id, -- category_id
1121: FND_FLEX_EXT.get_segs('INV', 'MCAT', mtl_categories_kfv.STRUCTURE_ID, mtl_categories_kfv.CATEGORY_ID), -- category_name from mtl_categories_kfv table
1122: pon_auc_items_interface.ip_category_id, -- ip_category_id
1123: Decode (order_type_lookup_code,'AMOUNT',v_uom_code, uom_code), -- uom_code
1124: Decode (order_type_lookup_code,'AMOUNT',1, quantity), -- residual quantity

Line 1122: pon_auc_items_interface.ip_category_id, -- ip_category_id

1118: sysdate, -- modified_date
1119: item_description, -- item_description
1120: pon_auc_items_interface.category_id, -- category_id
1121: FND_FLEX_EXT.get_segs('INV', 'MCAT', mtl_categories_kfv.STRUCTURE_ID, mtl_categories_kfv.CATEGORY_ID), -- category_name from mtl_categories_kfv table
1122: pon_auc_items_interface.ip_category_id, -- ip_category_id
1123: Decode (order_type_lookup_code,'AMOUNT',v_uom_code, uom_code), -- uom_code
1124: Decode (order_type_lookup_code,'AMOUNT',1, quantity), -- residual quantity
1125: 0, -- number_of_bids
1126: Sysdate, -- creation_date

Line 1160: FROM pon_auc_items_interface,

1156: -1, -- Always set the price_diff_shipment_number to -1 for blankets
1157: 'LINE', -- Group Type
1158: interface_line_number, -- document_disp_line_number
1159: interface_line_number -- sub_line_sequence_number
1160: FROM pon_auc_items_interface,
1161: mtl_categories_kfv
1162: WHERE interface_auction_header_id = p_interface_id
1163: AND interface_line_number >= l_batch_start
1164: AND interface_line_number <= l_batch_end

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

1161: mtl_categories_kfv
1162: WHERE interface_auction_header_id = p_interface_id
1163: AND interface_line_number >= l_batch_start
1164: AND interface_line_number <= l_batch_end
1165: AND mtl_categories_kfv.category_id (+) = pon_auc_items_interface.category_id;
1166:
1167: -- Update the shipments flag based on if their are shipments
1168:
1169: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

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

1954: p_interface_id IN interfaceid for the auction that is being validated
1955: x_error_code OUT NOCOPY errcode if any error generate
1956: x_error_message OUT NOCOPY error message if any error
1957:
1958: COMMENT : validates the data in the pon_auc_items_interface table
1959: In this procedure we do column wise validation
1960: ======================================================================*/
1961:
1962: PROCEDURE val_auc_items_interface(p_interface_id NUMBER,

Line 1983: FROM pon_auc_items_interface

1979:
1980: -- validate item org_id is the same as that in the header
1981:
1982: SELECT MIN(interface_line_number) INTO v_invalid_item_recs
1983: FROM pon_auc_items_interface
1984: WHERE interface_auction_header_id = p_interface_id
1985: AND org_id <> g_header_rec.org_id;
1986:
1987: IF (v_invalid_item_recs IS NOT NULL ) THEN

Line 2012: FROM pon_auc_items_interface

2008:
2009: v_debug_status := 'VALIDATE_LINE_ORG_CODE';
2010:
2011: SELECT MIN(interface_line_number) INTO v_invalid_item_recs
2012: FROM pon_auc_items_interface
2013: WHERE interface_auction_header_id = p_interface_id
2014: AND origination_code <> 'BLANKET';
2015:
2016: IF (v_invalid_item_recs IS NOT NULL ) THEN

Line 2041: FROM pon_auc_items_interface

2037:
2038: v_debug_status := 'VALIDATE_PRICE_BREAK_TYPE';
2039:
2040: SELECT MIN(interface_line_number) INTO v_invalid_item_recs
2041: FROM pon_auc_items_interface
2042: WHERE interface_auction_header_id = p_interface_id
2043: AND decode(price_break_type, null, 'NONE', 'NON CUMULATIVE', 'NON-CUMULATIVE', price_break_type) NOT IN ('CUMULATIVE', 'NON-CUMULATIVE','NONE');
2044:
2045: IF (v_invalid_item_recs IS NOT NULL ) THEN

Line 2328: DELETE FROM pon_auc_items_interface

2324:
2325: -- Delete records from item table
2326: v_debug_status := 'DELETE_ITEM';
2327:
2328: DELETE FROM pon_auc_items_interface
2329: WHERE interface_auction_header_id = p_interface_id;
2330:
2331: -- Deletes records from attributes table
2332: v_debug_status := 'DELETE_ATTRIBUTES';

Line 2569: FROM pon_auc_items_interface

2565: v_attr_group_name fnd_lookup_values.meaning%TYPE;
2566:
2567: CURSOR lines IS
2568: SELECT interface_line_number
2569: FROM pon_auc_items_interface
2570: WHERE interface_auction_header_id = p_interface_id
2571: AND interface_line_number >= p_from_line_number
2572: AND interface_line_number <= p_to_line_number;
2573: