DBA Data[Home] [Help]

APPS.ZPB_AC_OPS dependencies on ZPB_SOLVE_INPUT_SELECTIONS

Line 721: INSERT INTO zpb_solve_input_selections

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,

Line 748: FROM zpb_solve_input_selections

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:

Line 1195: DELETE FROM zpb_solve_input_selections

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;