APPS.ZPB_SOLVE dependencies on ZPB_SOLVE_ALLOCATION_DEFS

Line 773: DELETE FROM ZPB_SOLVE_ALLOCATION_DEFS

769: IS
770: BEGIN
771: --delete existing rows
772: FORALL i IN propagateList.FIRST..propagateList.LAST
773: DELETE FROM ZPB_SOLVE_ALLOCATION_DEFS
774: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
775: --add new rows
776: FORALL i IN propagateList.FIRST..propagateList.LAST
777: INSERT INTO ZPB_SOLVE_ALLOCATION_DEFS

Line 777: INSERT INTO ZPB_SOLVE_ALLOCATION_DEFS

773: DELETE FROM ZPB_SOLVE_ALLOCATION_DEFS
774: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
775: --add new rows
776: FORALL i IN propagateList.FIRST..propagateList.LAST
777: INSERT INTO ZPB_SOLVE_ALLOCATION_DEFS
778: (ANALYSIS_CYCLE_ID,
779: MEMBER,
780: MEMBER_ORDER,
781: RULE_NAME,

Line 798: FROM ZPB_SOLVE_ALLOCATION_DEFS

794: METHOD, EVALUATION_OPTION, ROUND_DECIMALS, ROUND_ENABLED,
795: BASIS, QUALIFIER, fnd_global.USER_ID, SYSDATE,
796:
797: fnd_global.USER_ID, SYSDATE, fnd_global.LOGIN_ID
798: FROM ZPB_SOLVE_ALLOCATION_DEFS
799: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
800: END propagateAlloc;
801:
802: