717: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
718: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
719: IS
720: BEGIN
721: INSERT INTO zpb_solve_input_selections
722: (ANALYSIS_CYCLE_ID,
723: MEMBER,
724: MEMBER_ORDER,
725: DIMENSION,
744: SYSDATE,
745: fnd_global.USER_ID,
746: SYSDATE,
747: fnd_global.LOGIN_ID
748: FROM zpb_solve_input_selections
749: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
750:
751: END copy_solve_input_level_recs;
752:
1191:
1192: DELETE FROM zpb_solve_output_selections
1193: WHERE analysis_cycle_id = ac_id_in;
1194:
1195: DELETE FROM zpb_solve_input_selections
1196: WHERE analysis_cycle_id = ac_id_in;
1197:
1198: DELETE FROM zpb_line_dimensionality
1199: WHERE analysis_cycle_id = ac_id_in;