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

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

Line 197: v_trading_partner_contact_id pon_bidding_parties.trading_partner_contact_id%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;
199: v_blanket_bidders_curr VARCHAR2(1) := 'N';
200: v_set_as_bidders_curr VARCHAR2(1) := 'N';
201: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;

Line 198: v_trading_partner_contact_name pon_bidding_parties.trading_partner_contact_name%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;
199: v_blanket_bidders_curr VARCHAR2(1) := 'N';
200: v_set_as_bidders_curr VARCHAR2(1) := 'N';
201: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
202:

Line 218: v_supplier_site_id pon_bidding_parties.vendor_site_id%TYPE;

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

Line 219: v_supplier_site_code pon_bidding_parties.vendor_site_code%TYPE;

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

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

1587: g_header_rec.user_id -- created_by
1588: ) ;
1589: END IF;
1590:
1591: -- Add the supplier information on the blanket to the PON_BIDDING_PARTIES
1592: -- transaction table.
1593: v_debug_status := 'INSERT_SUPPLIER_INFO';
1594:
1595: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

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

1594:
1595: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1596: fnd_log.string(fnd_log.level_statement,
1597: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1598: 'Addding the supplier information on the blanket to the PON_BIDDING_PARTIES; selectiong supplier_site_id' );
1599: end if;
1600:
1601: select supplier_site_id
1602: into v_supplier_site_id

Line 1660: 'Inserting record into PON_BIDDING_PARTIES' );

1656:
1657: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1658: fnd_log.string(fnd_log.level_statement,
1659: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1660: 'Inserting record into PON_BIDDING_PARTIES' );
1661: end if;
1662:
1663:
1664: INSERT INTO pon_bidding_parties

Line 1664: INSERT INTO pon_bidding_parties

1660: 'Inserting record into PON_BIDDING_PARTIES' );
1661: end if;
1662:
1663:
1664: INSERT INTO pon_bidding_parties
1665: (auction_header_id,
1666: list_id,
1667: sequence,
1668: trading_partner_name,