[Home] [Help]
4748: --{
4749: --
4750: -- Cross Copy Logic For Section
4751: --
4752: insert into pon_auction_sections
4753: ( AUCTION_HEADER_ID,
4754: LINE_NUMBER,
4755: ATTRIBUTE_LIST_ID,
4756: SECTION_ID,
4766: select
4767: p_auction_header_id,
4768: LINE_NUMBER,
4769: ATTRIBUTE_LIST_ID,
4770: PON_AUCTION_SECTIONS_S.NEXTVAL,
4771: -- Team Scoring
4772: -- Commenting the following line to allow copying of sections
4773: -- even in case of cross copy or draft copy as previous section
4774: -- id is needed while copying team assignments on the new document
4782: SYSDATE,
4783: p_user_id,
4784: p_user_id,
4785: DECODE(p_doctype_id, g_rfq_doctype_id, TWO_PART_SECTION_TYPE, g_sol_doctype_id, TWO_PART_SECTION_TYPE, NULL)
4786: FROM PON_AUCTION_SECTIONS
4787: WHERE AUCTION_HEADER_ID = p_source_auction_header_id;
4788: --}
4789:
4790: END;
12933: ,SYSDATE -- last_update_date
12934: ,p_user_id -- last_updated_by
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
13260: p_user_id,
13261: SYSDATE,
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
13366: MULTI_ROW_CODE,
13367: DECODE( B.SECTION_ID, NULL, NULL,
13368: -10000, -10000,
13369: ( SELECT SECTION_ID
13370: FROM PON_AUCTION_SECTIONS S
13371: WHERE S.PREVIOUS_SECTION_ID = B.SECTION_ID
13372: AND S.AUCTION_HEADER_ID = p_auction_header_id) )
13373: FROM PON_AUCTION_ATTR_MAPPING_B B
13374: WHERE AUCTION_HEADER_ID = p_source_auction_header_id