DBA Data[Home] [Help]

APPS.ZPB_UTIL_PVT dependencies on ZPB_SOLVE_MEMBER_DEFS

Line 260: (p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE)

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

Line 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;

Line 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;

Line 269: l_calcParam ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;

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;

Line 270: l_modelEquationres ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;

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;

Line 271: l_calcParamres ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;

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;

Line 273: opRec zpb_solve_member_defs%ROWTYPE;

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');