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_UNSOL_UTIL_PKG dependencies on PON_BID_HEADERS

Line 315: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

311: PROCEDURE INSERT_INTO_BID_ITEMS(p_auction_id IN NUMBER,
312: p_source_bid_num IN NUMBER,
313: p_bid_number IN NUMBER,
314: p_uda_template_id IN NUMBER,
315: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
316: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
317: p_userid IN pon_bid_headers.created_by%TYPE,
318: p_vensid IN pon_bid_headers.vendor_site_id%TYPE)
319: IS

Line 316: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

312: p_source_bid_num IN NUMBER,
313: p_bid_number IN NUMBER,
314: p_uda_template_id IN NUMBER,
315: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
316: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
317: p_userid IN pon_bid_headers.created_by%TYPE,
318: p_vensid IN pon_bid_headers.vendor_site_id%TYPE)
319: IS
320: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;

Line 317: p_userid IN pon_bid_headers.created_by%TYPE,

313: p_bid_number IN NUMBER,
314: p_uda_template_id IN NUMBER,
315: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
316: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
317: p_userid IN pon_bid_headers.created_by%TYPE,
318: p_vensid IN pon_bid_headers.vendor_site_id%TYPE)
319: IS
320: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
321: BEGIN

Line 318: p_vensid IN pon_bid_headers.vendor_site_id%TYPE)

314: p_uda_template_id IN NUMBER,
315: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
316: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
317: p_userid IN pon_bid_headers.created_by%TYPE,
318: p_vensid IN pon_bid_headers.vendor_site_id%TYPE)
319: IS
320: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
321: BEGIN
322: SELECT ah.trading_partner_id

Line 658: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

654: END COPY_UNSOL_LINE_UDA;
655:
656: PROCEDURE copy_unsol_line_attachments
657: (
658: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
659: p_bid_number IN pon_bid_headers.bid_number%TYPE,
660: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
661: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
662: p_userid IN pon_bid_headers.created_by%TYPE

Line 659: p_bid_number IN pon_bid_headers.bid_number%TYPE,

655:
656: PROCEDURE copy_unsol_line_attachments
657: (
658: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
659: p_bid_number IN pon_bid_headers.bid_number%TYPE,
660: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
661: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
662: p_userid IN pon_bid_headers.created_by%TYPE
663: ) IS

Line 660: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,

656: PROCEDURE copy_unsol_line_attachments
657: (
658: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
659: p_bid_number IN pon_bid_headers.bid_number%TYPE,
660: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
661: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
662: p_userid IN pon_bid_headers.created_by%TYPE
663: ) IS
664:

Line 661: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

657: (
658: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
659: p_bid_number IN pon_bid_headers.bid_number%TYPE,
660: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
661: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
662: p_userid IN pon_bid_headers.created_by%TYPE
663: ) IS
664:
665: CURSOR unsol_lines_with_attachments IS

Line 662: p_userid IN pon_bid_headers.created_by%TYPE

658: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
659: p_bid_number IN pon_bid_headers.bid_number%TYPE,
660: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
661: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
662: p_userid IN pon_bid_headers.created_by%TYPE
663: ) IS
664:
665: CURSOR unsol_lines_with_attachments IS
666: SELECT DISTINCT ad.pk3_value

Line 697: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

693: PROCEDURE COPY_UNSOL_OFFER_LINES(p_auction_id IN NUMBER,
694: p_source_bid_num IN NUMBER,
695: p_bid_number IN NUMBER,
696: p_uda_template_id IN NUMBER,
697: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
698: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
699: p_userid IN pon_bid_headers.created_by%TYPE,
700: p_vensid IN pon_bid_headers.vendor_site_id%TYPE)
701: IS

Line 698: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

694: p_source_bid_num IN NUMBER,
695: p_bid_number IN NUMBER,
696: p_uda_template_id IN NUMBER,
697: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
698: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
699: p_userid IN pon_bid_headers.created_by%TYPE,
700: p_vensid IN pon_bid_headers.vendor_site_id%TYPE)
701: IS
702:

Line 699: p_userid IN pon_bid_headers.created_by%TYPE,

695: p_bid_number IN NUMBER,
696: p_uda_template_id IN NUMBER,
697: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
698: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
699: p_userid IN pon_bid_headers.created_by%TYPE,
700: p_vensid IN pon_bid_headers.vendor_site_id%TYPE)
701: IS
702:
703: l_has_unsol_lines VARCHAR2(1);

Line 700: p_vensid IN pon_bid_headers.vendor_site_id%TYPE)

696: p_uda_template_id IN NUMBER,
697: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
698: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
699: p_userid IN pon_bid_headers.created_by%TYPE,
700: p_vensid IN pon_bid_headers.vendor_site_id%TYPE)
701: IS
702:
703: l_has_unsol_lines VARCHAR2(1);
704: l_return_status VARCHAR2(1);