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.

[Home] [Help]

APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_AUCTION_HEADERS_ALL

Line 189: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;

185:
186: v_debug_status VARCHAR2(100);
187: v_error_code VARCHAR2(100);
188: v_error_message VARCHAR2(400);
189: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;
190: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
191: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
192: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
193: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;

Line 190: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;

186: v_debug_status VARCHAR2(100);
187: v_error_code VARCHAR2(100);
188: v_error_message VARCHAR2(400);
189: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;
190: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
191: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
192: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
193: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
194: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;

Line 193: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;

189: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;
190: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
191: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
192: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
193: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
194: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
195: v_trading_partner_id pon_bidding_parties.trading_partner_id%TYPE;
196: v_trading_partner_name pon_bidding_parties.trading_partner_name%TYPE;
197: v_trading_partner_contact_id pon_bidding_parties.trading_partner_contact_id%TYPE;

Line 194: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;

190: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
191: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
192: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
193: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
194: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
195: v_trading_partner_id pon_bidding_parties.trading_partner_id%TYPE;
196: v_trading_partner_name pon_bidding_parties.trading_partner_name%TYPE;
197: v_trading_partner_contact_id pon_bidding_parties.trading_partner_contact_id%TYPE;
198: v_trading_partner_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE;

Line 217: v_auc_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;

213: v_contracts_doctype VARCHAR2(60);
214: v_return_status VARCHAR2(1);
215: v_msg_data VARCHAR2(400);
216: v_msg_count NUMBER;
217: v_auc_contact_id pon_auction_headers_all.trading_partner_contact_id%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;

Line 221: v_price_break_response pon_auction_headers_all.price_break_response%type;

217: v_auc_contact_id pon_auction_headers_all.trading_partner_contact_id%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:

Line 224: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%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;
228: l_request_id NUMBER := -1;

Line 342: '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) : '||

338:
339: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
340: fnd_log.string(fnd_log.level_statement,
341: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
342: '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) : '||
343: l_number_of_lines ||';Cheking if l_number_of_lines > Threshold for p_party_id: '|| v_site_id);
344: end if;
345:
346: PON_PROFILE_UTIL_PKG.LINES_MORE_THAN_THRESHOLD(

Line 457: SELECT pon_auction_headers_all_s.NEXTVAL INTO x_document_number

453: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
454: 'Getting the document_number from sequence');
455: end if;
456:
457: SELECT pon_auction_headers_all_s.NEXTVAL INTO x_document_number
458: FROM dual;
459:
460: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
461: fnd_log.string(fnd_log.level_statement,

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

626:
627: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
628: fnd_log.string(fnd_log.level_statement,
629: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
630: 'Inserting row into PON_AUCTION_HEADERS_ALL with the following filed values -- ' ||
631: 'auction_header_id (x_document_number) : '|| x_document_number ||
632: '; document_number (x_document_number) : ' || x_document_number ||
633: '; amendment_number : ' || 0 ||
634: '; auction_status : ' || 'DRAFT' ||

Line 681: INSERT INTO pon_auction_headers_all

677: );
678: end if;
679:
680:
681: INSERT INTO pon_auction_headers_all
682: (auction_header_id,
683: document_number,
684: auction_header_id_orig_amend,
685: auction_header_id_orig_round,

Line 796: 'Inserted recore into pon_auction_headers_all');

792:
793: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
794: fnd_log.string(fnd_log.level_statement,
795: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
796: 'Inserted recore into pon_auction_headers_all');
797: end if;
798:
799: END IF; --end of IF (p_is_concurrent_call = 'N')
800: --ONLINE TILL HERE-----------------------------------------------------------------------------------------------------

Line 975: UPDATE pon_auction_headers_all

971: WHERE unit_of_measure = 'Each';
972: END;
973:
974:
975: UPDATE pon_auction_headers_all
976: SET price_tiers_indicator = 'PRICE_BREAKS'
977: Where exists (SELECT 'Y'
978: FROM pon_auc_shipments_interface
979: WHERE interface_auction_header_id = p_interface_id

Line 1539: 'PON_AUCTION_HEADERS_ALL', -- entity_name

1535: Sysdate, -- last_update_date
1536: g_header_rec.user_id, -- last_updated_by
1537: NULL, -- last_update_login
1538: seq_num, -- seq_num
1539: 'PON_AUCTION_HEADERS_ALL', -- entity_name
1540: x_document_number, -- pk1_value
1541: NULL, -- pk2_value
1542: NULL, -- pk3_value
1543: NULL, -- pk4_value

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

1732:
1733: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1734: fnd_log.string(fnd_log.level_statement,
1735: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1736: 'Concurrent request successfully raised; Request id : ' || l_request_id ||' ; setting the request information into pon_auction_headers_all');
1737: end if;
1738:
1739: update pon_auction_headers_all set
1740: request_id = l_request_id,

Line 1739: update pon_auction_headers_all set

1735: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1736: 'Concurrent request successfully raised; Request id : ' || l_request_id ||' ; setting the request information into pon_auction_headers_all');
1737: end if;
1738:
1739: update pon_auction_headers_all set
1740: request_id = l_request_id,
1741: number_of_lines = 0,
1742: requested_by = g_header_rec.user_id ,
1743: request_date = sysdate,

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

1763: x_result := 'SUCCESS';
1764:
1765: --
1766: --Update the header record process_status to ACCEPTED and
1767: --COMPLETE_FLAG in pon_auction_headers_all to 'Y'.
1768: --Also set the NUMBER_OF_LINES and LAST_LINE_NUMBER fields
1769: --This should not be done if
1770: --(a) It is not a super large auction OR
1771: --(b) It is a super large auction and the call to this function is

Line 1803: UPDATE pon_auction_headers_all

1799:
1800:
1801:
1802:
1803: UPDATE pon_auction_headers_all
1804: SET complete_flag = 'Y', number_of_lines = l_number_of_lines, last_line_number = l_last_line_number
1805: WHERE auction_header_id = x_document_number;
1806:
1807: END IF; --IF (l_is_super_large_neg = N) OR (l_is_super_large_neg = 'Y' AND p_is_concurrent_call = 'Y')

Line 2548: p_document_number IN NUMBER Auction_header_id in PON_AUCTION_HEADERS_ALL

2544: /* ======================================================================
2545: PROCEDURE : get_display_line_number PUBLIC
2546: PARAMETERS:
2547:
2548: p_document_number IN NUMBER Auction_header_id in PON_AUCTION_HEADERS_ALL
2549: p_interface_id IN NUMBER interface id
2550: p_from_line_number IN Line number from whcih the validation has to start
2551: p_to_line_number IN Line number till whcih the validation has to be done
2552:

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

2586: from pon_party_preferences ppp,
2587: fnd_lookup_values flv
2588: where ppp.app_short_name = 'PON' and
2589: ppp.preference_name = 'LINE_ATTR_DEFAULT_GROUP' and
2590: ppp.party_id = (select trading_partner_id from pon_auction_headers_all where auction_header_id = p_document_number) and
2591: flv.lookup_type = 'PON_LINE_ATTRIBUTE_GROUPS' and
2592: nvl(ppp.preference_value,'GENERAL') = flv.lookup_code and
2593: flv.view_application_id = 0 and
2594: flv.security_group_id = 0 and

Line 2835: 'Clearing request_id in pon_auction_headers_all');

2831:
2832: /* if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2833: fnd_log.string(fnd_log.level_statement,
2834: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
2835: 'Clearing request_id in pon_auction_headers_all');
2836: end if;
2837:
2838: update pon_auction_headers_all
2839: set request_id = null

Line 2838: update pon_auction_headers_all

2834: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
2835: 'Clearing request_id in pon_auction_headers_all');
2836: end if;
2837:
2838: update pon_auction_headers_all
2839: set request_id = null
2840: where auction_header_id = p_auction_header_id;
2841: */
2842: RETCODE := '0';

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

2843:
2844: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2845: fnd_log.string(fnd_log.level_statement,
2846: 'pon.plsql.pon_sourcing_openapi_grp.pon_reneg_super_large_neg',
2847: 'Cleared request_id in pon_auction_headers_all for auction_header_id : ' || p_auction_header_id ||' ; returning');
2848: end if;
2849:
2850: Commit;
2851: