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_AUCTION_ITEM_PRICES_ALL

Line 210: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;

206:
207: v_bidders_currency_rate NUMBER := 1;
208: v_att_category_id fnd_document_categories.category_id%TYPE;
209: v_seq_num fnd_attached_documents.seq_num%TYPE;
210: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
211: v_amount_based_lines NUMBER;
212:
213: v_contracts_doctype VARCHAR2(60);
214: v_return_status VARCHAR2(1);

Line 222: v_price_break_type pon_auction_item_prices_all.price_break_type%type;

218: v_supplier_site_id pon_bidding_parties.vendor_site_id%TYPE;
219: v_supplier_site_code pon_bidding_parties.vendor_site_code%TYPE;
220:
221: v_price_break_response pon_auction_headers_all.price_break_response%type;
222: v_price_break_type pon_auction_item_prices_all.price_break_type%type;
223: v_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;
224: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;
225:
226: l_is_super_large_neg VARCHAR2(1) := 'N';

Line 223: v_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;

219: v_supplier_site_code pon_bidding_parties.vendor_site_code%TYPE;
220:
221: v_price_break_response pon_auction_headers_all.price_break_response%type;
222: v_price_break_type pon_auction_item_prices_all.price_break_type%type;
223: v_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;
224: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;
225:
226: l_is_super_large_neg VARCHAR2(1) := 'N';
227: l_number_of_lines NUMBER := -1;

Line 1060: 'inserting into pon_auction_item_prices_all for auction_header_id (x_document_number) : ' || x_document_number);

1056:
1057: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1058: fnd_log.string(fnd_log.level_statement,
1059: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1060: 'inserting into pon_auction_item_prices_all for auction_header_id (x_document_number) : ' || x_document_number);
1061: end if;
1062:
1063: -- Then insert into the items transaction table.
1064: -- Here we will initially set the has_shipments flag to 'N'

Line 1066: INSERT INTO pon_auction_item_prices_all

1062:
1063: -- Then insert into the items transaction table.
1064: -- Here we will initially set the has_shipments flag to 'N'
1065: -- and then do an update by checking if shipments are present
1066: INSERT INTO pon_auction_item_prices_all
1067: (auction_header_id,
1068: line_number,
1069: disp_line_number,
1070: last_amendment_update,

Line 1175: UPDATE pon_auction_item_prices_all

1171: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1172: ' Updating the shipments flag based on if there are shipments');
1173: end if;
1174:
1175: UPDATE pon_auction_item_prices_all
1176: SET has_shipments_flag = 'Y'
1177: WHERE (line_number) IN
1178: (SELECT interface_line_number
1179: FROM pon_auc_shipments_interface

Line 1193: UPDATE pon_auction_item_prices_all

1189: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1190: ' Updating the price differntials flag based on if their are price differentials at item level');
1191: end if;
1192:
1193: UPDATE pon_auction_item_prices_all
1194: SET has_price_differentials_flag = 'Y',
1195: differential_response_type = 'OPTIONAL'
1196: WHERE (line_number) IN
1197: (SELECT interface_line_number

Line 1206: --Update the attachment_flag in pon_auction_item_prices_all table for all the

1202: AND interface_shipment_number = -1)
1203: AND auction_header_id = x_document_number;
1204:
1205:
1206: --Update the attachment_flag in pon_auction_item_prices_all table for all the
1207: --items that have an attachment.
1208: -- Since attachments can come from either po line or item itself
1209: -- update the flag after attachments have been inserted.
1210: -- UPDATE pon_auction_item_prices_all

Line 1210: -- UPDATE pon_auction_item_prices_all

1206: --Update the attachment_flag in pon_auction_item_prices_all table for all the
1207: --items that have an attachment.
1208: -- Since attachments can come from either po line or item itself
1209: -- update the flag after attachments have been inserted.
1210: -- UPDATE pon_auction_item_prices_all
1211: -- SET attachment_flag = 'Y'
1212: -- WHERE auction_header_id = x_document_number
1213: -- AND line_number IN (SELECT interface_line_number
1214: -- FROM pon_attachments_interface

Line 1421: 'PON_AUCTION_ITEM_PRICES_ALL', -- entity_name

1417: Sysdate, -- last_update_date
1418: g_header_rec.user_id, -- last_updated_by
1419: NULL, -- last_update_login
1420: seq_num, -- seq_num
1421: 'PON_AUCTION_ITEM_PRICES_ALL', -- entity_name
1422: x_document_number, -- pk1_value
1423: interface_line_number, -- pk2_value
1424: NULL, -- pk3_value
1425: NULL, -- pk4_value

Line 1435: --Update the attachment_flag in pon_auction_item_prices_all

1431: AND interface_line_number IS NOT NULL
1432: AND interface_line_number >= l_batch_start
1433: AND interface_line_number <= l_batch_end;
1434:
1435: --Update the attachment_flag in pon_auction_item_prices_all
1436: --table for all the items that have attachments.
1437:
1438: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1439: fnd_log.string(fnd_log.level_statement,

Line 1441: 'Updating the attachment_flag in pon_auction_item_prices_all table for all the items that have attachments.' );

1437:
1438: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1439: fnd_log.string(fnd_log.level_statement,
1440: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1441: 'Updating the attachment_flag in pon_auction_item_prices_all table for all the items that have attachments.' );
1442: end if;
1443:
1444: UPDATE pon_auction_item_prices_all
1445: SET attachment_flag = 'Y'

Line 1444: UPDATE pon_auction_item_prices_all

1440: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1441: 'Updating the attachment_flag in pon_auction_item_prices_all table for all the items that have attachments.' );
1442: end if;
1443:
1444: UPDATE pon_auction_item_prices_all
1445: SET attachment_flag = 'Y'
1446: WHERE auction_header_id = x_document_number
1447: AND line_number IN (SELECT to_number(pk2_value)
1448: FROM fnd_attached_documents

Line 1449: WHERE entity_name = 'PON_AUCTION_ITEM_PRICES_ALL'

1445: SET attachment_flag = 'Y'
1446: WHERE auction_header_id = x_document_number
1447: AND line_number IN (SELECT to_number(pk2_value)
1448: FROM fnd_attached_documents
1449: WHERE entity_name = 'PON_AUCTION_ITEM_PRICES_ALL'
1450: AND pk1_value = to_char(x_document_number))
1451: AND line_number >= l_batch_start
1452: AND line_number <= l_batch_end;
1453:

Line 1796: FROM PON_AUCTION_ITEM_PRICES_ALL

1792:
1793: SELECT
1794: COUNT(LINE_NUMBER) number_of_lines, MAX (DECODE (GROUP_TYPE, 'LOT_LINE', 0, 'GROUP_LINE', 0, SUB_LINE_SEQUENCE_NUMBER)) last_line_number
1795: INTO l_number_of_lines, l_last_line_number
1796: FROM PON_AUCTION_ITEM_PRICES_ALL
1797: WHERE
1798: AUCTION_HEADER_ID = x_document_number;
1799:
1800:

Line 2506: pon_auction_item_prices_all

2502: document_disp_line_number
2503: into
2504: x_display_line_number
2505: from
2506: pon_auction_item_prices_all
2507: where
2508: auction_header_id = p_auction_header_id and
2509: line_number = p_auction_line_number;
2510: exception