[Home] [Help]
11397: END IF;
11398:
11399: -- Copy the scoring teams. Generate a new id for the new team
11400:
11401: INSERT INTO pon_scoring_teams
11402: (
11403: auction_header_id
11404: ,team_id
11405: ,team_name
11413: ,instruction_text
11414: )
11415: SELECT
11416: p_auction_header_id
11417: ,pon_scoring_teams_s.nextval
11418: ,old_team.team_name
11419: ,old_team.price_visible_flag
11420: ,SYSDATE -- creation_date
11421: ,p_user_id -- created_by
11424: ,fnd_global.login_id -- last_update_login
11425: ,old_team.team_id -- orig_team_id
11426: ,old_team.instruction_text
11427: FROM
11428: pon_scoring_teams old_team
11429: WHERE old_team.auction_header_id = p_source_auction_header_id;
11430:
11431:
11432: -- Create the team members. Do not insert any team members who are not
11455: ,p_user_id -- last_updated_by
11456: ,fnd_global.login_id -- last_update_login
11457: FROM
11458: pon_scoring_team_members old_members,
11459: pon_scoring_teams old_team,
11460: pon_scoring_teams new_team,
11461: pon_neg_team_members new_collab
11462: WHERE
11463: new_team.auction_header_id = p_auction_header_id
11456: ,fnd_global.login_id -- last_update_login
11457: FROM
11458: pon_scoring_team_members old_members,
11459: pon_scoring_teams old_team,
11460: pon_scoring_teams new_team,
11461: pon_neg_team_members new_collab
11462: WHERE
11463: new_team.auction_header_id = p_auction_header_id
11464: AND old_team.team_id = new_team.orig_team_id
11492: ,fnd_global.login_id -- last_update_login
11493: FROM
11494: pon_auction_sections new_sections
11495: ,pon_scoring_team_sections old_team_sections
11496: ,pon_scoring_teams new_team
11497: WHERE
11498: new_sections.auction_header_id = p_auction_header_id
11499: AND old_team_sections.section_id = new_sections.previous_section_id
11500: AND new_team.orig_team_id = old_team_sections.team_id