APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on PON_MNG_EVAL_TEAM_MEMBERS

Line 34: DELETE FROM pon_mng_eval_team_members

30: PROCEDURE init_mng_eval_teams(p_auction_header_id IN NUMBER)
31: IS
32: BEGIN
33:
34: DELETE FROM pon_mng_eval_team_members
35: WHERE auction_header_id = p_auction_header_id;
36:
37: DELETE FROM pon_mng_eval_team_sections
38: WHERE auction_header_id = p_auction_header_id;

Line 41: INSERT INTO pon_mng_eval_team_members

37: DELETE FROM pon_mng_eval_team_sections
38: WHERE auction_header_id = p_auction_header_id;
39:
40:
41: INSERT INTO pon_mng_eval_team_members
42: (
43: auction_header_id,
44: team_id,
45: user_id,

Line 107: FROM pon_mng_eval_team_members pmetm,

103:
104: MERGE INTO pon_mng_eval_bid_sections pmebs
105: USING (SELECT pbh.bid_number,
106: pmets.section_id
107: FROM pon_mng_eval_team_members pmetm,
108: pon_mng_eval_team_sections pmets,
109: pon_bid_headers pbh,
110: fnd_user fu
111: WHERE pmetm.auction_header_id = p_auction_header_id

Line 174: FROM pon_mng_eval_team_members pmetm,

170: AND petm.team_id = pets.team_id
171: AND (petm.user_id, pets.section_id) NOT IN
172: (SELECT pmetm.user_id,
173: pmets.section_id
174: FROM pon_mng_eval_team_members pmetm,
175: pon_mng_eval_team_sections pmets
176: WHERE pmetm.auction_header_id = p_auction_header_id
177: AND pmets.auction_header_id = p_auction_header_id
178: AND pmetm.team_id = pmets.team_id

Line 217: UPDATE pon_mng_eval_team_members

213:
214:
215: -- 3. Track changes in team members
216:
217: UPDATE pon_mng_eval_team_members
218: SET status_code = 'D'
219: WHERE auction_header_id = p_auction_header_id
220: AND (team_id, user_id) NOT IN
221: (SELECT team_id,

Line 227: INSERT INTO pon_mng_eval_team_members

223: FROM pon_evaluation_team_members
224: WHERE auction_header_id = p_auction_header_id
225: );
226:
227: INSERT INTO pon_mng_eval_team_members
228: (
229: auction_header_id,
230: team_id,
231: user_id,

Line 253: FROM pon_mng_eval_team_members

249: WHERE auction_header_id = p_auction_header_id
250: AND (team_id, user_id) NOT IN
251: (SELECT team_id,
252: user_id
253: FROM pon_mng_eval_team_members
254: WHERE auction_header_id = p_auction_header_id
255: );
256:
257:

Line 352: FROM pon_mng_eval_team_members pmetm,

348: SELECT user_id
349: FROM pon_neg_team_members
350: WHERE auction_header_id = p_auction_header_id
351: AND (user_id IN (SELECT pmetm.user_id
352: FROM pon_mng_eval_team_members pmetm,
353: pon_mng_eval_team_sections pmets
354: WHERE pmetm.auction_header_id = p_auction_header_id
355: AND pmets.auction_header_id = p_auction_header_id
356: AND pmets.team_id = pmetm.team_id

Line 547: FROM pon_mng_eval_team_members pmetm,

543: SELECT pmetm.user_id,
544: pmets.team_name,
545: pas.section_name,
546: pmetm.status_code
547: FROM pon_mng_eval_team_members pmetm,
548: pon_mng_eval_team_sections pmets,
549: pon_auction_sections pas
550: WHERE pmetm.auction_header_id = p_auction_header_id
551: AND pmets.auction_header_id = p_auction_header_id

Line 573: FROM pon_mng_eval_team_members pmetm,

569: IS
570: SELECT pmets.team_name,
571: pas.section_name,
572: pmets.status_code
573: FROM pon_mng_eval_team_members pmetm,
574: pon_mng_eval_team_sections pmets,
575: pon_auction_sections pas
576: WHERE pmetm.auction_header_id = p_auction_header_id
577: AND pmets.auction_header_id = p_auction_header_id