DBA Data[Home] [Help]

APPS.ZPB_AC_OPS dependencies on ZPB_SOLVE_ALLOCATION_DEFS

Line 801: INSERT INTO zpb_solve_allocation_defs

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,

Line 832: FROM zpb_solve_allocation_defs

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;

Line 1189: DELETE FROM zpb_solve_allocation_defs

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;