eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_SOLVE dependencies on ZPB_SOLVE

Line 1: PACKAGE BODY ZPB_SOLVE AS

1: PACKAGE BODY ZPB_SOLVE AS
2: /* $Header: zpbsolve.plb 120.14 2007/12/05 12:51:14 mbhat ship $ */
3:
4: /*****************************************************************
5: * PROPAGATE INPUT SELECTIONS *

Line 10: PROCEDURE propagateInput(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

6: * *
7: * *
8: * *
9: ****************************************************************/
10: PROCEDURE propagateInput(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
11: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
12:
13: IS
14: fromSource NUMBER;

Line 11: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)

7: * *
8: * *
9: ****************************************************************/
10: PROCEDURE propagateInput(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
11: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
12:
13: IS
14: fromSource NUMBER;
15: ipRec ZPB_SOLVE_INPUT_SELECTIONS%ROWTYPE;

Line 15: ipRec ZPB_SOLVE_INPUT_SELECTIONS%ROWTYPE;

11: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
12:
13: IS
14: fromSource NUMBER;
15: ipRec ZPB_SOLVE_INPUT_SELECTIONS%ROWTYPE;
16: isSetSrcPropFlag boolean := FALSE;
17:
18: CURSOR c1 IS
19: SELECT * FROM ZPB_SOLVE_INPUT_SELECTIONS

Line 19: SELECT * FROM ZPB_SOLVE_INPUT_SELECTIONS

15: ipRec ZPB_SOLVE_INPUT_SELECTIONS%ROWTYPE;
16: isSetSrcPropFlag boolean := FALSE;
17:
18: CURSOR c1 IS
19: SELECT * FROM ZPB_SOLVE_INPUT_SELECTIONS
20: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
21: BEGIN
22: SELECT SOURCE_TYPE INTO fromSource
23: FROM ZPB_SOLVE_MEMBER_DEFS

Line 23: FROM ZPB_SOLVE_MEMBER_DEFS

19: SELECT * FROM ZPB_SOLVE_INPUT_SELECTIONS
20: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
21: BEGIN
22: SELECT SOURCE_TYPE INTO fromSource
23: FROM ZPB_SOLVE_MEMBER_DEFS
24: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
25:
26: IF(fromSource <> CALCULATED_SOURCE AND fromSource <> AGGREGATED_SOURCE) THEN
27: FOR i IN propagateList.FIRST..propagateList.LAST

Line 34: DELETE FROM ZPB_SOLVE_INPUT_SELECTIONS

30: (propagateSourceType(i) = LOADED_SOURCE AND fromSource = LOADED_SOURCE))THEN
31: isSetSrcPropFlag := TRUE;
32: --delete all i/p selections if target's source type is =INPUT
33: -- For CASES:C1-a,C1-b,C2-b
34: DELETE FROM ZPB_SOLVE_INPUT_SELECTIONS
35: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
36: --insert
37: ELSE
38: isSetSrcPropFlag := TRUE;

Line 39: DELETE ZPB_SOLVE_INPUT_SELECTIONS

35: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
36: --insert
37: ELSE
38: isSetSrcPropFlag := TRUE;
39: DELETE ZPB_SOLVE_INPUT_SELECTIONS
40: where member = propagateList(i)
41: and analysis_cycle_id = p_ac_id
42: and dimension in ( select dimension from zpb_solve_input_selections
43: where member = p_from_member

Line 42: and dimension in ( select dimension from zpb_solve_input_selections

38: isSetSrcPropFlag := TRUE;
39: DELETE ZPB_SOLVE_INPUT_SELECTIONS
40: where member = propagateList(i)
41: and analysis_cycle_id = p_ac_id
42: and dimension in ( select dimension from zpb_solve_input_selections
43: where member = p_from_member
44: and analysis_cycle_id = p_ac_id);
45:
46: END IF;

Line 47: INSERT INTO ZPB_SOLVE_INPUT_SELECTIONS

43: where member = p_from_member
44: and analysis_cycle_id = p_ac_id);
45:
46: END IF;
47: INSERT INTO ZPB_SOLVE_INPUT_SELECTIONS
48: (ANALYSIS_CYCLE_ID,
49: MEMBER,
50: MEMBER_ORDER,
51: DIMENSION,

Line 74: FROM ZPB_SOLVE_INPUT_SELECTIONS

70: SYSDATE,
71: fnd_global.USER_ID,
72: SYSDATE,
73: fnd_global.LOGIN_ID
74: FROM ZPB_SOLVE_INPUT_SELECTIONS
75: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
76:
77: END LOOP;
78: END IF;

Line 83: UPDATE ZPB_SOLVE_INPUT_SELECTIONS

79:
80: --Update PROPAGATED_FLAG of source member.
81: IF isSetSrcPropFlag = TRUE THEN
82:
83: UPDATE ZPB_SOLVE_INPUT_SELECTIONS
84: SET PROPAGATED_FLAG ='Y'
85: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
86: END IF;
87:

Line 105: PROCEDURE copyDimHandlingInfo(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

101: * COPY DIMENSION HANDLING INFO *
102: * *
103: * *
104: *****************************************************************/
105: PROCEDURE copyDimHandlingInfo(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
106: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
107: p_to_index IN INTEGER,
108: p_dimensionality_flag IN VARCHAR2 DEFAULT 'NO')
109: IS

Line 106: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,

102: * *
103: * *
104: *****************************************************************/
105: PROCEDURE copyDimHandlingInfo(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
106: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
107: p_to_index IN INTEGER,
108: p_dimensionality_flag IN VARCHAR2 DEFAULT 'NO')
109: IS
110:

Line 199: PROCEDURE copyInputSelections(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

195: * *
196: * *
197: *****************************************************************/
198:
199: PROCEDURE copyInputSelections(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
200: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
201: p_to_index IN INTEGER,
202: p_dimensionality_flag IN VARCHAR2 DEFAULT 'NO')
203: IS

Line 200: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,

196: * *
197: *****************************************************************/
198:
199: PROCEDURE copyInputSelections(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
200: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
201: p_to_index IN INTEGER,
202: p_dimensionality_flag IN VARCHAR2 DEFAULT 'NO')
203: IS
204: ipRec ZPB_SOLVE_INPUT_SELECTIONS%ROWTYPE;

Line 204: ipRec ZPB_SOLVE_INPUT_SELECTIONS%ROWTYPE;

200: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
201: p_to_index IN INTEGER,
202: p_dimensionality_flag IN VARCHAR2 DEFAULT 'NO')
203: IS
204: ipRec ZPB_SOLVE_INPUT_SELECTIONS%ROWTYPE;
205: CURSOR c1 IS
206:
207:
208: SELECT * FROM ZPB_SOLVE_INPUT_SELECTIONS

Line 208: SELECT * FROM ZPB_SOLVE_INPUT_SELECTIONS

204: ipRec ZPB_SOLVE_INPUT_SELECTIONS%ROWTYPE;
205: CURSOR c1 IS
206:
207:
208: SELECT * FROM ZPB_SOLVE_INPUT_SELECTIONS
209: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
210: BEGIN
211: --Update PROPAGATED_FLAG of source member.
212: UPDATE ZPB_SOLVE_INPUT_SELECTIONS

Line 212: UPDATE ZPB_SOLVE_INPUT_SELECTIONS

208: SELECT * FROM ZPB_SOLVE_INPUT_SELECTIONS
209: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
210: BEGIN
211: --Update PROPAGATED_FLAG of source member.
212: UPDATE ZPB_SOLVE_INPUT_SELECTIONS
213: SET PROPAGATED_FLAG ='Y'
214: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
215:
216: IF p_dimensionality_flag = 'RECREATE' THEN

Line 218: DELETE FROM ZPB_SOLVE_INPUT_SELECTIONS

214: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
215:
216: IF p_dimensionality_flag = 'RECREATE' THEN
217:
218: DELETE FROM ZPB_SOLVE_INPUT_SELECTIONS
219: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index);
220:
221:
222: INSERT INTO ZPB_SOLVE_INPUT_SELECTIONS

Line 222: INSERT INTO ZPB_SOLVE_INPUT_SELECTIONS

218: DELETE FROM ZPB_SOLVE_INPUT_SELECTIONS
219: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index);
220:
221:
222: INSERT INTO ZPB_SOLVE_INPUT_SELECTIONS
223: (ANALYSIS_CYCLE_ID,
224: MEMBER,
225: MEMBER_ORDER,
226: DIMENSION,

Line 250: FROM ZPB_SOLVE_INPUT_SELECTIONS

246: SYSDATE,
247: fnd_global.USER_ID,
248: SYSDATE,
249: fnd_global.LOGIN_ID
250: FROM ZPB_SOLVE_INPUT_SELECTIONS
251: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
252: ELSE
253: FOR ipRec IN c1 LOOP
254: UPDATE ZPB_SOLVE_INPUT_SELECTIONS

Line 254: UPDATE ZPB_SOLVE_INPUT_SELECTIONS

250: FROM ZPB_SOLVE_INPUT_SELECTIONS
251: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
252: ELSE
253: FOR ipRec IN c1 LOOP
254: UPDATE ZPB_SOLVE_INPUT_SELECTIONS
255: SET
256: SELECTION_NAME = ipRec.SELECTION_NAME,
257: SELECTION_PATH = ipRec.SELECTION_PATH,
258: PROPAGATED_FLAG = 'Y',

Line 279: PROCEDURE copyOutputSelections(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

275:
276: END copyInputSelections;
277:
278:
279: PROCEDURE copyOutputSelections(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
280: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
281: p_to_index IN INTEGER,
282: p_dimensionality_flag IN VARCHAR2)
283: IS

Line 280: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,

276: END copyInputSelections;
277:
278:
279: PROCEDURE copyOutputSelections(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
280: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
281: p_to_index IN INTEGER,
282: p_dimensionality_flag IN VARCHAR2)
283: IS
284: opRec ZPB_SOLVE_OUTPUT_SELECTIONS%ROWTYPE;

Line 284: opRec ZPB_SOLVE_OUTPUT_SELECTIONS%ROWTYPE;

280: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
281: p_to_index IN INTEGER,
282: p_dimensionality_flag IN VARCHAR2)
283: IS
284: opRec ZPB_SOLVE_OUTPUT_SELECTIONS%ROWTYPE;
285: CURSOR c1 IS
286: SELECT * FROM ZPB_SOLVE_OUTPUT_SELECTIONS
287: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
288: BEGIN

Line 286: SELECT * FROM ZPB_SOLVE_OUTPUT_SELECTIONS

282: p_dimensionality_flag IN VARCHAR2)
283: IS
284: opRec ZPB_SOLVE_OUTPUT_SELECTIONS%ROWTYPE;
285: CURSOR c1 IS
286: SELECT * FROM ZPB_SOLVE_OUTPUT_SELECTIONS
287: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
288: BEGIN
289: --Update PROPAGATED_FLAG of source member.
290: UPDATE ZPB_SOLVE_OUTPUT_SELECTIONS

Line 290: UPDATE ZPB_SOLVE_OUTPUT_SELECTIONS

286: SELECT * FROM ZPB_SOLVE_OUTPUT_SELECTIONS
287: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
288: BEGIN
289: --Update PROPAGATED_FLAG of source member.
290: UPDATE ZPB_SOLVE_OUTPUT_SELECTIONS
291: SET PROPAGATED_FLAG ='Y'
292: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
293:
294: IF p_dimensionality_flag = 'RECREATE' THEN

Line 296: DELETE FROM ZPB_SOLVE_OUTPUT_SELECTIONS

292: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
293:
294: IF p_dimensionality_flag = 'RECREATE' THEN
295:
296: DELETE FROM ZPB_SOLVE_OUTPUT_SELECTIONS
297: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index);
298:
299:
300: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS

Line 300: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS

296: DELETE FROM ZPB_SOLVE_OUTPUT_SELECTIONS
297: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index);
298:
299:
300: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS
301: (ANALYSIS_CYCLE_ID,
302: MEMBER,
303: MEMBER_ORDER,
304: DIMENSION,

Line 330: FROM ZPB_SOLVE_OUTPUT_SELECTIONS

326: SYSDATE,
327: fnd_global.USER_ID,
328: SYSDATE,
329: fnd_global.LOGIN_ID
330: FROM ZPB_SOLVE_OUTPUT_SELECTIONS
331: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
332: ELSIF p_dimensionality_flag = 'COPY' THEN
333: FOR opRec IN c1 LOOP
334: UPDATE ZPB_SOLVE_OUTPUT_SELECTIONS

Line 334: UPDATE ZPB_SOLVE_OUTPUT_SELECTIONS

330: FROM ZPB_SOLVE_OUTPUT_SELECTIONS
331: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
332: ELSIF p_dimensionality_flag = 'COPY' THEN
333: FOR opRec IN c1 LOOP
334: UPDATE ZPB_SOLVE_OUTPUT_SELECTIONS
335: SET
336: SELECTION_NAME = opRec.SELECTION_NAME,
337: SELECTION_PATH = opRec.SELECTION_PATH,
338: PROPAGATED_FLAG = 'Y',

Line 358: PROCEDURE removeCalcObjectInfo(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

354:
355: END copyOutputSelections;
356:
357:
358: PROCEDURE removeCalcObjectInfo(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
359: p_to_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
360: IS
361: BEGIN
362: UPDATE ZPB_SOLVE_MEMBER_DEFS

Line 359: p_to_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)

355: END copyOutputSelections;
356:
357:
358: PROCEDURE removeCalcObjectInfo(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
359: p_to_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
360: IS
361: BEGIN
362: UPDATE ZPB_SOLVE_MEMBER_DEFS
363: SET CALCSTEP_PATH = NULL,

Line 362: UPDATE ZPB_SOLVE_MEMBER_DEFS

358: PROCEDURE removeCalcObjectInfo(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
359: p_to_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
360: IS
361: BEGIN
362: UPDATE ZPB_SOLVE_MEMBER_DEFS
363: SET CALCSTEP_PATH = NULL,
364: CALC_TYPE = NULL,
365: CALC_DESCRIPTION = NULL,
366: CALC_PARAMETERS = NULL,

Line 486: * If ZPB_SOLVE_OUTPUT_SELECTIONS.MATCH_INPUT_FLAG = 'Y' for *

482:
483:
484: /***********************************************************************
485: * CHECK MATCH_INPUT_FLAG *
486: * If ZPB_SOLVE_OUTPUT_SELECTIONS.MATCH_INPUT_FLAG = 'Y' for *
487: * Loaded,i/p or worksheet i/p line member *
488: * then before changing the source type to calc or hier total *
489: * copy the input selection to output selection and set *
490: * MATCH_INPUT_FLAG to 'N' *

Line 493: PROCEDURE checkMatchInputToOutputFlag(p_ac_id IN ZPB_SOLVE_OUTPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,

489: * copy the input selection to output selection and set *
490: * MATCH_INPUT_FLAG to 'N' *
491: ***********************************************************************/
492:
493: PROCEDURE checkMatchInputToOutputFlag(p_ac_id IN ZPB_SOLVE_OUTPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
494: p_from_member IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER%TYPE)
495: IS
496: l_selectionPath ZPB_SOLVE_INPUT_SELECTIONS.SELECTION_PATH%TYPE;
497: l_selectionName ZPB_SOLVE_INPUT_SELECTIONS.SELECTION_NAME%TYPE;

Line 494: p_from_member IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER%TYPE)

490: * MATCH_INPUT_FLAG to 'N' *
491: ***********************************************************************/
492:
493: PROCEDURE checkMatchInputToOutputFlag(p_ac_id IN ZPB_SOLVE_OUTPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
494: p_from_member IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER%TYPE)
495: IS
496: l_selectionPath ZPB_SOLVE_INPUT_SELECTIONS.SELECTION_PATH%TYPE;
497: l_selectionName ZPB_SOLVE_INPUT_SELECTIONS.SELECTION_NAME%TYPE;
498:

Line 496: l_selectionPath ZPB_SOLVE_INPUT_SELECTIONS.SELECTION_PATH%TYPE;

492:
493: PROCEDURE checkMatchInputToOutputFlag(p_ac_id IN ZPB_SOLVE_OUTPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
494: p_from_member IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER%TYPE)
495: IS
496: l_selectionPath ZPB_SOLVE_INPUT_SELECTIONS.SELECTION_PATH%TYPE;
497: l_selectionName ZPB_SOLVE_INPUT_SELECTIONS.SELECTION_NAME%TYPE;
498:
499: CURSOR c1 IS
500: SELECT MEMBER_ORDER,DIMENSION,HIERARCHY,

Line 497: l_selectionName ZPB_SOLVE_INPUT_SELECTIONS.SELECTION_NAME%TYPE;

493: PROCEDURE checkMatchInputToOutputFlag(p_ac_id IN ZPB_SOLVE_OUTPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
494: p_from_member IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER%TYPE)
495: IS
496: l_selectionPath ZPB_SOLVE_INPUT_SELECTIONS.SELECTION_PATH%TYPE;
497: l_selectionName ZPB_SOLVE_INPUT_SELECTIONS.SELECTION_NAME%TYPE;
498:
499: CURSOR c1 IS
500: SELECT MEMBER_ORDER,DIMENSION,HIERARCHY,
501: SELECTION_PATH,SELECTION_NAME,MATCH_INPUT_FLAG

Line 502: FROM ZPB_SOLVE_OUTPUT_SELECTIONS

498:
499: CURSOR c1 IS
500: SELECT MEMBER_ORDER,DIMENSION,HIERARCHY,
501: SELECTION_PATH,SELECTION_NAME,MATCH_INPUT_FLAG
502: FROM ZPB_SOLVE_OUTPUT_SELECTIONS
503: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member
504: FOR UPDATE;
505:
506: CURSOR c2(p_ac_id ZPB_SOLVE_INPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,

Line 506: CURSOR c2(p_ac_id ZPB_SOLVE_INPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,

502: FROM ZPB_SOLVE_OUTPUT_SELECTIONS
503: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member
504: FOR UPDATE;
505:
506: CURSOR c2(p_ac_id ZPB_SOLVE_INPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
507: p_from_member ZPB_SOLVE_INPUT_SELECTIONS.MEMBER%TYPE,
508: p_member_order ZPB_SOLVE_INPUT_SELECTIONS.MEMBER_ORDER%TYPE,
509: p_dimension ZPB_SOLVE_INPUT_SELECTIONS.DIMENSION%TYPE,
510: p_hierarchy ZPB_SOLVE_INPUT_SELECTIONS.HIERARCHY%TYPE)IS

Line 507: p_from_member ZPB_SOLVE_INPUT_SELECTIONS.MEMBER%TYPE,

503: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member
504: FOR UPDATE;
505:
506: CURSOR c2(p_ac_id ZPB_SOLVE_INPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
507: p_from_member ZPB_SOLVE_INPUT_SELECTIONS.MEMBER%TYPE,
508: p_member_order ZPB_SOLVE_INPUT_SELECTIONS.MEMBER_ORDER%TYPE,
509: p_dimension ZPB_SOLVE_INPUT_SELECTIONS.DIMENSION%TYPE,
510: p_hierarchy ZPB_SOLVE_INPUT_SELECTIONS.HIERARCHY%TYPE)IS
511: SELECT SELECTION_PATH,SELECTION_NAME

Line 508: p_member_order ZPB_SOLVE_INPUT_SELECTIONS.MEMBER_ORDER%TYPE,

504: FOR UPDATE;
505:
506: CURSOR c2(p_ac_id ZPB_SOLVE_INPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
507: p_from_member ZPB_SOLVE_INPUT_SELECTIONS.MEMBER%TYPE,
508: p_member_order ZPB_SOLVE_INPUT_SELECTIONS.MEMBER_ORDER%TYPE,
509: p_dimension ZPB_SOLVE_INPUT_SELECTIONS.DIMENSION%TYPE,
510: p_hierarchy ZPB_SOLVE_INPUT_SELECTIONS.HIERARCHY%TYPE)IS
511: SELECT SELECTION_PATH,SELECTION_NAME
512: FROM ZPB_SOLVE_INPUT_SELECTIONS

Line 509: p_dimension ZPB_SOLVE_INPUT_SELECTIONS.DIMENSION%TYPE,

505:
506: CURSOR c2(p_ac_id ZPB_SOLVE_INPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
507: p_from_member ZPB_SOLVE_INPUT_SELECTIONS.MEMBER%TYPE,
508: p_member_order ZPB_SOLVE_INPUT_SELECTIONS.MEMBER_ORDER%TYPE,
509: p_dimension ZPB_SOLVE_INPUT_SELECTIONS.DIMENSION%TYPE,
510: p_hierarchy ZPB_SOLVE_INPUT_SELECTIONS.HIERARCHY%TYPE)IS
511: SELECT SELECTION_PATH,SELECTION_NAME
512: FROM ZPB_SOLVE_INPUT_SELECTIONS
513: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member AND

Line 510: p_hierarchy ZPB_SOLVE_INPUT_SELECTIONS.HIERARCHY%TYPE)IS

506: CURSOR c2(p_ac_id ZPB_SOLVE_INPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
507: p_from_member ZPB_SOLVE_INPUT_SELECTIONS.MEMBER%TYPE,
508: p_member_order ZPB_SOLVE_INPUT_SELECTIONS.MEMBER_ORDER%TYPE,
509: p_dimension ZPB_SOLVE_INPUT_SELECTIONS.DIMENSION%TYPE,
510: p_hierarchy ZPB_SOLVE_INPUT_SELECTIONS.HIERARCHY%TYPE)IS
511: SELECT SELECTION_PATH,SELECTION_NAME
512: FROM ZPB_SOLVE_INPUT_SELECTIONS
513: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member AND
514: MEMBER_ORDER = p_member_order AND DIMENSION = p_dimension AND

Line 512: FROM ZPB_SOLVE_INPUT_SELECTIONS

508: p_member_order ZPB_SOLVE_INPUT_SELECTIONS.MEMBER_ORDER%TYPE,
509: p_dimension ZPB_SOLVE_INPUT_SELECTIONS.DIMENSION%TYPE,
510: p_hierarchy ZPB_SOLVE_INPUT_SELECTIONS.HIERARCHY%TYPE)IS
511: SELECT SELECTION_PATH,SELECTION_NAME
512: FROM ZPB_SOLVE_INPUT_SELECTIONS
513: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member AND
514: MEMBER_ORDER = p_member_order AND DIMENSION = p_dimension AND
515: HIERARCHY = p_hierarchy;
516: BEGIN

Line 524: UPDATE ZPB_SOLVE_OUTPUT_SELECTIONS

520: OPEN c2(p_ac_id,p_from_member,opRec.MEMBER_ORDER,opRec.DIMENSION,opRec.HIERARCHY);
521: FETCH c2 INTO l_selectionPath,l_selectionName;
522: CLOSE c2;
523:
524: UPDATE ZPB_SOLVE_OUTPUT_SELECTIONS
525: SET SELECTION_PATH = l_selectionPath,
526: SELECTION_NAME = l_selectionName,
527: MATCH_INPUT_FLAG = 'N'
528: WHERE CURRENT OF c1;

Line 552: PROCEDURE propagateCalc(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

548: * PROPAGATE SOURCE TYPE&(DIM INFO or I/P SELECTIONS *
549: * *
550: * *
551: *****************************************************************/
552: PROCEDURE propagateCalc(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
553: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
554: p_prop_dimhandling IN INTEGER,
555: p_prop_input IN INTEGER,
556: p_prop_output IN INTEGER)

Line 553: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,

549: * *
550: * *
551: *****************************************************************/
552: PROCEDURE propagateCalc(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
553: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
554: p_prop_dimhandling IN INTEGER,
555: p_prop_input IN INTEGER,
556: p_prop_output IN INTEGER)
557:

Line 560: fromSource ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE;

556: p_prop_output IN INTEGER)
557:
558:
559: IS
560: fromSource ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE;
561: updateSolve BOOLEAN;
562: l_calcDesc ZPB_SOLVE_MEMBER_DEFS.CALC_DESCRIPTION%TYPE;
563: l_calcType ZPB_SOLVE_MEMBER_DEFS.CALC_TYPE%TYPE;
564: l_calcParams ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;

Line 562: l_calcDesc ZPB_SOLVE_MEMBER_DEFS.CALC_DESCRIPTION%TYPE;

558:
559: IS
560: fromSource ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE;
561: updateSolve BOOLEAN;
562: l_calcDesc ZPB_SOLVE_MEMBER_DEFS.CALC_DESCRIPTION%TYPE;
563: l_calcType ZPB_SOLVE_MEMBER_DEFS.CALC_TYPE%TYPE;
564: l_calcParams ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
565: l_modelEquation ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
566: BEGIN

Line 563: l_calcType ZPB_SOLVE_MEMBER_DEFS.CALC_TYPE%TYPE;

559: IS
560: fromSource ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE;
561: updateSolve BOOLEAN;
562: l_calcDesc ZPB_SOLVE_MEMBER_DEFS.CALC_DESCRIPTION%TYPE;
563: l_calcType ZPB_SOLVE_MEMBER_DEFS.CALC_TYPE%TYPE;
564: l_calcParams ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
565: l_modelEquation ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
566: BEGIN
567: SELECT SOURCE_TYPE INTO fromSource

Line 564: l_calcParams ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;

560: fromSource ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE;
561: updateSolve BOOLEAN;
562: l_calcDesc ZPB_SOLVE_MEMBER_DEFS.CALC_DESCRIPTION%TYPE;
563: l_calcType ZPB_SOLVE_MEMBER_DEFS.CALC_TYPE%TYPE;
564: l_calcParams ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
565: l_modelEquation ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
566: BEGIN
567: SELECT SOURCE_TYPE INTO fromSource
568: FROM ZPB_SOLVE_MEMBER_DEFS

Line 565: l_modelEquation ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;

561: updateSolve BOOLEAN;
562: l_calcDesc ZPB_SOLVE_MEMBER_DEFS.CALC_DESCRIPTION%TYPE;
563: l_calcType ZPB_SOLVE_MEMBER_DEFS.CALC_TYPE%TYPE;
564: l_calcParams ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
565: l_modelEquation ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
566: BEGIN
567: SELECT SOURCE_TYPE INTO fromSource
568: FROM ZPB_SOLVE_MEMBER_DEFS
569: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;

Line 568: FROM ZPB_SOLVE_MEMBER_DEFS

564: l_calcParams ZPB_SOLVE_MEMBER_DEFS.CALC_PARAMETERS%TYPE;
565: l_modelEquation ZPB_SOLVE_MEMBER_DEFS.MODEL_EQUATION%TYPE;
566: BEGIN
567: SELECT SOURCE_TYPE INTO fromSource
568: FROM ZPB_SOLVE_MEMBER_DEFS
569: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
570:
571: --Check whether Source Type of Target Member needs updation
572: --Bug#5092815, changed into bulk operation

Line 574: UPDATE ZPB_SOLVE_MEMBER_DEFS

570:
571: --Check whether Source Type of Target Member needs updation
572: --Bug#5092815, changed into bulk operation
573: FORALL i IN propagateList.FIRST..propagateList.LAST
574: UPDATE ZPB_SOLVE_MEMBER_DEFS
575: SET SOURCE_TYPE = fromSource,
576: LAST_UPDATED_BY = fnd_global.USER_ID,
577: LAST_UPDATE_DATE = SYSDATE,
578: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 594: UPDATE ZPB_SOLVE_MEMBER_DEFS

590: END IF;
591:
592: FOR i IN propagateList.FIRST..propagateList.LAST
593: LOOP
594: UPDATE ZPB_SOLVE_MEMBER_DEFS
595: SET
596: SOURCE_TYPE = fromSource,
597: LAST_UPDATED_BY = fnd_global.USER_ID,
598: LAST_UPDATE_DATE = SYSDATE,

Line 699: DELETE ZPB_SOLVE_INPUT_SELECTIONS WHERE

695:
696: DELETE ZPB_LINE_DIMENSIONALITY WHERE
697: ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER=propagateList(i);
698:
699: DELETE ZPB_SOLVE_INPUT_SELECTIONS WHERE
700: ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER=propagateList(i);
701:
702: ELSIF(propagateSourceType(i) = WS_INPUT_SOURCE) THEN
703: --For CASES:A3-b

Line 706: DELETE ZPB_SOLVE_INPUT_SELECTIONS WHERE

702: ELSIF(propagateSourceType(i) = WS_INPUT_SOURCE) THEN
703: --For CASES:A3-b
704: checkMatchInputToOutputFlag(p_ac_id,propagateList(i));
705:
706: DELETE ZPB_SOLVE_INPUT_SELECTIONS WHERE
707: ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER=propagateList(i);
708:
709: ELSIF(propagateSourceType(i) = INIT_WS_INPUT_SOURCE) THEN
710: --For CASES:A3-b

Line 713: DELETE ZPB_SOLVE_INPUT_SELECTIONS WHERE

709: ELSIF(propagateSourceType(i) = INIT_WS_INPUT_SOURCE) THEN
710: --For CASES:A3-b
711: checkMatchInputToOutputFlag(p_ac_id,propagateList(i));
712:
713: DELETE ZPB_SOLVE_INPUT_SELECTIONS WHERE
714: ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER=propagateList(i);
715:
716: deleteInializedInputSettings(p_ac_id,propagateList(i));
717: ELSIF(propagateSourceType(i) = CALCULATED_SOURCE AND fromSource = AGGREGATED_SOURCE )THEN

Line 739: FROM ZPB_SOLVE_MEMBER_DEFS

735:
736: SELECT CALC_DESCRIPTION,CALC_TYPE,CALC_PARAMETERS,MODEL_EQUATION
737: INTO l_calcDesc,l_calcType,l_calcParams,l_modelEquation
738:
739: FROM ZPB_SOLVE_MEMBER_DEFS
740: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
741:
742: UPDATE ZPB_SOLVE_MEMBER_DEFS
743: SET CALCSTEP_PATH = propagateList(i),

Line 742: UPDATE ZPB_SOLVE_MEMBER_DEFS

738:
739: FROM ZPB_SOLVE_MEMBER_DEFS
740: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
741:
742: UPDATE ZPB_SOLVE_MEMBER_DEFS
743: SET CALCSTEP_PATH = propagateList(i),
744: CALC_TYPE = l_calcType,
745: CALC_DESCRIPTION = l_calcDesc,
746: CALC_PARAMETERS = l_calcParams,

Line 765: PROCEDURE propagateAlloc(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

761: * *
762: * *
763: *****************************************************************/
764:
765: PROCEDURE propagateAlloc(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
766:
767: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
768:
769: IS

Line 767: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)

763: *****************************************************************/
764:
765: PROCEDURE propagateAlloc(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
766:
767: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
768:
769: IS
770: BEGIN
771: --delete existing rows

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:

Line 809: PROCEDURE propagateOutput(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

805: * *
806: * *
807: *****************************************************************/
808:
809: PROCEDURE propagateOutput(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
810: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
811:
812: IS
813: opRec ZPB_SOLVE_OUTPUT_SELECTIONS%ROWTYPE;

Line 810: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)

806: * *
807: *****************************************************************/
808:
809: PROCEDURE propagateOutput(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
810: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
811:
812: IS
813: opRec ZPB_SOLVE_OUTPUT_SELECTIONS%ROWTYPE;
814:

Line 813: opRec ZPB_SOLVE_OUTPUT_SELECTIONS%ROWTYPE;

809: PROCEDURE propagateOutput(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
810: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
811:
812: IS
813: opRec ZPB_SOLVE_OUTPUT_SELECTIONS%ROWTYPE;
814:
815: CURSOR c1 IS
816: SELECT * FROM ZPB_SOLVE_OUTPUT_SELECTIONS
817: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;

Line 816: SELECT * FROM ZPB_SOLVE_OUTPUT_SELECTIONS

812: IS
813: opRec ZPB_SOLVE_OUTPUT_SELECTIONS%ROWTYPE;
814:
815: CURSOR c1 IS
816: SELECT * FROM ZPB_SOLVE_OUTPUT_SELECTIONS
817: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
818:
819: fromSource ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE;
820: BEGIN

Line 819: fromSource ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE;

815: CURSOR c1 IS
816: SELECT * FROM ZPB_SOLVE_OUTPUT_SELECTIONS
817: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
818:
819: fromSource ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE;
820: BEGIN
821: SELECT SOURCE_TYPE INTO fromSource
822: FROM ZPB_SOLVE_MEMBER_DEFS
823: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;

Line 822: FROM ZPB_SOLVE_MEMBER_DEFS

818:
819: fromSource ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE;
820: BEGIN
821: SELECT SOURCE_TYPE INTO fromSource
822: FROM ZPB_SOLVE_MEMBER_DEFS
823: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
824:
825: --For all cases update PROPAGATED_FLAG of source member.
826: UPDATE ZPB_SOLVE_OUTPUT_SELECTIONS

Line 826: UPDATE ZPB_SOLVE_OUTPUT_SELECTIONS

822: FROM ZPB_SOLVE_MEMBER_DEFS
823: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
824:
825: --For all cases update PROPAGATED_FLAG of source member.
826: UPDATE ZPB_SOLVE_OUTPUT_SELECTIONS
827: SET PROPAGATED_FLAG ='Y'
828: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
829:
830: FOR i IN propagateList.FIRST..propagateList.LAST LOOP

Line 835: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS

831:
832: --IF propagateList(i) = CALCULATED_SOURCE OR propagateList(i) = AGGREGATED_SOURCE THEN
833: IF propagateSourceType(i) = CALCULATED_SOURCE THEN
834: IF fromSource = CALCULATED_SOURCE THEN
835: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS
836: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
837: ELSE
838: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS
839: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i) AND

Line 838: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS

834: IF fromSource = CALCULATED_SOURCE THEN
835: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS
836: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
837: ELSE
838: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS
839: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i) AND
840: HIERARCHY <> 'NONE' ;
841: END IF ;
842: FOR opRec IN c1 LOOP

Line 843: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS

839: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i) AND
840: HIERARCHY <> 'NONE' ;
841: END IF ;
842: FOR opRec IN c1 LOOP
843: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS
844: (ANALYSIS_CYCLE_ID,
845: MEMBER,
846: MEMBER_ORDER,
847: DIMENSION,

Line 881: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS

877: -- (propagateList(i) <> CALCULATED_SOURCE AND propagateList(i) <> AGGREGATED_SOURCE)THEN
878: ELSIF fromSource = CALCULATED_SOURCE AND propagateSourceType(i) <> CALCULATED_SOURCE THEN
879:
880: FOR opRec IN c1 LOOP
881: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS
882: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND
883: DIMENSION in (select dimension from ZPB_SOLVE_OUTPUT_SELECTIONS
884: where member = opRec.member
885: and dimension = opRec.dimension

Line 883: DIMENSION in (select dimension from ZPB_SOLVE_OUTPUT_SELECTIONS

879:
880: FOR opRec IN c1 LOOP
881: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS
882: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND
883: DIMENSION in (select dimension from ZPB_SOLVE_OUTPUT_SELECTIONS
884: where member = opRec.member
885: and dimension = opRec.dimension
886: and analysis_cycle_id = p_ac_id)
887: and member = propagateList(i);

Line 891: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS

887: and member = propagateList(i);
888: END LOOP;
889: FOR opRec IN c1 LOOP
890: if opRec.hierarchy <> 'NONE' then
891: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS
892: (ANALYSIS_CYCLE_ID,
893: MEMBER,
894: MEMBER_ORDER,
895: DIMENSION,

Line 926: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS

922:
923:
924:
925: ELSE
926: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS
927: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND
928: MEMBER = propagateList(i) ;
929:
930: FOR opRec IN c1 LOOP

Line 931: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS

927: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND
928: MEMBER = propagateList(i) ;
929:
930: FOR opRec IN c1 LOOP
931: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS
932: (ANALYSIS_CYCLE_ID,
933: MEMBER,
934: MEMBER_ORDER,
935: DIMENSION,

Line 983: PROCEDURE propagateDimhandling(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

979: * *
980:
981: *****************************************************************/
982:
983: PROCEDURE propagateDimhandling(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
984: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
985: IS
986: fromSource NUMBER;
987: dimRec ZPB_LINE_DIMENSIONALITY%ROWTYPE;

Line 984: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)

980:
981: *****************************************************************/
982:
983: PROCEDURE propagateDimhandling(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
984: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE)
985: IS
986: fromSource NUMBER;
987: dimRec ZPB_LINE_DIMENSIONALITY%ROWTYPE;
988: isSetSrcPropFlag boolean := FALSE;

Line 995: FROM ZPB_SOLVE_MEMBER_DEFS

991: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
992: BEGIN
993: SELECT SOURCE_TYPE INTO fromSource
994:
995: FROM ZPB_SOLVE_MEMBER_DEFS
996: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
997:
998: IF fromSource = LOADED_SOURCE THEN
999: FOR i IN propagateList.FIRST..propagateList.LAST

Line 1072: p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

1068: * *
1069: ****************************************************************/
1070:
1071: PROCEDURE propagateSolve (
1072: p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
1073: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
1074: p_view_dim_name IN VARCHAR2,
1075: p_view_member_column IN VARCHAR2,
1076: p_view_short_lbl_column IN VARCHAR2,

Line 1073: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,

1069: ****************************************************************/
1070:
1071: PROCEDURE propagateSolve (
1072: p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
1073: p_from_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
1074: p_view_dim_name IN VARCHAR2,
1075: p_view_member_column IN VARCHAR2,
1076: p_view_short_lbl_column IN VARCHAR2,
1077: p_prop_calc IN INTEGER, -- source flag

Line 1093: tableselect := tableselect || ' FROM ZPB_SOLVE_MEMBER_DEFS defs, ';

1089:
1090: tableselect := 'Select member, member_order, memberlookup.';
1091: tableselect := tableselect || p_view_short_lbl_column || ' as MemberName,';
1092: tableselect := tableselect || ' SOURCE_TYPE';
1093: tableselect := tableselect || ' FROM ZPB_SOLVE_MEMBER_DEFS defs, ';
1094: tableselect := tableselect || p_view_dim_name || ' memberlookup';
1095: tableselect := tableselect || ' WHERE defs.ANALYSIS_CYCLE_ID = ' || p_ac_id;
1096: tableselect := tableselect || ' AND defs.PROPAGATE_TARGET = ' || iTrueValue;
1097: tableselect := tableselect || ' AND defs.member = memberlookup.' || p_view_member_column;

Line 1104: FROM ZPB_SOLVE_MEMBER_DEFS

1100: Fetch c4 BULK COLLECT into propagateList, propagateOrder, propagateName, propagateSourceType;
1101:
1102: SELECT SOURCE_TYPE INTO fromSource
1103:
1104: FROM ZPB_SOLVE_MEMBER_DEFS
1105: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
1106:
1107: if p_prop_calc = iTrueValue THEN
1108: propagateCalc(p_ac_id, p_from_member,p_prop_dimhandling,p_prop_input,p_prop_output);

Line 1123: UPDATE ZPB_SOLVE_MEMBER_DEFS

1119: if p_prop_dimhandling = iTrueValue and p_prop_calc = iFalseValue THEN
1120: propagateDimhandling(p_ac_id, p_from_member);
1121: END IF;
1122: --reset propagate flag
1123: UPDATE ZPB_SOLVE_MEMBER_DEFS
1124: SET PROPAGATE_TARGET = iFalseValue,
1125: LAST_UPDATED_BY = fnd_global.USER_ID,
1126: LAST_UPDATE_DATE = SYSDATE,
1127: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1139: WHERE LOOKUP_TYPE = 'ZPB_SOLVE_DIMENSIONLIST_SELECT' AND LOOKUP_CODE = p_lookup_code;

1135: ret_meaning FND_LOOKUP_VALUES_VL.MEANING%TYPE;
1136: BEGIN
1137: SELECT MEANING||',' INTO ret_meaning
1138: FROM FND_LOOKUP_VALUES_VL
1139: WHERE LOOKUP_TYPE = 'ZPB_SOLVE_DIMENSIONLIST_SELECT' AND LOOKUP_CODE = p_lookup_code;
1140: RETURN ret_meaning;
1141: END getDimSettingMeaning;
1142:
1143: PROCEDURE updateCleanup(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

Line 1143: PROCEDURE updateCleanup(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

1139: WHERE LOOKUP_TYPE = 'ZPB_SOLVE_DIMENSIONLIST_SELECT' AND LOOKUP_CODE = p_lookup_code;
1140: RETURN ret_meaning;
1141: END getDimSettingMeaning;
1142:
1143: PROCEDURE updateCleanup(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
1144: p_line_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
1145: p_src_type IN ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE)
1146: IS
1147:

Line 1144: p_line_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,

1140: RETURN ret_meaning;
1141: END getDimSettingMeaning;
1142:
1143: PROCEDURE updateCleanup(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
1144: p_line_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
1145: p_src_type IN ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE)
1146: IS
1147:
1148: BEGIN

Line 1145: p_src_type IN ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE)

1141: END getDimSettingMeaning;
1142:
1143: PROCEDURE updateCleanup(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
1144: p_line_member IN ZPB_SOLVE_MEMBER_DEFS.MEMBER%TYPE,
1145: p_src_type IN ZPB_SOLVE_MEMBER_DEFS.SOURCE_TYPE%TYPE)
1146: IS
1147:
1148: BEGIN
1149: IF p_src_type <> LOADED_SOURCE THEN

Line 1153: delete from zpb_solve_input_selections where analysis_cycle_id = p_ac_id and member = p_line_member;

1149: IF p_src_type <> LOADED_SOURCE THEN
1150: delete from zpb_line_dimensionality where analysis_cycle_id = p_ac_id and member = p_line_member;
1151: END IF;
1152: IF p_src_type = CALCULATED_SOURCE OR p_src_type = AGGREGATED_SOURCE THEN
1153: delete from zpb_solve_input_selections where analysis_cycle_id = p_ac_id and member = p_line_member;
1154: update ZPB_SOLVE_OUTPUT_SELECTIONS
1155: set MATCH_INPUT_FLAG = 'N'
1156: where analysis_cycle_id = p_ac_id and member = p_line_member;
1157: END IF;

Line 1154: update ZPB_SOLVE_OUTPUT_SELECTIONS

1150: delete from zpb_line_dimensionality where analysis_cycle_id = p_ac_id and member = p_line_member;
1151: END IF;
1152: IF p_src_type = CALCULATED_SOURCE OR p_src_type = AGGREGATED_SOURCE THEN
1153: delete from zpb_solve_input_selections where analysis_cycle_id = p_ac_id and member = p_line_member;
1154: update ZPB_SOLVE_OUTPUT_SELECTIONS
1155: set MATCH_INPUT_FLAG = 'N'
1156: where analysis_cycle_id = p_ac_id and member = p_line_member;
1157: END IF;
1158: IF p_src_type <> CALCULATED_SOURCE THEN

Line 1159: delete from zpb_solve_output_selections where analysis_cycle_id = p_ac_id and member = p_line_member

1155: set MATCH_INPUT_FLAG = 'N'
1156: where analysis_cycle_id = p_ac_id and member = p_line_member;
1157: END IF;
1158: IF p_src_type <> CALCULATED_SOURCE THEN
1159: delete from zpb_solve_output_selections where analysis_cycle_id = p_ac_id and member = p_line_member
1160: AND hierarchy = 'NONE';
1161: END IF;
1162: IF p_src_type <> INIT_WS_INPUT_SOURCE THEN
1163: -- for bug 5001437

Line 1185: PROCEDURE deleteOutputSelections(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,

1181: END IF;
1182: END updateCleanup;
1183:
1184:
1185: PROCEDURE deleteOutputSelections(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
1186: p_targetIndex IN INTEGER )
1187: IS
1188: BEGIN
1189: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS

Line 1189: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS

1185: PROCEDURE deleteOutputSelections(p_ac_id IN ZPB_SOLVE_MEMBER_DEFS.ANALYSIS_CYCLE_ID%TYPE,
1186: p_targetIndex IN INTEGER )
1187: IS
1188: BEGIN
1189: DELETE ZPB_SOLVE_OUTPUT_SELECTIONS
1190: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_targetIndex)
1191: AND HIERARCHY = 'NONE';
1192:
1193: END deleteOutputSelections;

Line 1195: PROCEDURE insertDefaultOutput(p_ac_id IN ZPB_SOLVE_OUTPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,

1191: AND HIERARCHY = 'NONE';
1192:
1193: END deleteOutputSelections;
1194:
1195: PROCEDURE insertDefaultOutput(p_ac_id IN ZPB_SOLVE_OUTPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
1196: p_line_member IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER%TYPE,
1197: p_memberOrder IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER_ORDER%TYPE,
1198: p_dimension IN ZPB_SOLVE_OUTPUT_SELECTIONS.DIMENSION%TYPE)
1199: IS

Line 1196: p_line_member IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER%TYPE,

1192:
1193: END deleteOutputSelections;
1194:
1195: PROCEDURE insertDefaultOutput(p_ac_id IN ZPB_SOLVE_OUTPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
1196: p_line_member IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER%TYPE,
1197: p_memberOrder IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER_ORDER%TYPE,
1198: p_dimension IN ZPB_SOLVE_OUTPUT_SELECTIONS.DIMENSION%TYPE)
1199: IS
1200: BEGIN

Line 1197: p_memberOrder IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER_ORDER%TYPE,

1193: END deleteOutputSelections;
1194:
1195: PROCEDURE insertDefaultOutput(p_ac_id IN ZPB_SOLVE_OUTPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
1196: p_line_member IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER%TYPE,
1197: p_memberOrder IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER_ORDER%TYPE,
1198: p_dimension IN ZPB_SOLVE_OUTPUT_SELECTIONS.DIMENSION%TYPE)
1199: IS
1200: BEGIN
1201: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS

Line 1198: p_dimension IN ZPB_SOLVE_OUTPUT_SELECTIONS.DIMENSION%TYPE)

1194:
1195: PROCEDURE insertDefaultOutput(p_ac_id IN ZPB_SOLVE_OUTPUT_SELECTIONS.ANALYSIS_CYCLE_ID%TYPE,
1196: p_line_member IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER%TYPE,
1197: p_memberOrder IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER_ORDER%TYPE,
1198: p_dimension IN ZPB_SOLVE_OUTPUT_SELECTIONS.DIMENSION%TYPE)
1199: IS
1200: BEGIN
1201: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS
1202: (ANALYSIS_CYCLE_ID,

Line 1201: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS

1197: p_memberOrder IN ZPB_SOLVE_OUTPUT_SELECTIONS.MEMBER_ORDER%TYPE,
1198: p_dimension IN ZPB_SOLVE_OUTPUT_SELECTIONS.DIMENSION%TYPE)
1199: IS
1200: BEGIN
1201: INSERT INTO ZPB_SOLVE_OUTPUT_SELECTIONS
1202: (ANALYSIS_CYCLE_ID,
1203: MEMBER,
1204: MEMBER_ORDER,
1205: DIMENSION,

Line 1233: -- Looks for removed hierarchies in zpb_solve_in/output_selections

1229:
1230: END insertDefaultOutput;
1231:
1232: --
1233: -- Looks for removed hierarchies in zpb_solve_in/output_selections
1234: -- and removes them, and defaults to other hiers if necessary (4705541)
1235: --
1236: PROCEDURE initialize_solve_selections
1237: (p_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) is

Line 1241: l_new_hier ZPB_SOLVE_INPUT_SELECTIONS.HIERARCHY%type;

1237: (p_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) is
1238: l_count number;
1239: l_ba_id number;
1240: l_shadow number;
1241: l_new_hier ZPB_SOLVE_INPUT_SELECTIONS.HIERARCHY%type;
1242: l_dimension ZPB_SOLVE_INPUT_SELECTIONS.DIMENSION%type;
1243:
1244: cursor input_hiers is
1245: select distinct hierarchy, dimension

Line 1242: l_dimension ZPB_SOLVE_INPUT_SELECTIONS.DIMENSION%type;

1238: l_count number;
1239: l_ba_id number;
1240: l_shadow number;
1241: l_new_hier ZPB_SOLVE_INPUT_SELECTIONS.HIERARCHY%type;
1242: l_dimension ZPB_SOLVE_INPUT_SELECTIONS.DIMENSION%type;
1243:
1244: cursor input_hiers is
1245: select distinct hierarchy, dimension
1246: from zpb_solve_input_selections

Line 1246: from zpb_solve_input_selections

1242: l_dimension ZPB_SOLVE_INPUT_SELECTIONS.DIMENSION%type;
1243:
1244: cursor input_hiers is
1245: select distinct hierarchy, dimension
1246: from zpb_solve_input_selections
1247: where analysis_cycle_id = p_ac_id
1248: and hierarchy <> 'NONE'
1249: MINUS
1250: select distinct a.epb_id, b.aw_name

Line 1262: from zpb_solve_output_selections

1258: and c.user_id = l_shadow;
1259:
1260: cursor output_hiers is
1261: select distinct hierarchy, dimension
1262: from zpb_solve_output_selections
1263: where analysis_cycle_id = p_ac_id
1264: and hierarchy <> 'NONE'
1265: MINUS
1266: select distinct a.EPB_ID, b.aw_name

Line 1299: delete from zpb_solve_input_selections

1295: --
1296: -- First delete any selections where there is another selection
1297: -- on another hierarchy already
1298: --
1299: delete from zpb_solve_input_selections
1300: where analysis_cycle_id = p_ac_id
1301: and dimension = each.dimension
1302: and hierarchy = each.hierarchy
1303: and member in

Line 1305: from zpb_solve_input_selections

1301: and dimension = each.dimension
1302: and hierarchy = each.hierarchy
1303: and member in
1304: (select member
1305: from zpb_solve_input_selections
1306: where analysis_cycle_id = p_ac_id
1307: and dimension = each.dimension
1308: and hierarchy <> each.hierarchy);
1309:

Line 1343: update zpb_solve_input_selections

1339: and a.dimension_id = b.dimension_id
1340: and b.hierarchy_id = c.hierarchy_id
1341: and c.user_id = l_shadow;
1342: end;
1343: update zpb_solve_input_selections
1344: set selection_name = 'DEFAULT',
1345: selection_path = null,
1346: hierarchy = l_new_hier,
1347: last_update_date = sysdate,

Line 1359: delete from zpb_solve_input_selections

1355: -- The case when there are no hierarchies left on the dimension.
1356: -- First delete any input selections where we have already set the
1357: -- HIERARCHY to NONE... case when mutliple hiers have been removed
1358: --
1359: delete from zpb_solve_input_selections
1360: where analysis_cycle_id = p_ac_id
1361: and dimension = each.dimension
1362: and hierarchy = each.hierarchy
1363: and member in

Line 1365: from zpb_solve_input_selections

1361: and dimension = each.dimension
1362: and hierarchy = each.hierarchy
1363: and member in
1364: (select member
1365: from zpb_solve_input_selections
1366: where analysis_cycle_id = p_ac_id
1367: and dimension = each.dimension
1368: and hierarchy = 'NONE');
1369:

Line 1373: update zpb_solve_input_selections

1369:
1370: --
1371: -- Now update the rest to be set to NONE
1372: --
1373: update zpb_solve_input_selections
1374: set hierarchy = 'NONE',
1375: selection_path = null,
1376: selection_name = 'DEFAULT',
1377: last_update_date = sysdate,

Line 1407: delete from zpb_solve_output_selections

1403: --
1404: -- First delete any selections where there is another selection
1405: -- on another hierarchy already
1406: --
1407: delete from zpb_solve_output_selections
1408: where analysis_cycle_id = p_ac_id
1409: and dimension = each.dimension
1410: and hierarchy = each.hierarchy
1411: and member in

Line 1413: from zpb_solve_output_selections

1409: and dimension = each.dimension
1410: and hierarchy = each.hierarchy
1411: and member in
1412: (select member
1413: from zpb_solve_output_selections
1414: where analysis_cycle_id = p_ac_id
1415: and dimension = each.dimension
1416: and hierarchy <> each.hierarchy);
1417:

Line 1451: update zpb_solve_output_selections

1447: and a.dimension_id = b.dimension_id
1448: and b.hierarchy_id = c.hierarchy_id
1449: and c.user_id = l_shadow;
1450: end;
1451: update zpb_solve_output_selections
1452: set selection_name = 'DEFAULT',
1453: selection_path = null,
1454: hierarchy = l_new_hier,
1455: last_update_date = sysdate,

Line 1467: delete from zpb_solve_output_selections

1463: -- The case when there are no hierarchies left on the dimension.
1464: -- First delete any output selections where we have already set the
1465: -- HIERARCHY to NONE... case when mutliple hiers have been removed
1466: --
1467: delete from zpb_solve_output_selections
1468: where analysis_cycle_id = p_ac_id
1469: and dimension = each.dimension
1470: and hierarchy = each.hierarchy
1471: and member in

Line 1473: from zpb_solve_output_selections

1469: and dimension = each.dimension
1470: and hierarchy = each.hierarchy
1471: and member in
1472: (select member
1473: from zpb_solve_output_selections
1474: where analysis_cycle_id = p_ac_id
1475: and dimension = each.dimension
1476: and hierarchy = 'NONE');
1477:

Line 1481: update zpb_solve_output_selections

1477:
1478: --
1479: -- Now update the rest to be set to NONE
1480: --
1481: update zpb_solve_output_selections
1482: set hierarchy = 'NONE',
1483: selection_path = null,
1484: selection_name = 'DEFAULT',
1485: last_update_date = sysdate,

Line 1598: END zpb_solve;

1594: errbuf:=substr(sqlerrm, 1, 255);
1595:
1596: end run_solve;
1597:
1598: END zpb_solve;