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_OUTPUT_SELECTIONS

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