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_INPUT_SELECTIONS

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 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 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 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 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 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 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 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 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,