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_REMINDER_NOTIFICATION_PKG dependencies on PON_BIDDING_PARTIES

Line 280: TYPE l_TP_contact_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_id%TYPE;

276: p_auction_header_id IN NUMBER
277: )
278: IS
279:
280: TYPE l_TP_contact_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_id%TYPE;
281: TYPE l_TP_contact_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_name%TYPE;
282: TYPE l_TP_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_name%TYPE;
283: TYPE l_vendor_site_code_table_type IS TABLE OF pon_bidding_parties.vendor_site_code%TYPE;
284: TYPE l_vendor_site_id_table_type IS TABLE OF pon_bidding_parties.vendor_site_id%TYPE;

Line 281: TYPE l_TP_contact_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_name%TYPE;

277: )
278: IS
279:
280: TYPE l_TP_contact_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_id%TYPE;
281: TYPE l_TP_contact_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_name%TYPE;
282: TYPE l_TP_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_name%TYPE;
283: TYPE l_vendor_site_code_table_type IS TABLE OF pon_bidding_parties.vendor_site_code%TYPE;
284: TYPE l_vendor_site_id_table_type IS TABLE OF pon_bidding_parties.vendor_site_id%TYPE;
285: TYPE l_add_con_email_table_type IS TABLE OF pon_bidding_parties.additional_contact_email%TYPE;

Line 282: TYPE l_TP_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_name%TYPE;

278: IS
279:
280: TYPE l_TP_contact_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_id%TYPE;
281: TYPE l_TP_contact_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_name%TYPE;
282: TYPE l_TP_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_name%TYPE;
283: TYPE l_vendor_site_code_table_type IS TABLE OF pon_bidding_parties.vendor_site_code%TYPE;
284: TYPE l_vendor_site_id_table_type IS TABLE OF pon_bidding_parties.vendor_site_id%TYPE;
285: TYPE l_add_con_email_table_type IS TABLE OF pon_bidding_parties.additional_contact_email%TYPE;
286: TYPE l_TP_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_id%TYPE;

Line 283: TYPE l_vendor_site_code_table_type IS TABLE OF pon_bidding_parties.vendor_site_code%TYPE;

279:
280: TYPE l_TP_contact_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_id%TYPE;
281: TYPE l_TP_contact_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_name%TYPE;
282: TYPE l_TP_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_name%TYPE;
283: TYPE l_vendor_site_code_table_type IS TABLE OF pon_bidding_parties.vendor_site_code%TYPE;
284: TYPE l_vendor_site_id_table_type IS TABLE OF pon_bidding_parties.vendor_site_id%TYPE;
285: TYPE l_add_con_email_table_type IS TABLE OF pon_bidding_parties.additional_contact_email%TYPE;
286: TYPE l_TP_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_id%TYPE;
287:

Line 284: TYPE l_vendor_site_id_table_type IS TABLE OF pon_bidding_parties.vendor_site_id%TYPE;

280: TYPE l_TP_contact_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_id%TYPE;
281: TYPE l_TP_contact_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_name%TYPE;
282: TYPE l_TP_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_name%TYPE;
283: TYPE l_vendor_site_code_table_type IS TABLE OF pon_bidding_parties.vendor_site_code%TYPE;
284: TYPE l_vendor_site_id_table_type IS TABLE OF pon_bidding_parties.vendor_site_id%TYPE;
285: TYPE l_add_con_email_table_type IS TABLE OF pon_bidding_parties.additional_contact_email%TYPE;
286: TYPE l_TP_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_id%TYPE;
287:
288: l_TP_contact_id_table l_TP_contact_id_table_type := l_TP_contact_id_table_type(NULL);

Line 285: TYPE l_add_con_email_table_type IS TABLE OF pon_bidding_parties.additional_contact_email%TYPE;

281: TYPE l_TP_contact_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_contact_name%TYPE;
282: TYPE l_TP_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_name%TYPE;
283: TYPE l_vendor_site_code_table_type IS TABLE OF pon_bidding_parties.vendor_site_code%TYPE;
284: TYPE l_vendor_site_id_table_type IS TABLE OF pon_bidding_parties.vendor_site_id%TYPE;
285: TYPE l_add_con_email_table_type IS TABLE OF pon_bidding_parties.additional_contact_email%TYPE;
286: TYPE l_TP_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_id%TYPE;
287:
288: l_TP_contact_id_table l_TP_contact_id_table_type := l_TP_contact_id_table_type(NULL);
289: l_TP_contact_name_table l_TP_contact_name_table_type := l_TP_contact_name_table_type(NULL);

Line 286: TYPE l_TP_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_id%TYPE;

282: TYPE l_TP_name_table_type IS TABLE OF pon_bidding_parties.trading_partner_name%TYPE;
283: TYPE l_vendor_site_code_table_type IS TABLE OF pon_bidding_parties.vendor_site_code%TYPE;
284: TYPE l_vendor_site_id_table_type IS TABLE OF pon_bidding_parties.vendor_site_id%TYPE;
285: TYPE l_add_con_email_table_type IS TABLE OF pon_bidding_parties.additional_contact_email%TYPE;
286: TYPE l_TP_id_table_type IS TABLE OF pon_bidding_parties.trading_partner_id%TYPE;
287:
288: l_TP_contact_id_table l_TP_contact_id_table_type := l_TP_contact_id_table_type(NULL);
289: l_TP_contact_name_table l_TP_contact_name_table_type := l_TP_contact_name_table_type(NULL);
290: l_TP_name_table l_TP_name_table_type := l_TP_name_table_type(NULL);

Line 355: FROM pon_bidding_parties pbp

351: l_TP_id_table,
352: l_vendor_site_id_table,
353: l_add_con_email_table
354:
355: FROM pon_bidding_parties pbp
356:
357: WHERE
358: pbp.auction_header_id = p_auction_header_id
359: AND pbp.trading_partner_contact_id NOT IN

Line 504: FROM pon_bidding_parties

500: BEGIN
501: SELECT wf_user_name
502: INTO
503: p_add_con_role_name
504: FROM pon_bidding_parties
505: WHERE auction_header_id = p_auction_header_id
506: AND trading_partner_id = p_supplier_id
507: AND Nvl(vendor_site_id,-1) = p_supplier_site_id;
508: