[Home] [Help]
637: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
638: IS
639: BEGIN
640:
641: INSERT INTO zpb_copy_dim_members
642: (DIM,
643: ANALYSIS_CYCLE_ID,
644: SOURCE_NUM_MEMBERS,
645: TARGET_NUM_MEMBERS,
660: SYSDATE,
661: fnd_global.LOGIN_ID,
662: SAME_SELECTION,
663: LINE_MEMBER_ID
664: FROM zpb_copy_dim_members
665: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
666:
667: END copy_copy_dim_members_recs;
668:
1151:
1152: DELETE FROM zpb_business_process_scope
1153: WHERE analysis_cycle_id = ac_id_in;
1154:
1155: DELETE FROM zpb_copy_dim_members
1156: WHERE analysis_cycle_id = ac_id_in;
1157:
1158: DELETE FROM zpb_measure_scope_exempt_users
1159: WHERE BUSINESS_PROCESS_ENTITY_ID = ac_id_in