[Home] [Help]
797: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
798: IS
799: BEGIN
800:
801: INSERT INTO zpb_solve_allocation_defs
802: (ANALYSIS_CYCLE_ID,
803: MEMBER,
804: MEMBER_ORDER,
805: RULE_NAME,
828: SYSDATE,
829: fnd_global.USER_ID,
830: SYSDATE,
831: fnd_global.LOGIN_ID
832: FROM zpb_solve_allocation_defs
833: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
834:
835:
836: END copy_solve_alloc_defs_recs;
1185:
1186: DELETE FROM zpb_solve_output_levels
1187: WHERE analysis_cycle_id = ac_id_in;
1188:
1189: DELETE FROM zpb_solve_allocation_defs
1190: WHERE analysis_cycle_id = ac_id_in;
1191:
1192: DELETE FROM zpb_solve_output_selections
1193: WHERE analysis_cycle_id = ac_id_in;