DBA Data[Home] [Help]

APPS.PON_TEAM_SCORING_UTIL_PVT dependencies on PON_AUCTION_HEADERS_ALL

Line 24: -- p_auction_header_id pon_auction_headers_all%auction_header_id%TYPE

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

Line 25: -- p_tpc_id pon_auction_headers_all%trading_partner_contact_id

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

Line 42: ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE

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

Line 43: ,p_tpc_id IN pon_auction_headers_all.trading_partner_contact_id%TYPE

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

Line 71: -- p_auction_header_id pon_auction_headers_all.auction_header_id%TYPE

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

Line 90: ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE

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

Line 119: -- p_auction_header_id pon_auction_headers_all.auction_header_id%TYPE

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

Line 137: ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE

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

Line 165: -- p_auction_header_id pon_auction_headers_all.auction_header_id%TYPE

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

Line 182: ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE

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

Line 206: -- p_auction_header_id pon_auction_headers_all.auction_header_id%TYPE

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

Line 207: -- p_section_id pon_auction_headers_all.section_id%TYPE

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

Line 250: -- p_auction_header_id pon_auction_headers_all%auction_header_id%TYPE

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

Line 251: -- p_tpc_id pon_auction_headers_all%trading_partner_contact_id

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

Line 268: ,p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE

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

Line 269: ,p_tpc_id IN pon_auction_headers_all.trading_partner_contact_id%TYPE

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