256: -- Bug 4036563 .
257: --
258:
259: PROCEDURE populate_SVDEFVAR
260: (p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE)
261: is
262: CURSOR records_cur IS
263: SELECT model_equation,calc_parameters,member
264: FROM zpb_solve_member_defs
260: (p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE)
261: is
262: CURSOR records_cur IS
263: SELECT model_equation,calc_parameters,member
264: FROM zpb_solve_member_defs
265: WHERE analysis_cycle_id = p_ac_id
266: and source_type = 1200;
267:
268: l_modelEquation ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
264: FROM zpb_solve_member_defs
265: WHERE analysis_cycle_id = p_ac_id
266: and source_type = 1200;
267:
268: l_modelEquation ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
269: l_calcParam ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
270: l_modelEquationres ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
271: l_calcParamres ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
272: offset number := 1;
265: WHERE analysis_cycle_id = p_ac_id
266: and source_type = 1200;
267:
268: l_modelEquation ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
269: l_calcParam ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
270: l_modelEquationres ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
271: l_calcParamres ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
272: offset number := 1;
273: opRec zpb_solve_member_defs%ROWTYPE;
266: and source_type = 1200;
267:
268: l_modelEquation ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
269: l_calcParam ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
270: l_modelEquationres ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
271: l_calcParamres ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
272: offset number := 1;
273: opRec zpb_solve_member_defs%ROWTYPE;
274: i number;
267:
268: l_modelEquation ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
269: l_calcParam ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
270: l_modelEquationres ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
271: l_calcParamres ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
272: offset number := 1;
273: opRec zpb_solve_member_defs%ROWTYPE;
274: i number;
275: indx number;
269: l_calcParam ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
270: l_modelEquationres ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
271: l_calcParamres ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
272: offset number := 1;
273: opRec zpb_solve_member_defs%ROWTYPE;
274: i number;
275: indx number;
276: begin
277: ZPB_AW.execute('push SV.LN.DIM');