[Home] [Help]
13178: END IF;
13179:
13180: -- Copy the evaluation teams. Generate a new id for the new team
13181:
13182: INSERT INTO pon_evaluation_teams
13183: (
13184: auction_header_id,
13185: team_id,
13186: team_name,
13192: last_updated_by,
13193: last_update_login
13194: )
13195: SELECT p_auction_header_id,
13196: pon_evaluation_teams_s.nextval,
13197: old_team.team_name,
13198: old_team.team_id,
13199: old_team.instruction_text,
13200: SYSDATE,
13201: p_user_id,
13202: SYSDATE,
13203: p_user_id,
13204: fnd_global.login_id
13205: FROM pon_evaluation_teams old_team
13206: WHERE old_team.auction_header_id = p_source_auction_header_id;
13207:
13208: -- Create the team members. Do not insert any team members who are not
13209: -- valid. The team members who are not valid would not have been
13229: SYSDATE,
13230: p_user_id,
13231: fnd_global.login_id
13232: FROM pon_evaluation_team_members old_members,
13233: pon_evaluation_teams old_team,
13234: pon_evaluation_teams new_team,
13235: pon_neg_team_members new_collab
13236: WHERE new_team.auction_header_id = p_auction_header_id
13237: AND old_team.team_id = new_team.orig_team_id
13230: p_user_id,
13231: fnd_global.login_id
13232: FROM pon_evaluation_team_members old_members,
13233: pon_evaluation_teams old_team,
13234: pon_evaluation_teams new_team,
13235: pon_neg_team_members new_collab
13236: WHERE new_team.auction_header_id = p_auction_header_id
13237: AND old_team.team_id = new_team.orig_team_id
13238: AND old_members.team_id = old_team.team_id
13262: p_user_id,
13263: fnd_global.login_id
13264: FROM pon_auction_sections new_sections,
13265: pon_evaluation_team_sections old_team_sections,
13266: pon_evaluation_teams new_team
13267: WHERE new_sections.auction_header_id = p_auction_header_id
13268: AND old_team_sections.section_id = new_sections.previous_section_id
13269: AND new_team.orig_team_id = old_team_sections.team_id
13270: AND new_team.auction_header_id = new_sections.auction_header_id;