1 PACKAGE PON_AUCTION_HEADERS_PKG AUTHID CURRENT_USER AS
2 -- $Header: PONAUCHS.pls 120.7 2007/06/18 10:56:01 ukottama ship $
3 --===================
4 -- PROCEDURES
5 --===================
6 --========================================================================
7 -- PROCEDURE : Update_Auction_Info PUBLIC
8 -- PARAMETERS:
9 -- VERSION : current version 1.0
10 -- initial version 1.0
11 -- COMMENT : Updating auction information
12 --========================================================================
13 PROCEDURE update_proxy_bid
14 ( p_auctionHeaderId IN NUMBER,
15 p_bidNumber IN NUMBER,
16 p_oldBidNumber IN NUMBER,
17 p_isSurrogateBid IN VARCHAR2,
18 p_isAuctionClosed IN VARCHAR2,
19 x_isPriceChanged OUT NOCOPY VARCHAR2
20 );
21
22 PROCEDURE cancel_all_proxy_bid_lines
23 ( p_auctionHeaderId IN NUMBER
24 , p_tradingPartnerId IN NUMBER
25 , p_tradingPartnerContactId IN NUMBER
26 , x_status OUT NOCOPY VARCHAR2
27 );
28
29 PROCEDURE cancel_proxy_bid_line
30 ( p_auctionHeaderId IN NUMBER
31 , p_lineNumber IN NUMBER
32 , p_bidNumber IN NUMBER
33 , p_tradingPartnerId IN NUMBER
34 , p_tradingPartnerContactId IN NUMBER
35 , x_bidNumber OUT NOCOPY NUMBER
36 , x_status OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE UPDATE_AUCTION_INFO
40 ( p_auctionHeaderId IN NUMBER,
41 p_bidNumber IN NUMBER,
42 p_vendorSiteId IN NUMBER,
43 p_isRebid IN VARCHAR2,
44 p_prevBidNumber IN NUMBER,
45 p_isSavingDraft IN VARCHAR2,
46 p_isSurrogateBid IN VARCHAR2,
47 p_loginUserId IN NUMBER,
48 x_return_status OUT NOCOPY NUMBER,
49 x_return_code OUT NOCOPY VARCHAR2
50 );
51
52
53
54 PROCEDURE check_is_bid_valid
55 ( p_auctionHeaderId IN NUMBER,
56 p_bidNumber IN NUMBER,
57 p_vendorSiteId IN NUMBER,
58 p_prevBidNumber IN NUMBER,
59 p_isRebid IN VARCHAR2,
60 p_isSavingDraft IN VARCHAR2,
61 p_surrogBidFlag IN VARCHAR2,
62 p_publishDate IN DATE,
63 x_return_status OUT NOCOPY NUMBER,
64 x_return_code OUT NOCOPY VARCHAR2
65 );
66
67 procedure update_rank
68 (
69 p_auctionHeaderId IN NUMBER,
70 p_bidNumber IN NUMBER,
71 p_lineNumber IN NUMBER,
72 p_scoring_method IN VARCHAR2,
73 p_auction_type IN VARCHAR2,
74 p_oldRank IN NUMBER,
75 p_price IN NUMBER,
76 p_score IN NUMBER,
77 p_proxy IN VARCHAR2,
78 p_date IN DATE
79 );
80
81 PROCEDURE update_auction_info_disqualify
82 ( p_auctionHeaderId IN NUMBER,
83 p_bidNumber IN NUMBER
84 -- fph,
85 -- p_oex_operation IN VARCHAR2,
86 -- p_oex_operation_url IN VARCHAR2
87 );
88
89
90 PROCEDURE get_auc_header_id_orig_round
91 ( p_auctionHeaderId IN NUMBER,
92 p_auctionHeaderIdOrigRound OUT NOCOPY NUMBER
93 );
94
95
96 FUNCTION get_bid_break_price(p_bid_number IN NUMBER,
97 p_line_number IN NUMBER,
98 p_ship_to_org IN NUMBER,
99 p_ship_to_loc IN NUMBER,
100 p_quantity IN NUMBER,
101 p_need_by_date IN DATE)
102 RETURN NUMBER;
103
104
105 FUNCTION get_bid_break_price_with_pe(p_bid_number IN NUMBER,
106 p_line_number IN NUMBER,
107 p_ship_to_org IN NUMBER,
108 p_ship_to_loc IN NUMBER,
109 p_quantity IN NUMBER,
110 p_need_by_date IN DATE)
111 RETURN NUMBER;
112
113
114 FUNCTION GET_FND_USER_ID (p_person_party_id IN NUMBER) RETURN NUMBER;
115
116 FUNCTION get_most_recent_bid_number(x_auction_header_id IN NUMBER,
117 x_trading_partner_id IN NUMBER,
118 x_trading_partner_contact_id IN NUMBER)
119 RETURN NUMBER;
120
121 FUNCTION is_better_proxy_price(x_price1 IN NUMBER,
122 x_bidNumber IN NUMBER,
123 x_proxy1 IN VARCHAR2,
124 x_date1 IN DATE,
125 x_price2 IN NUMBER,
126 x_triggerNumber IN NUMBER,
127 x_date2 IN DATE)
128 RETURN VARCHAR2;
129 PRAGMA RESTRICT_REFERENCES(is_better_proxy_price, WNDS);
130 --
131 FUNCTION is_better_proxy_price_by_score(x_price1 IN NUMBER,
132 x_score1 IN NUMBER,
133 x_proxy1 IN VARCHAR2,
134 x_bidNumber IN NUMBER,
135 x_date1 IN DATE,
136 x_price2 IN NUMBER,
137 x_score2 IN NUMBER,
138 x_triggerNumber IN NUMBER,
139 x_date2 IN DATE)
140 RETURN VARCHAR2;
141 PRAGMA RESTRICT_REFERENCES(is_better_proxy_price_by_score, WNDS);
142
143 FUNCTION apply_price_factors(p_auction_header_id IN NUMBER,
144 p_line_number IN NUMBER,
145 p_bid_number IN NUMBER,
146 p_price IN NUMBER,
147 p_bid_quantity IN NUMBER,
148 p_trading_partner_id IN NUMBER,
149 p_vendor_site_id IN NUMBER,
150 p_rate IN NUMBER,
151 p_price_precision IN NUMBER,
152 p_currency_precision IN NUMBER,
153 p_entity_level IN VARCHAR2)
154 RETURN NUMBER;
155
156 PROCEDURE recover_prev_amend_draft (
157 p_auction_header_id_orig_amend IN NUMBER,
158 p_trading_partner_id IN NUMBER,
159 p_trading_partner_contact_id IN NUMBER,
160 p_vendor_site_id IN NUMBER,
161 p_login_user_id IN NUMBER
162 );
163
164 PROCEDURE set_buyer_bid_total
165 (p_auction_header_id IN NUMBER,
166 p_bid_number IN NUMBER);
167
168
169
170 FUNCTION new_best_price (x_auction_type IN VARCHAR2,
171 x_current_price IN NUMBER,
172 x_current_limit_price IN NUMBER,
173 x_best_bid_price IN NUMBER,
174 x_best_bid_limit_price IN NUMBER)
175 RETURN VARCHAR2;
176
177 FUNCTION new_best_mas_price( p_auction_type IN VARCHAR2
178 , p_current_price IN NUMBER
179 , p_total_weighted_score IN NUMBER
180 , p_current_limit_price IN NUMBER
181 , p_best_bid_bid_price IN NUMBER
182 , p_best_bid_score IN NUMBER
183 , p_best_bid_limit_price IN NUMBER
184 )
185 RETURN VARCHAR2;
186
187 FUNCTION APPLY_PRICE_FACTORS(
188 p_auction_header_id IN NUMBER,
189 p_prev_auc_active_bid_number IN NUMBER,
190 p_line_number IN NUMBER,
191 p_contract_type IN VARCHAR2,
192 p_supplier_view_type IN VARCHAR2,
193 p_pf_type_allowed IN VARCHAR2,
194 p_reverse_transform_flag IN VARCHAR2
195 )
196 RETURN NUMBER;
197
198 PROCEDURE update_auction_info_tech_short (
199 x_result OUT NOCOPY VARCHAR2,
200 x_error_code OUT NOCOPY VARCHAR2,
201 x_error_msg OUT NOCOPY VARCHAR2,
202 p_auction_header_id IN NUMBER,
203 p_user_id IN NUMBER
204 );
205
206 END PON_AUCTION_HEADERS_PKG;