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

Line 23: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

19: -- ======================================================================
20: PROCEDURE is_bidding_allowed
21: (
22: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
23: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
24: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
25: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
26: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
27: p_buyer_user IN VARCHAR2,

Line 24: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

20: PROCEDURE is_bidding_allowed
21: (
22: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
23: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
24: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
25: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
26: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
27: p_buyer_user IN VARCHAR2,
28: p_action_code IN VARCHAR2,

Line 25: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

21: (
22: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
23: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
24: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
25: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
26: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
27: p_buyer_user IN VARCHAR2,
28: p_action_code IN VARCHAR2,
29: x_return_status OUT NOCOPY NUMBER,

Line 26: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

22: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
23: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
24: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
25: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
26: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
27: p_buyer_user IN VARCHAR2,
28: p_action_code IN VARCHAR2,
29: x_return_status OUT NOCOPY NUMBER,
30: x_return_code OUT NOCOPY VARCHAR2

Line 48: p_source_bid IN pon_bid_headers.bid_number%TYPE,

44: -- ======================================================================
45: PROCEDURE create_defaulted_draft
46: (
47: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
48: p_source_bid IN pon_bid_headers.bid_number%TYPE,
49: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
50: );
51:
52: -- ======================================================================

Line 49: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE

45: PROCEDURE create_defaulted_draft
46: (
47: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
48: p_source_bid IN pon_bid_headers.bid_number%TYPE,
49: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
50: );
51:
52: -- ======================================================================
53: -- PROCEDURE: CHECK_AND_LOAD_BID PUBLIC

Line 86: p_draft_number IN pon_bid_headers.bid_number%TYPE,

82: -- ======================================================================
83: PROCEDURE check_and_load_bid
84: (
85: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
86: p_draft_number IN pon_bid_headers.bid_number%TYPE,
87: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
88: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
89: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
90: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,

Line 87: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

83: PROCEDURE check_and_load_bid
84: (
85: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
86: p_draft_number IN pon_bid_headers.bid_number%TYPE,
87: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
88: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
89: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
90: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
91: p_userid IN pon_bid_headers.created_by%TYPE,

Line 88: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

84: (
85: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
86: p_draft_number IN pon_bid_headers.bid_number%TYPE,
87: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
88: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
89: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
90: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
91: p_userid IN pon_bid_headers.created_by%TYPE,
92: p_venid IN pon_bid_headers.vendor_id%TYPE,

Line 89: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

85: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
86: p_draft_number IN pon_bid_headers.bid_number%TYPE,
87: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
88: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
89: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
90: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
91: p_userid IN pon_bid_headers.created_by%TYPE,
92: p_venid IN pon_bid_headers.vendor_id%TYPE,
93: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 90: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,

86: p_draft_number IN pon_bid_headers.bid_number%TYPE,
87: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
88: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
89: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
90: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
91: p_userid IN pon_bid_headers.created_by%TYPE,
92: p_venid IN pon_bid_headers.vendor_id%TYPE,
93: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
94: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

Line 91: p_userid IN pon_bid_headers.created_by%TYPE,

87: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
88: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
89: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
90: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
91: p_userid IN pon_bid_headers.created_by%TYPE,
92: p_venid IN pon_bid_headers.vendor_id%TYPE,
93: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
94: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
95: p_buyer_user IN VARCHAR2,

Line 92: p_venid IN pon_bid_headers.vendor_id%TYPE,

88: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
89: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
90: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
91: p_userid IN pon_bid_headers.created_by%TYPE,
92: p_venid IN pon_bid_headers.vendor_id%TYPE,
93: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
94: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
95: p_buyer_user IN VARCHAR2,
96: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

Line 93: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

89: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
90: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
91: p_userid IN pon_bid_headers.created_by%TYPE,
92: p_venid IN pon_bid_headers.vendor_id%TYPE,
93: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
94: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
95: p_buyer_user IN VARCHAR2,
96: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
97: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

Line 94: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

90: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
91: p_userid IN pon_bid_headers.created_by%TYPE,
92: p_venid IN pon_bid_headers.vendor_id%TYPE,
93: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
94: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
95: p_buyer_user IN VARCHAR2,
96: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
97: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
98:

Line 96: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

92: p_venid IN pon_bid_headers.vendor_id%TYPE,
93: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
94: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
95: p_buyer_user IN VARCHAR2,
96: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
97: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
98:
99: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
100: x_rebid_flag OUT NOCOPY VARCHAR2,

Line 97: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

93: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
94: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
95: p_buyer_user IN VARCHAR2,
96: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
97: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
98:
99: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
100: x_rebid_flag OUT NOCOPY VARCHAR2,
101: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

Line 99: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

95: p_buyer_user IN VARCHAR2,
96: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
97: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
98:
99: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
100: x_rebid_flag OUT NOCOPY VARCHAR2,
101: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
102: x_amend_bid_def OUT NOCOPY VARCHAR2,
103: x_round_bid_def OUT NOCOPY VARCHAR2,

Line 101: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

97: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
98:
99: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
100: x_rebid_flag OUT NOCOPY VARCHAR2,
101: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
102: x_amend_bid_def OUT NOCOPY VARCHAR2,
103: x_round_bid_def OUT NOCOPY VARCHAR2,
104: x_prev_bid_disq OUT NOCOPY VARCHAR2,
105: x_edit_draft OUT NOCOPY VARCHAR2,

Line 133: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

129: FUNCTION get_source_bid_for_spreadsheet
130: (
131: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
132: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
133: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
134: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
135: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
136: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
137: p_vensid IN pon_bid_headers.vendor_site_id%TYPE

Line 134: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

130: (
131: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
132: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
133: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
134: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
135: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
136: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
137: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
138:

Line 137: p_vensid IN pon_bid_headers.vendor_site_id%TYPE

133: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
134: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
135: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
136: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
137: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
138:
139: ) RETURN NUMBER;
140:
141: