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_HEADERS_ALL

Line 207: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;

203:
204: v_debug_status VARCHAR2(100);
205: v_error_code VARCHAR2(100);
206: v_error_message VARCHAR2(400);
207: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;
208: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
209: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
210: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
211: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;

Line 208: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;

204: v_debug_status VARCHAR2(100);
205: v_error_code VARCHAR2(100);
206: v_error_message VARCHAR2(400);
207: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;
208: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
209: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
210: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
211: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
212: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;

Line 211: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;

207: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;
208: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
209: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
210: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
211: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
212: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
213: v_trading_partner_id pon_bidding_parties.trading_partner_id%TYPE;
214: v_trading_partner_name pon_bidding_parties.trading_partner_name%TYPE;
215: v_trading_partner_contact_id pon_bidding_parties.trading_partner_contact_id%TYPE;

Line 212: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;

208: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
209: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
210: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
211: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
212: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
213: v_trading_partner_id pon_bidding_parties.trading_partner_id%TYPE;
214: v_trading_partner_name pon_bidding_parties.trading_partner_name%TYPE;
215: v_trading_partner_contact_id pon_bidding_parties.trading_partner_contact_id%TYPE;
216: v_trading_partner_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE;

Line 235: v_auc_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;

231: v_contracts_doctype VARCHAR2(60);
232: v_return_status VARCHAR2(1);
233: v_msg_data VARCHAR2(400);
234: v_msg_count NUMBER;
235: v_auc_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
236: v_supplier_site_id pon_bidding_parties.vendor_site_id%TYPE;
237: v_supplier_site_code pon_bidding_parties.vendor_site_code%TYPE;
238:
239: v_price_break_response pon_auction_headers_all.price_break_response%type;

Line 239: v_price_break_response pon_auction_headers_all.price_break_response%type;

235: v_auc_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
236: v_supplier_site_id pon_bidding_parties.vendor_site_id%TYPE;
237: v_supplier_site_code pon_bidding_parties.vendor_site_code%TYPE;
238:
239: v_price_break_response pon_auction_headers_all.price_break_response%type;
240: v_price_break_type pon_auction_item_prices_all.price_break_type%type;
241: v_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;
242: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;
243:

Line 242: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;

238:
239: v_price_break_response pon_auction_headers_all.price_break_response%type;
240: v_price_break_type pon_auction_item_prices_all.price_break_type%type;
241: v_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;
242: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;
243:
244: l_is_super_large_neg VARCHAR2(1) := 'N';
245: l_number_of_lines NUMBER := -1;
246: l_request_id NUMBER := -1;

Line 286: l_standard_form pon_auction_headers_all.standard_form%TYPE;

282: l_return_status VARCHAR2(1);
283: --
284:
285: --Bug : 16690156
286: l_standard_form pon_auction_headers_all.standard_form%TYPE;
287: l_document_format pon_auction_headers_all.document_format%TYPE;
288:
289:
290: BEGIN

Line 287: l_document_format pon_auction_headers_all.document_format%TYPE;

283: --
284:
285: --Bug : 16690156
286: l_standard_form pon_auction_headers_all.standard_form%TYPE;
287: l_document_format pon_auction_headers_all.document_format%TYPE;
288:
289:
290: BEGIN
291:

Line 381: 'l_number_of_lines (number of lines to copy into PON tables, which may not be the same as the value in number_of_lines field in PON_AUCTION_HEADERS_ALL for this auction) : '||

377:
378: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
379: fnd_log.string(fnd_log.level_statement,
380: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
381: 'l_number_of_lines (number of lines to copy into PON tables, which may not be the same as the value in number_of_lines field in PON_AUCTION_HEADERS_ALL for this auction) : '||
382: l_number_of_lines ||';Cheking if l_number_of_lines > Threshold for p_party_id: '|| v_site_id);
383: end if;
384:
385: PON_PROFILE_UTIL_PKG.LINES_MORE_THAN_THRESHOLD(

Line 496: SELECT pon_auction_headers_all_s.NEXTVAL INTO x_document_number

492: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
493: 'Getting the document_number from sequence');
494: end if;
495:
496: SELECT pon_auction_headers_all_s.NEXTVAL INTO x_document_number
497: FROM dual;
498:
499: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
500: fnd_log.string(fnd_log.level_statement,

Line 669: 'Inserting row into PON_AUCTION_HEADERS_ALL with the following filed values -- ' ||

665:
666: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
667: fnd_log.string(fnd_log.level_statement,
668: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
669: 'Inserting row into PON_AUCTION_HEADERS_ALL with the following filed values -- ' ||
670: 'auction_header_id (x_document_number) : '|| x_document_number ||
671: '; document_number (x_document_number) : ' || x_document_number ||
672: '; amendment_number : ' || 0 ||
673: '; auction_status : ' || 'DRAFT' ||

Line 838: INSERT INTO pon_auction_headers_all

834: END IF;
835: --
836:
837:
838: INSERT INTO pon_auction_headers_all
839: (auction_header_id,
840: document_number,
841: auction_header_id_orig_amend,
842: auction_header_id_orig_round,

Line 994: /* Bug 9645160 - updated clm_document_number back in PON_AUCTION_HEADERS_ALL table. */

990: X_ERROR_MESSAGE := 'Error in PO_DOC_NUMBERING_PKG.DEFAULT_DOC_NUMBER_UDA';
991: RETURN;
992: END IF;
993:
994: /* Bug 9645160 - updated clm_document_number back in PON_AUCTION_HEADERS_ALL table. */
995:
996: UPDATE pon_auction_headers_all
997: SET DOCUMENT_NUMBER = clm_doc_number
998: WHERE AUCTION_HEADER_ID = x_document_number;

Line 996: UPDATE pon_auction_headers_all

992: END IF;
993:
994: /* Bug 9645160 - updated clm_document_number back in PON_AUCTION_HEADERS_ALL table. */
995:
996: UPDATE pon_auction_headers_all
997: SET DOCUMENT_NUMBER = clm_doc_number
998: WHERE AUCTION_HEADER_ID = x_document_number;
999:
1000: select uda_template_id into l_src_template_id from po_headers_all where po_header_id = g_header_rec.source_doc_id;

Line 1045: 'Inserted recore into pon_auction_headers_all');

1041:
1042: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1043: fnd_log.string(fnd_log.level_statement,
1044: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1045: 'Inserted recore into pon_auction_headers_all');
1046: end if;
1047:
1048: END IF; --end of IF (p_is_concurrent_call = 'N')
1049: --ONLINE TILL HERE-----------------------------------------------------------------------------------------------------

Line 1224: UPDATE pon_auction_headers_all

1220: WHERE unit_of_measure = 'Each';
1221: END;
1222:
1223:
1224: UPDATE pon_auction_headers_all
1225: SET price_tiers_indicator = 'PRICE_BREAKS'
1226: Where exists (SELECT 'Y'
1227: FROM pon_auc_shipments_interface
1228: WHERE interface_auction_header_id = p_interface_id

Line 2024: 'PON_AUCTION_HEADERS_ALL', -- entity_name

2020: Sysdate, -- last_update_date
2021: g_header_rec.user_id, -- last_updated_by
2022: NULL, -- last_update_login
2023: seq_num, -- seq_num
2024: 'PON_AUCTION_HEADERS_ALL', -- entity_name
2025: x_document_number, -- pk1_value
2026: NULL, -- pk2_value
2027: NULL, -- pk3_value
2028: NULL, -- pk4_value

Line 2221: 'Concurrent request successfully raised; Request id : ' || l_request_id ||' ; setting the request information into pon_auction_headers_all');

2217:
2218: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2219: fnd_log.string(fnd_log.level_statement,
2220: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2221: 'Concurrent request successfully raised; Request id : ' || l_request_id ||' ; setting the request information into pon_auction_headers_all');
2222: end if;
2223:
2224: update pon_auction_headers_all set
2225: request_id = l_request_id,

Line 2224: update pon_auction_headers_all set

2220: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2221: 'Concurrent request successfully raised; Request id : ' || l_request_id ||' ; setting the request information into pon_auction_headers_all');
2222: end if;
2223:
2224: update pon_auction_headers_all set
2225: request_id = l_request_id,
2226: number_of_lines = 0,
2227: requested_by = g_header_rec.user_id ,
2228: request_date = sysdate,

Line 2252: --COMPLETE_FLAG in pon_auction_headers_all to 'Y'.

2248: x_result := 'SUCCESS';
2249:
2250: --
2251: --Update the header record process_status to ACCEPTED and
2252: --COMPLETE_FLAG in pon_auction_headers_all to 'Y'.
2253: --Also set the NUMBER_OF_LINES and LAST_LINE_NUMBER fields
2254: --This should not be done if
2255: --(a) It is not a super large auction OR
2256: --(b) It is a super large auction and the call to this function is

Line 2288: UPDATE pon_auction_headers_all

2284:
2285:
2286:
2287:
2288: UPDATE pon_auction_headers_all
2289: SET complete_flag = 'Y', number_of_lines = l_number_of_lines, last_line_number = l_last_line_number
2290: WHERE auction_header_id = x_document_number;
2291:
2292: END IF; --IF (l_is_super_large_neg = N) OR (l_is_super_large_neg = 'Y' AND p_is_concurrent_call = 'Y')

Line 3047: p_document_number IN NUMBER Auction_header_id in PON_AUCTION_HEADERS_ALL

3043: /* ======================================================================
3044: PROCEDURE : get_display_line_number PUBLIC
3045: PARAMETERS:
3046:
3047: p_document_number IN NUMBER Auction_header_id in PON_AUCTION_HEADERS_ALL
3048: p_interface_id IN NUMBER interface id
3049: p_from_line_number IN Line number from whcih the validation has to start
3050: p_to_line_number IN Line number till whcih the validation has to be done
3051:

Line 3089: ppp.party_id = (select trading_partner_id from pon_auction_headers_all where auction_header_id = p_document_number) and

3085: from pon_party_preferences ppp,
3086: fnd_lookup_values flv
3087: where ppp.app_short_name = 'PON' and
3088: ppp.preference_name = 'LINE_ATTR_DEFAULT_GROUP' and
3089: ppp.party_id = (select trading_partner_id from pon_auction_headers_all where auction_header_id = p_document_number) and
3090: flv.lookup_type = 'PON_LINE_ATTRIBUTE_GROUPS' and
3091: nvl(ppp.preference_value,'GENERAL') = flv.lookup_code and
3092: flv.view_application_id = 0 and
3093: flv.security_group_id = 0 and

Line 3334: 'Clearing request_id in pon_auction_headers_all');

3330:
3331: /* if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3332: fnd_log.string(fnd_log.level_statement,
3333: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3334: 'Clearing request_id in pon_auction_headers_all');
3335: end if;
3336:
3337: update pon_auction_headers_all
3338: set request_id = null

Line 3337: update pon_auction_headers_all

3333: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3334: 'Clearing request_id in pon_auction_headers_all');
3335: end if;
3336:
3337: update pon_auction_headers_all
3338: set request_id = null
3339: where auction_header_id = p_auction_header_id;
3340: */
3341: RETCODE := '0';

Line 3346: 'Cleared request_id in pon_auction_headers_all for auction_header_id : ' || p_auction_header_id ||' ; returning');

3342:
3343: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
3344: fnd_log.string(fnd_log.level_statement,
3345: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
3346: 'Cleared request_id in pon_auction_headers_all for auction_header_id : ' || p_auction_header_id ||' ; returning');
3347: end if;
3348:
3349: Commit;
3350: