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_BIDDING_PARTIES

Line 213: v_trading_partner_id pon_bidding_parties.trading_partner_id%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;
217: v_blanket_bidders_curr VARCHAR2(1) := 'N';

Line 214: v_trading_partner_name pon_bidding_parties.trading_partner_name%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;
217: v_blanket_bidders_curr VARCHAR2(1) := 'N';
218: v_set_as_bidders_curr VARCHAR2(1) := 'N';

Line 215: v_trading_partner_contact_id pon_bidding_parties.trading_partner_contact_id%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;
217: v_blanket_bidders_curr VARCHAR2(1) := 'N';
218: v_set_as_bidders_curr VARCHAR2(1) := 'N';
219: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;

Line 216: v_trading_partner_contact_name pon_bidding_parties.trading_partner_contact_name%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;
217: v_blanket_bidders_curr VARCHAR2(1) := 'N';
218: v_set_as_bidders_curr VARCHAR2(1) := 'N';
219: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
220:

Line 236: v_supplier_site_id pon_bidding_parties.vendor_site_id%TYPE;

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;
240: v_price_break_type pon_auction_item_prices_all.price_break_type%type;

Line 237: v_supplier_site_code pon_bidding_parties.vendor_site_code%TYPE;

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;
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;

Line 2076: -- Add the supplier information on the blanket to the PON_BIDDING_PARTIES

2072: g_header_rec.user_id -- created_by
2073: ) ;
2074: END IF;
2075:
2076: -- Add the supplier information on the blanket to the PON_BIDDING_PARTIES
2077: -- transaction table.
2078: v_debug_status := 'INSERT_SUPPLIER_INFO';
2079:
2080: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 2083: 'Addding the supplier information on the blanket to the PON_BIDDING_PARTIES; selectiong supplier_site_id' );

2079:
2080: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2081: fnd_log.string(fnd_log.level_statement,
2082: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2083: 'Addding the supplier information on the blanket to the PON_BIDDING_PARTIES; selectiong supplier_site_id' );
2084: end if;
2085:
2086: select supplier_site_id
2087: into v_supplier_site_id

Line 2145: 'Inserting record into PON_BIDDING_PARTIES' );

2141:
2142: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
2143: fnd_log.string(fnd_log.level_statement,
2144: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2145: 'Inserting record into PON_BIDDING_PARTIES' );
2146: end if;
2147:
2148:
2149: INSERT INTO pon_bidding_parties

Line 2149: INSERT INTO pon_bidding_parties

2145: 'Inserting record into PON_BIDDING_PARTIES' );
2146: end if;
2147:
2148:
2149: INSERT INTO pon_bidding_parties
2150: (auction_header_id,
2151: list_id,
2152: sequence,
2153: trading_partner_name,