1 PACKAGE PON_TEAM_SCORING_UTIL_PVT AUTHID CURRENT_USER AS
2 /*$Header: PONVSTUS.pls 120.2 2005/10/13 14:06:28 sahegde noship $*/
3
4
5 --------------------------------------------------------------------------------
6 -- Lock_Scoring --
7 --------------------------------------------------------------------------------
8 -- Start of Comments
9 --
10 -- API Name: lock_scoring
11 --
12 -- Type: Private
13 --
14 -- Pre-reqs: None
15 --
16 -- Function: This procedure performs following 2 functions
17 -- 1. Record the supplied auction as locked for scoring
18 -- 2. Calculate the average of scored attributes and insert into
19 -- PON_BID_ATTRIBUTE_VALUES
20 --
21 --
22 -- IN Parameters:
23 -- p_api_version NUMBER
24 -- p_auction_header_id pon_auction_headers_all%auction_header_id%TYPE
25 -- p_tpc_id pon_auction_headers_all%trading_partner_contact_id
26 --
27 -- OUT Parameters
28 --
29 --
30 -- x_return_status OUT NOCOPY VARCHAR2
31 -- U - Unexpected Error/ S-success
32 -- x_msg_data OUT NOCOPY VARCHAR2
33 -- x_msg_count OUT NOCOPY NUMBER
34 --
35 -- RETURNS: None
36 --
37 -- End of Comments
38 --------------------------------------------------------------------------------
39
40 PROCEDURE lock_scoring(
41 p_api_version IN NUMBER
42 ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE
43 ,p_tpc_id IN pon_auction_headers_all.trading_partner_contact_id%TYPE
44 ,x_return_status OUT NOCOPY VARCHAR2
45 ,x_msg_data OUT NOCOPY VARCHAR2
46 ,x_msg_count OUT NOCOPY NUMBER
47 );
48
49
50
51 --------------------------------------------------------------------------------
52 -- delete_member_scores --
53 --------------------------------------------------------------------------------
54 -- Start of Comments
55 --
56 -- API Name: delete_member_scores
57 --
58 -- Type: Private
59 --
60 -- Pre-reqs: None
61 --
62 -- Function: This procedure deletes the scores entered by a member on
63 -- a particular auction. Scores on all bids will be deleted.
64 -- Its likely that user may not have entered any scores on
65 -- this auction and therefore the table pon_team_member_attr_scores
66 -- does not have any rows for supplied auction header and the user.
67 --
68 --
69 -- IN Parameters:
70 -- p_api_version NUMBER
71 -- p_auction_header_id pon_auction_headers_all.auction_header_id%TYPE
72 -- p_team_id pon_scoring_teams.team_id%TYPE
73 -- p_user_id fnd_user.user_id%TYPE
74 --
75 -- OUT Parameters
76 --
77 --
78 -- x_return_status OUT NOCOPY VARCHAR2
79 -- U - Unexpected Error/ S-success
80 -- x_msg_data OUT NOCOPY VARCHAR2
81 -- x_msg_count OUT NOCOPY NUMBER
82 --
83 -- RETURNS: None
84 --
85 -- End of Comments
86 --------------------------------------------------------------------------------
87
88 PROCEDURE delete_member_scores(
89 p_api_version IN NUMBER
90 ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE
91 ,p_team_id IN pon_scoring_teams.team_id%TYPE
92 ,p_user_id IN fnd_user.user_id%TYPE
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_data OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 );
97
98
99 --------------------------------------------------------------------------------
100 -- delete_team_scores --
101 --------------------------------------------------------------------------------
102 -- Start of Comments
103 --
104 -- API Name: delete_team_scores
105 --
106 -- Type: Private
107 --
108 -- Pre-reqs: None
109 --
110 -- Function: This procedure deletes the scores entered by members on
111 -- a team for a particular auction. Scores on all bids will be deleted.
112 -- Its likely that users may not have entered any scores on
113 -- this auction and therefore the table pon_team_member_attr_scores
114 -- does not have any rows for supplied auction header and the team.
115 --
116 --
117 -- IN Parameters:
118 -- p_api_version NUMBER
119 -- p_auction_header_id pon_auction_headers_all.auction_header_id%TYPE
120 -- p_team_id pon_scoring_teams.team_id%TYPE
121 --
122 -- OUT Parameters
123 --
124 --
125 -- x_return_status OUT NOCOPY VARCHAR2
126 -- U - Unexpected Error/ S-success
127 -- x_msg_data OUT NOCOPY VARCHAR2
128 -- x_msg_count OUT NOCOPY NUMBER
129 --
130 -- RETURNS: None
131 --
132 -- End of Comments
133 --------------------------------------------------------------------------------
134
135 PROCEDURE delete_team_scores(
136 p_api_version IN NUMBER
137 ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE
138 ,p_team_id IN pon_scoring_teams.team_id%TYPE
139 ,x_return_status OUT NOCOPY VARCHAR2
140 ,x_msg_data OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 );
143
144 --------------------------------------------------------------------------------
145 -- delete_subjective_scores --
146 --------------------------------------------------------------------------------
147 -- Start of Comments
148 --
149 -- API Name: delete_subjective_scores
150 --
151 -- Type: Private
152 --
153 -- Pre-reqs: None
154 --
155 -- Function: This procedures deletes all subjective scores entered for an auction
156 -- from the pon_bid_attribute_values. This method will be called only
157 -- after user confirms the deletion of the scores. This method will be
158 -- called for those auctions that are subjectively scored but not 'Team Scored'
159 -- and are enabled for team scoring midway. Scores for all bids will be
160 -- deleted. Only manually scores attributes will be deleted.
161 --
162 --
163 -- IN Parameters:
164 -- p_api_version NUMBER
165 -- p_auction_header_id pon_auction_headers_all.auction_header_id%TYPE
166 --
167 -- OUT Parameters
168 --
169 --
170 -- x_return_status OUT NOCOPY VARCHAR2
171 -- U - Unexpected Error/ S-success
172 -- x_msg_data OUT NOCOPY VARCHAR2
173 -- x_msg_count OUT NOCOPY NUMBER
174 --
175 -- RETURNS: None
176 --
177 -- End of Comments
178 --------------------------------------------------------------------------------
179
180 PROCEDURE delete_subjective_scores(
181 p_api_version IN NUMBER
182 ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE
183 ,x_return_status OUT NOCOPY VARCHAR2
184 ,x_msg_data OUT NOCOPY VARCHAR2
185 ,x_msg_count OUT NOCOPY NUMBER
186 );
187
188 --------------------------------------------------------------------------------
189 -- delete_section_assignment --
190 --------------------------------------------------------------------------------
191 -- Start of Comments
192 --
193 -- API Name: delete_section_assignment
194 --
195 -- Type: Private
196 --
197 -- Pre-reqs: None
198 --
199 -- Function: This procedure deletes the section assignement from the
200 -- pon_scoring_team_sections on section deletion during either create or manage
201 -- flow.
202 --
203 --
204 -- IN Parameters:
205 -- p_api_version NUMBER
206 -- p_auction_header_id pon_auction_headers_all.auction_header_id%TYPE
207 -- p_section_id pon_auction_headers_all.section_id%TYPE
208 --
209 -- OUT Parameters
210 --
211 --
212 -- x_return_status OUT NOCOPY VARCHAR2
213 -- U - Unexpected Error/ S-success
214 -- x_msg_data OUT NOCOPY VARCHAR2
215 -- x_msg_count OUT NOCOPY NUMBER
216 --
217 -- RETURNS: None
218 --
219 -- End of Comments
220 --------------------------------------------------------------------------------
221
222 PROCEDURE delete_section_assignment(
223 p_api_version IN NUMBER
224 ,p_auction_header_id IN pon_scoring_team_sections.auction_header_id%TYPE
225 ,p_section_id IN pon_scoring_team_sections.section_id%TYPE
226 ,x_return_status OUT NOCOPY VARCHAR2
227 ,x_msg_data OUT NOCOPY VARCHAR2
228 ,x_msg_count OUT NOCOPY NUMBER
229 );
230
231 --------------------------------------------------------------------------------
232 -- Unlock_Scoring --
233 --------------------------------------------------------------------------------
234 -- Start of Comments
235 --
236 -- API Name: unlock_scoring
237 --
238 -- Type: Private
239 --
240 -- Pre-reqs: None
241 --
242 -- Function: This procedure performs following 3 functions
243 -- 1. Record the supplied auction as unlocked or open for scoring
244 -- 2. Update score and internal note to null on the manually scored attributes
245 -- for the supplied auction header id in PON_BID_ATTRIBUTE_VALUES
246 -- 3. Erases score override information from the PON_BID_HEADERS
247 --
248 -- IN Parameters:
249 -- p_api_version NUMBER
250 -- p_auction_header_id pon_auction_headers_all%auction_header_id%TYPE
251 -- p_tpc_id pon_auction_headers_all%trading_partner_contact_id
252 --
253 -- OUT Parameters
254 --
255 --
256 -- x_return_status OUT NOCOPY VARCHAR2
257 -- U - Unexpected Error/ S-success
258 -- x_msg_data OUT NOCOPY VARCHAR2
259 -- x_msg_count OUT NOCOPY NUMBER
260 --
261 -- RETURNS: None
262 --
263 -- End of Comments
264 --------------------------------------------------------------------------------
265
266 PROCEDURE unlock_scoring(
267 p_api_version IN NUMBER
268 ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE
269 ,p_tpc_id IN pon_auction_headers_all.trading_partner_contact_id%TYPE
270 ,x_return_status OUT NOCOPY VARCHAR2
271 ,x_msg_data OUT NOCOPY VARCHAR2
272 ,x_msg_count OUT NOCOPY NUMBER
273 );
274
275
276 END PON_TEAM_SCORING_UTIL_PVT;