DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 22: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

18: -- be completed at this time.
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,

Line 51: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

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

Line 94: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

90: -- be completed at this time.
91: -- ======================================================================
92: PROCEDURE check_and_load_bid
93: (
94: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
95: p_draft_number IN pon_bid_headers.bid_number%TYPE,
96: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
97: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
98: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

Line 147: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

143: -- from previous round
144: -- ======================================================================
145: FUNCTION get_source_bid_for_spreadsheet
146: (
147: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
148: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
149: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
150: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
151: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,

Line 148: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,

144: -- ======================================================================
145: FUNCTION get_source_bid_for_spreadsheet
146: (
147: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
148: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
149: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
150: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
151: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
152: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,

Line 151: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,

147: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
148: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
149: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
150: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
151: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
152: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
153: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
154:
155: ) RETURN NUMBER;

Line 152: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,

148: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
149: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
150: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
151: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
152: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
153: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
154:
155: ) RETURN NUMBER;
156:

Line 306: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

302: -- side tables and copies attachments
303: -- ======================================================================
304: PROCEDURE create_new_draft_bid
305: (
306: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
307: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
308: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
309: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
310: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

Line 343: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

339: );
340:
341: PROCEDURE check_amendments_acked
342: (
343: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
344: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
345: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,
346: x_return_status OUT NOCOPY NUMBER,
347: x_return_code OUT NOCOPY VARCHAR2

Line 344: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,

340:
341: PROCEDURE check_amendments_acked
342: (
343: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
344: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
345: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,
346: x_return_status OUT NOCOPY NUMBER,
347: x_return_code OUT NOCOPY VARCHAR2
348: );

Line 345: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,

341: PROCEDURE check_amendments_acked
342: (
343: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
344: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
345: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,
346: x_return_status OUT NOCOPY NUMBER,
347: x_return_code OUT NOCOPY VARCHAR2
348: );
349: