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_LINE_DIMENSIONALITY

Line 111: dimRec ZPB_LINE_DIMENSIONALITY%ROWTYPE;

107: p_to_index IN INTEGER,
108: p_dimensionality_flag IN VARCHAR2 DEFAULT 'NO')
109: IS
110:
111: dimRec ZPB_LINE_DIMENSIONALITY%ROWTYPE;
112:
113: CURSOR c1 IS
114: SELECT * FROM ZPB_LINE_DIMENSIONALITY
115: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;

Line 114: SELECT * FROM ZPB_LINE_DIMENSIONALITY

110:
111: dimRec ZPB_LINE_DIMENSIONALITY%ROWTYPE;
112:
113: CURSOR c1 IS
114: SELECT * FROM ZPB_LINE_DIMENSIONALITY
115: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
116: BEGIN
117: --Update PROPAGATED_FLAG of source member.
118: UPDATE ZPB_LINE_DIMENSIONALITY

Line 118: UPDATE ZPB_LINE_DIMENSIONALITY

114: SELECT * FROM ZPB_LINE_DIMENSIONALITY
115: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
116: BEGIN
117: --Update PROPAGATED_FLAG of source member.
118: UPDATE ZPB_LINE_DIMENSIONALITY
119: SET PROPAGATED_FLAG ='Y'
120: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
121: --Copy dim handling info.
122: FOR dimRec IN c1

Line 126: DELETE FROM ZPB_LINE_DIMENSIONALITY

122: FOR dimRec IN c1
123: LOOP
124: IF p_dimensionality_flag = 'RECREATE' THEN
125:
126: DELETE FROM ZPB_LINE_DIMENSIONALITY
127: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index);
128:
129: INSERT INTO ZPB_LINE_DIMENSIONALITY
130: (ANALYSIS_CYCLE_ID,

Line 129: INSERT INTO ZPB_LINE_DIMENSIONALITY

125:
126: DELETE FROM ZPB_LINE_DIMENSIONALITY
127: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(p_to_index);
128:
129: INSERT INTO ZPB_LINE_DIMENSIONALITY
130: (ANALYSIS_CYCLE_ID,
131: MEMBER,
132: MEMBER_ORDER,
133: DIMENSION,

Line 163: FROM ZPB_LINE_DIMENSIONALITY

159: SYSDATE,
160: fnd_global.USER_ID,
161: SYSDATE,
162: fnd_global.LOGIN_ID
163: FROM ZPB_LINE_DIMENSIONALITY
164: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
165:
166: ELSE
167: UPDATE ZPB_LINE_DIMENSIONALITY

Line 167: UPDATE ZPB_LINE_DIMENSIONALITY

163: FROM ZPB_LINE_DIMENSIONALITY
164: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
165:
166: ELSE
167: UPDATE ZPB_LINE_DIMENSIONALITY
168: SET SUM_MEMBERS_NUMBER = dimRec.SUM_MEMBERS_NUMBER,
169: SUM_MEMBERS_FLAG = dimRec.SUM_MEMBERS_FLAG,
170: EXCLUDE_FROM_SOLVE_FLAG = dimRec.EXCLUDE_FROM_SOLVE_FLAG,
171: FORCE_INPUT_FLAG = dimRec.FORCE_INPUT_FLAG,

Line 636: DELETE ZPB_LINE_DIMENSIONALITY WHERE

632: removeCalcObjectInfo(p_ac_id,propagateList(i));
633: END IF;
634: ELSIF fromSource = WS_INPUT_SOURCE THEN
635: IF propagateSourceType(i) = LOADED_SOURCE THEN
636: DELETE ZPB_LINE_DIMENSIONALITY WHERE
637: ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER=propagateList(i);
638: END IF;
639: IF p_prop_input = iTrueValue THEN
640: copyInputSelections(p_ac_id,p_from_member,i,'RECREATE');

Line 665: DELETE ZPB_LINE_DIMENSIONALITY WHERE

661: END IF;
662:
663: ELSIF fromSource = INIT_WS_INPUT_SOURCE THEN
664: IF propagateSourceType(i) = LOADED_SOURCE THEN
665: DELETE ZPB_LINE_DIMENSIONALITY WHERE
666: ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER=propagateList(i);
667: END IF;
668: IF p_prop_input = iTrueValue THEN
669: copyInputSelections(p_ac_id,p_from_member,i,'RECREATE');

Line 696: DELETE ZPB_LINE_DIMENSIONALITY WHERE

692: IF(propagateSourceType(i) = LOADED_SOURCE) THEN
693: --For CASES:A3-a
694: checkMatchInputToOutputFlag(p_ac_id,propagateList(i));
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);

Line 987: dimRec ZPB_LINE_DIMENSIONALITY%ROWTYPE;

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;
989: CURSOR c1 IS
990: SELECT * FROM ZPB_LINE_DIMENSIONALITY
991: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;

Line 990: SELECT * FROM ZPB_LINE_DIMENSIONALITY

986: fromSource NUMBER;
987: dimRec ZPB_LINE_DIMENSIONALITY%ROWTYPE;
988: isSetSrcPropFlag boolean := FALSE;
989: CURSOR c1 IS
990: SELECT * FROM ZPB_LINE_DIMENSIONALITY
991: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
992: BEGIN
993: SELECT SOURCE_TYPE INTO fromSource
994:

Line 1004: DELETE ZPB_LINE_DIMENSIONALITY

1000: LOOP
1001: IF propagateSourceType(i) = LOADED_SOURCE THEN
1002: isSetSrcPropFlag := TRUE;
1003:
1004: DELETE ZPB_LINE_DIMENSIONALITY
1005: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
1006: --For CASE: B1-a
1007: FOR dimRec IN c1 LOOP
1008:

Line 1009: INSERT INTO ZPB_LINE_DIMENSIONALITY

1005: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = propagateList(i);
1006: --For CASE: B1-a
1007: FOR dimRec IN c1 LOOP
1008:
1009: INSERT INTO ZPB_LINE_DIMENSIONALITY
1010: (ANALYSIS_CYCLE_ID,
1011: MEMBER,
1012: MEMBER_ORDER,
1013: DIMENSION,

Line 1049: UPDATE ZPB_LINE_DIMENSIONALITY

1045: END IF;
1046: --Update PROPAGATED_FLAG of source member.
1047: IF isSetSrcPropFlag = TRUE THEN
1048:
1049: UPDATE ZPB_LINE_DIMENSIONALITY
1050: SET PROPAGATED_FLAG ='Y'
1051: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
1052: END IF;
1053:

Line 1150: delete from zpb_line_dimensionality where analysis_cycle_id = p_ac_id and member = p_line_member;

1146: IS
1147:
1148: BEGIN
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