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: --
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: --
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
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: );
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
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
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: --
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
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: --
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: );
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: --
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: --
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: --
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: --
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
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: );