[Home] [Help]
12840: END IF;
12841:
12842: -- Copy the scoring teams. Generate a new id for the new team
12843:
12844: INSERT INTO pon_scoring_teams
12845: (
12846: auction_header_id
12847: ,team_id
12848: ,team_name
12856: ,instruction_text
12857: )
12858: SELECT
12859: p_auction_header_id
12860: ,pon_scoring_teams_s.nextval
12861: ,old_team.team_name
12862: ,old_team.price_visible_flag
12863: ,SYSDATE -- creation_date
12864: ,p_user_id -- created_by
12867: ,fnd_global.login_id -- last_update_login
12868: ,old_team.team_id -- orig_team_id
12869: ,old_team.instruction_text
12870: FROM
12871: pon_scoring_teams old_team
12872: WHERE old_team.auction_header_id = p_source_auction_header_id;
12873:
12874:
12875: -- Create the team members. Do not insert any team members who are not
12898: ,p_user_id -- last_updated_by
12899: ,fnd_global.login_id -- last_update_login
12900: FROM
12901: pon_scoring_team_members old_members,
12902: pon_scoring_teams old_team,
12903: pon_scoring_teams new_team,
12904: pon_neg_team_members new_collab
12905: WHERE
12906: new_team.auction_header_id = p_auction_header_id
12899: ,fnd_global.login_id -- last_update_login
12900: FROM
12901: pon_scoring_team_members old_members,
12902: pon_scoring_teams old_team,
12903: pon_scoring_teams new_team,
12904: pon_neg_team_members new_collab
12905: WHERE
12906: new_team.auction_header_id = p_auction_header_id
12907: AND old_team.team_id = new_team.orig_team_id
12935: ,fnd_global.login_id -- last_update_login
12936: FROM
12937: pon_auction_sections new_sections
12938: ,pon_scoring_team_sections old_team_sections
12939: ,pon_scoring_teams new_team
12940: WHERE
12941: new_sections.auction_header_id = p_auction_header_id
12942: AND old_team_sections.section_id = new_sections.previous_section_id
12943: AND new_team.orig_team_id = old_team_sections.team_id