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.QPR_TRANSFORMATION dependencies on QPR_TRANSFORMATION

Line 1: PACKAGE BODY QPR_TRANSFORMATION AS

1: PACKAGE BODY QPR_TRANSFORMATION AS
2: /* $Header: QPRUTRNB.pls 120.1 2008/01/10 10:00:03 kdhabali noship $ */
3:
4: FUNCTION get_null return varchar2 is
5: begin

Line 124: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure1_number)

120: csd.instance_id=p_instance_id and
121: csd.time_level_value between p_from_date and p_to_date
122: and qtr.transf_header_id = p_transf_header_id and
123: ((p_meas_type_code = '1' and csd.measure1_number between
124: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure1_number)
125: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure1_number)) or
126: (p_meas_type_code = '2' and csd.measure2_number between
127: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure2_number)
128: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure2_number)) or

Line 125: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure1_number)) or

121: csd.time_level_value between p_from_date and p_to_date
122: and qtr.transf_header_id = p_transf_header_id and
123: ((p_meas_type_code = '1' and csd.measure1_number between
124: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure1_number)
125: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure1_number)) or
126: (p_meas_type_code = '2' and csd.measure2_number between
127: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure2_number)
128: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure2_number)) or
129: (p_meas_type_code = '3' and csd.measure3_number between

Line 127: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure2_number)

123: ((p_meas_type_code = '1' and csd.measure1_number between
124: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure1_number)
125: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure1_number)) or
126: (p_meas_type_code = '2' and csd.measure2_number between
127: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure2_number)
128: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure2_number)) or
129: (p_meas_type_code = '3' and csd.measure3_number between
130: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure3_number)
131: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure3_number)) or

Line 128: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure2_number)) or

124: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure1_number)
125: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure1_number)) or
126: (p_meas_type_code = '2' and csd.measure2_number between
127: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure2_number)
128: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure2_number)) or
129: (p_meas_type_code = '3' and csd.measure3_number between
130: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure3_number)
131: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure3_number)) or
132: (p_meas_type_code = '4' and csd.measure4_number between

Line 130: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure3_number)

126: (p_meas_type_code = '2' and csd.measure2_number between
127: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure2_number)
128: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure2_number)) or
129: (p_meas_type_code = '3' and csd.measure3_number between
130: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure3_number)
131: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure3_number)) or
132: (p_meas_type_code = '4' and csd.measure4_number between
133: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure4_number)
134: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure4_number)) or

Line 131: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure3_number)) or

127: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure2_number)
128: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure2_number)) or
129: (p_meas_type_code = '3' and csd.measure3_number between
130: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure3_number)
131: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure3_number)) or
132: (p_meas_type_code = '4' and csd.measure4_number between
133: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure4_number)
134: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure4_number)) or
135: (p_meas_type_code = '5' and csd.measure5_number between

Line 133: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure4_number)

129: (p_meas_type_code = '3' and csd.measure3_number between
130: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure3_number)
131: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure3_number)) or
132: (p_meas_type_code = '4' and csd.measure4_number between
133: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure4_number)
134: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure4_number)) or
135: (p_meas_type_code = '5' and csd.measure5_number between
136: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure5_number)
137: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure5_number)) or

Line 134: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure4_number)) or

130: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure3_number)
131: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure3_number)) or
132: (p_meas_type_code = '4' and csd.measure4_number between
133: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure4_number)
134: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure4_number)) or
135: (p_meas_type_code = '5' and csd.measure5_number between
136: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure5_number)
137: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure5_number)) or
138: (p_meas_type_code = '6' and csd.measure6_number between

Line 136: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure5_number)

132: (p_meas_type_code = '4' and csd.measure4_number between
133: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure4_number)
134: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure4_number)) or
135: (p_meas_type_code = '5' and csd.measure5_number between
136: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure5_number)
137: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure5_number)) or
138: (p_meas_type_code = '6' and csd.measure6_number between
139: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure6_number)
140: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure6_number)) or

Line 137: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure5_number)) or

133: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure4_number)
134: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure4_number)) or
135: (p_meas_type_code = '5' and csd.measure5_number between
136: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure5_number)
137: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure5_number)) or
138: (p_meas_type_code = '6' and csd.measure6_number between
139: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure6_number)
140: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure6_number)) or
141: (p_meas_type_code = '7' and csd.measure7_number between

Line 139: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure6_number)

135: (p_meas_type_code = '5' and csd.measure5_number between
136: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure5_number)
137: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure5_number)) or
138: (p_meas_type_code = '6' and csd.measure6_number between
139: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure6_number)
140: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure6_number)) or
141: (p_meas_type_code = '7' and csd.measure7_number between
142: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure7_number)
143: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure7_number)) or

Line 140: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure6_number)) or

136: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure5_number)
137: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure5_number)) or
138: (p_meas_type_code = '6' and csd.measure6_number between
139: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure6_number)
140: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure6_number)) or
141: (p_meas_type_code = '7' and csd.measure7_number between
142: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure7_number)
143: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure7_number)) or
144: (p_meas_type_code = '8' and csd.measure8_number between

Line 142: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure7_number)

138: (p_meas_type_code = '6' and csd.measure6_number between
139: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure6_number)
140: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure6_number)) or
141: (p_meas_type_code = '7' and csd.measure7_number between
142: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure7_number)
143: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure7_number)) or
144: (p_meas_type_code = '8' and csd.measure8_number between
145: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure8_number)
146: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure8_number)) or

Line 143: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure7_number)) or

139: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure6_number)
140: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure6_number)) or
141: (p_meas_type_code = '7' and csd.measure7_number between
142: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure7_number)
143: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure7_number)) or
144: (p_meas_type_code = '8' and csd.measure8_number between
145: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure8_number)
146: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure8_number)) or
147: (p_meas_type_code = '9' and csd.measure9_number between

Line 145: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure8_number)

141: (p_meas_type_code = '7' and csd.measure7_number between
142: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure7_number)
143: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure7_number)) or
144: (p_meas_type_code = '8' and csd.measure8_number between
145: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure8_number)
146: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure8_number)) or
147: (p_meas_type_code = '9' and csd.measure9_number between
148: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure9_number)
149: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure9_number)) or

Line 146: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure8_number)) or

142: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure7_number)
143: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure7_number)) or
144: (p_meas_type_code = '8' and csd.measure8_number between
145: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure8_number)
146: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure8_number)) or
147: (p_meas_type_code = '9' and csd.measure9_number between
148: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure9_number)
149: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure9_number)) or
150: (p_meas_type_code = '10' and csd.measure10_number between

Line 148: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure9_number)

144: (p_meas_type_code = '8' and csd.measure8_number between
145: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure8_number)
146: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure8_number)) or
147: (p_meas_type_code = '9' and csd.measure9_number between
148: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure9_number)
149: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure9_number)) or
150: (p_meas_type_code = '10' and csd.measure10_number between
151: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure10_number)
152: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure10_number)) or

Line 149: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure9_number)) or

145: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure8_number)
146: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure8_number)) or
147: (p_meas_type_code = '9' and csd.measure9_number between
148: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure9_number)
149: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure9_number)) or
150: (p_meas_type_code = '10' and csd.measure10_number between
151: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure10_number)
152: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure10_number)) or
153: (p_meas_type_code = '11' and csd.measure11_number between

Line 151: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure10_number)

147: (p_meas_type_code = '9' and csd.measure9_number between
148: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure9_number)
149: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure9_number)) or
150: (p_meas_type_code = '10' and csd.measure10_number between
151: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure10_number)
152: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure10_number)) or
153: (p_meas_type_code = '11' and csd.measure11_number between
154: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure11_number)
155: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure11_number)) or

Line 152: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure10_number)) or

148: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure9_number)
149: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure9_number)) or
150: (p_meas_type_code = '10' and csd.measure10_number between
151: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure10_number)
152: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure10_number)) or
153: (p_meas_type_code = '11' and csd.measure11_number between
154: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure11_number)
155: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure11_number)) or
156: (p_meas_type_code = '12' and csd.measure12_number between

Line 154: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure11_number)

150: (p_meas_type_code = '10' and csd.measure10_number between
151: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure10_number)
152: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure10_number)) or
153: (p_meas_type_code = '11' and csd.measure11_number between
154: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure11_number)
155: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure11_number)) or
156: (p_meas_type_code = '12' and csd.measure12_number between
157: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure12_number)
158: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure12_number)) or

Line 155: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure11_number)) or

151: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure10_number)
152: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure10_number)) or
153: (p_meas_type_code = '11' and csd.measure11_number between
154: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure11_number)
155: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure11_number)) or
156: (p_meas_type_code = '12' and csd.measure12_number between
157: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure12_number)
158: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure12_number)) or
159: (p_meas_type_code = '13' and csd.measure13_number between

Line 157: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure12_number)

153: (p_meas_type_code = '11' and csd.measure11_number between
154: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure11_number)
155: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure11_number)) or
156: (p_meas_type_code = '12' and csd.measure12_number between
157: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure12_number)
158: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure12_number)) or
159: (p_meas_type_code = '13' and csd.measure13_number between
160: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure13_number)
161: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure13_number)) or

Line 158: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure12_number)) or

154: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure11_number)
155: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure11_number)) or
156: (p_meas_type_code = '12' and csd.measure12_number between
157: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure12_number)
158: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure12_number)) or
159: (p_meas_type_code = '13' and csd.measure13_number between
160: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure13_number)
161: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure13_number)) or
162: (p_meas_type_code = '14' and csd.measure14_number between

Line 160: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure13_number)

156: (p_meas_type_code = '12' and csd.measure12_number between
157: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure12_number)
158: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure12_number)) or
159: (p_meas_type_code = '13' and csd.measure13_number between
160: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure13_number)
161: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure13_number)) or
162: (p_meas_type_code = '14' and csd.measure14_number between
163: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure14_number)
164: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure14_number)) or

Line 161: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure13_number)) or

157: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure12_number)
158: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure12_number)) or
159: (p_meas_type_code = '13' and csd.measure13_number between
160: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure13_number)
161: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure13_number)) or
162: (p_meas_type_code = '14' and csd.measure14_number between
163: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure14_number)
164: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure14_number)) or
165: (p_meas_type_code = '15' and csd.measure14_number between

Line 163: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure14_number)

159: (p_meas_type_code = '13' and csd.measure13_number between
160: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure13_number)
161: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure13_number)) or
162: (p_meas_type_code = '14' and csd.measure14_number between
163: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure14_number)
164: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure14_number)) or
165: (p_meas_type_code = '15' and csd.measure14_number between
166: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure15_number)
167: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure15_number)) or

Line 164: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure14_number)) or

160: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure13_number)
161: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure13_number)) or
162: (p_meas_type_code = '14' and csd.measure14_number between
163: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure14_number)
164: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure14_number)) or
165: (p_meas_type_code = '15' and csd.measure14_number between
166: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure15_number)
167: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure15_number)) or
168: (p_meas_type_code = '16' and csd.measure16_number between

Line 166: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure15_number)

162: (p_meas_type_code = '14' and csd.measure14_number between
163: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure14_number)
164: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure14_number)) or
165: (p_meas_type_code = '15' and csd.measure14_number between
166: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure15_number)
167: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure15_number)) or
168: (p_meas_type_code = '16' and csd.measure16_number between
169: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure16_number)
170: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure16_number)) or

Line 167: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure15_number)) or

163: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure14_number)
164: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure14_number)) or
165: (p_meas_type_code = '15' and csd.measure14_number between
166: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure15_number)
167: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure15_number)) or
168: (p_meas_type_code = '16' and csd.measure16_number between
169: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure16_number)
170: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure16_number)) or
171: (p_meas_type_code = '17' and csd.measure17_number between

Line 169: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure16_number)

165: (p_meas_type_code = '15' and csd.measure14_number between
166: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure15_number)
167: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure15_number)) or
168: (p_meas_type_code = '16' and csd.measure16_number between
169: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure16_number)
170: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure16_number)) or
171: (p_meas_type_code = '17' and csd.measure17_number between
172: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure17_number)
173: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure17_number)));

Line 170: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure16_number)) or

166: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure15_number)
167: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure15_number)) or
168: (p_meas_type_code = '16' and csd.measure16_number between
169: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure16_number)
170: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure16_number)) or
171: (p_meas_type_code = '17' and csd.measure17_number between
172: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure17_number)
173: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure17_number)));
174:

Line 172: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure17_number)

168: (p_meas_type_code = '16' and csd.measure16_number between
169: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure16_number)
170: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure16_number)) or
171: (p_meas_type_code = '17' and csd.measure17_number between
172: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure17_number)
173: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure17_number)));
174:
175: l_insert_measure number;
176: l_next_seq number;

Line 173: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure17_number)));

169: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure16_number)
170: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure16_number)) or
171: (p_meas_type_code = '17' and csd.measure17_number between
172: nvl(qpr_transformation.get_num(qtr.level_value_from), csd.measure17_number)
173: and nvl(qpr_transformation.get_num(qtr.level_value_to),csd.measure17_number)));
174:
175: l_insert_measure number;
176: l_next_seq number;
177: l_dummy number;

Line 322: qpr_transformation.get_num(measure_rec.level_value_to),

318: if transf_header_rec.to_dim_code = 'DSB' then
319: update qpr_measure_data
320: set dsb_level_value = transf_header_rec.to_value,
321: measure7_number =
322: qpr_transformation.get_num(measure_rec.level_value_to),
323: measure8_number =
324: qpr_transformation.get_num(measure_rec.level_value_from),
325: last_update_date = sysdate,
326: last_updated_by = fnd_global.user_id,

Line 324: qpr_transformation.get_num(measure_rec.level_value_from),

320: set dsb_level_value = transf_header_rec.to_value,
321: measure7_number =
322: qpr_transformation.get_num(measure_rec.level_value_to),
323: measure8_number =
324: qpr_transformation.get_num(measure_rec.level_value_from),
325: last_update_date = sysdate,
326: last_updated_by = fnd_global.user_id,
327: last_update_login = fnd_global.login_id
328: where measure_value_id = measure_rec.measure_value_id;

Line 333: qpr_transformation.get_num(measure_rec.level_value_to),

329: elsif transf_header_rec.to_dim_code = 'VLB' then
330: update qpr_measure_data
331: set vlb_level_value = transf_header_rec.to_value,
332: measure11_number =
333: qpr_transformation.get_num(measure_rec.level_value_to),
334: measure12_number =
335: qpr_transformation.get_num(measure_rec.level_value_from),
336: measure9_number = measure_rec.measure4_number,
337: measure10_number = measure_rec.measure4_number,

Line 335: qpr_transformation.get_num(measure_rec.level_value_from),

331: set vlb_level_value = transf_header_rec.to_value,
332: measure11_number =
333: qpr_transformation.get_num(measure_rec.level_value_to),
334: measure12_number =
335: qpr_transformation.get_num(measure_rec.level_value_from),
336: measure9_number = measure_rec.measure4_number,
337: measure10_number = measure_rec.measure4_number,
338: last_update_date = sysdate,
339: last_updated_by = fnd_global.user_id,

Line 346: qpr_transformation.get_num(measure_rec.level_value_to),

342: elsif transf_header_rec.to_dim_code = 'MGB' then
343: update qpr_measure_data
344: set mgb_level_value = transf_header_rec.to_value,
345: measure18_number =
346: qpr_transformation.get_num(measure_rec.level_value_to),
347: measure19_number =
348: qpr_transformation.get_num(measure_rec.level_value_from),
349: last_update_date = sysdate,
350: last_updated_by = fnd_global.user_id,

Line 348: qpr_transformation.get_num(measure_rec.level_value_from),

344: set mgb_level_value = transf_header_rec.to_value,
345: measure18_number =
346: qpr_transformation.get_num(measure_rec.level_value_to),
347: measure19_number =
348: qpr_transformation.get_num(measure_rec.level_value_from),
349: last_update_date = sysdate,
350: last_updated_by = fnd_global.user_id,
351: last_update_login = fnd_global.login_id
352: where measure_value_id =

Line 383: 'nvl(b.attribute'||lvl_no||'_number_flag,qpr_transformation.get_n) '||

379: 'and '||
380: '('||
381: '(b.attribute'||lvl_no||'_from is null and b.attribute'||lvl_no||'_to is null) '||
382: 'or ('||
383: 'nvl(b.attribute'||lvl_no||'_number_flag,qpr_transformation.get_n) '||
384: '= qpr_transformation.get_y ' ||
385: 'and nvl(qpr_transformation.get_num(a.level' ||
386: attr_no || '_attribute'||lvl_no||'),0)'||
387: ' between ' ||

Line 384: '= qpr_transformation.get_y ' ||

380: '('||
381: '(b.attribute'||lvl_no||'_from is null and b.attribute'||lvl_no||'_to is null) '||
382: 'or ('||
383: 'nvl(b.attribute'||lvl_no||'_number_flag,qpr_transformation.get_n) '||
384: '= qpr_transformation.get_y ' ||
385: 'and nvl(qpr_transformation.get_num(a.level' ||
386: attr_no || '_attribute'||lvl_no||'),0)'||
387: ' between ' ||
388: 'nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_from), '||

Line 385: 'and nvl(qpr_transformation.get_num(a.level' ||

381: '(b.attribute'||lvl_no||'_from is null and b.attribute'||lvl_no||'_to is null) '||
382: 'or ('||
383: 'nvl(b.attribute'||lvl_no||'_number_flag,qpr_transformation.get_n) '||
384: '= qpr_transformation.get_y ' ||
385: 'and nvl(qpr_transformation.get_num(a.level' ||
386: attr_no || '_attribute'||lvl_no||'),0)'||
387: ' between ' ||
388: 'nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_from), '||
389: 'nvl(qpr_transformation.get_num(a.level' ||

Line 388: 'nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_from), '||

384: '= qpr_transformation.get_y ' ||
385: 'and nvl(qpr_transformation.get_num(a.level' ||
386: attr_no || '_attribute'||lvl_no||'),0)'||
387: ' between ' ||
388: 'nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_from), '||
389: 'nvl(qpr_transformation.get_num(a.level' ||
390: attr_no || '_attribute'||lvl_no||'),0)) '||
391: 'and'||
392: ' nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_to), '||

Line 389: 'nvl(qpr_transformation.get_num(a.level' ||

385: 'and nvl(qpr_transformation.get_num(a.level' ||
386: attr_no || '_attribute'||lvl_no||'),0)'||
387: ' between ' ||
388: 'nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_from), '||
389: 'nvl(qpr_transformation.get_num(a.level' ||
390: attr_no || '_attribute'||lvl_no||'),0)) '||
391: 'and'||
392: ' nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_to), '||
393: 'nvl(qpr_transformation.get_num(a.level' ||

Line 392: ' nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_to), '||

388: 'nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_from), '||
389: 'nvl(qpr_transformation.get_num(a.level' ||
390: attr_no || '_attribute'||lvl_no||'),0)) '||
391: 'and'||
392: ' nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_to), '||
393: 'nvl(qpr_transformation.get_num(a.level' ||
394: attr_no || '_attribute'||lvl_no||'),0)) '||
395: 'or '||
396: 'nvl(b.attribute'||lvl_no||'_number_flag,qpr_transformation.get_n) '||

Line 393: 'nvl(qpr_transformation.get_num(a.level' ||

389: 'nvl(qpr_transformation.get_num(a.level' ||
390: attr_no || '_attribute'||lvl_no||'),0)) '||
391: 'and'||
392: ' nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_to), '||
393: 'nvl(qpr_transformation.get_num(a.level' ||
394: attr_no || '_attribute'||lvl_no||'),0)) '||
395: 'or '||
396: 'nvl(b.attribute'||lvl_no||'_number_flag,qpr_transformation.get_n) '||
397: '= qpr_transformation.get_n ' ||

Line 396: 'nvl(b.attribute'||lvl_no||'_number_flag,qpr_transformation.get_n) '||

392: ' nvl(qpr_transformation.get_num(b.attribute'||lvl_no||'_to), '||
393: 'nvl(qpr_transformation.get_num(a.level' ||
394: attr_no || '_attribute'||lvl_no||'),0)) '||
395: 'or '||
396: 'nvl(b.attribute'||lvl_no||'_number_flag,qpr_transformation.get_n) '||
397: '= qpr_transformation.get_n ' ||
398: 'and nvl(a.level' || attr_no || '_attribute'||lvl_no||
399: ',qpr_transformation.get_null)'||
400: ' between ' ||

Line 397: '= qpr_transformation.get_n ' ||

393: 'nvl(qpr_transformation.get_num(a.level' ||
394: attr_no || '_attribute'||lvl_no||'),0)) '||
395: 'or '||
396: 'nvl(b.attribute'||lvl_no||'_number_flag,qpr_transformation.get_n) '||
397: '= qpr_transformation.get_n ' ||
398: 'and nvl(a.level' || attr_no || '_attribute'||lvl_no||
399: ',qpr_transformation.get_null)'||
400: ' between ' ||
401: 'nvl(b.attribute'||lvl_no||'_from, nvl(a.level' || attr_no ||

Line 399: ',qpr_transformation.get_null)'||

395: 'or '||
396: 'nvl(b.attribute'||lvl_no||'_number_flag,qpr_transformation.get_n) '||
397: '= qpr_transformation.get_n ' ||
398: 'and nvl(a.level' || attr_no || '_attribute'||lvl_no||
399: ',qpr_transformation.get_null)'||
400: ' between ' ||
401: 'nvl(b.attribute'||lvl_no||'_from, nvl(a.level' || attr_no ||
402: '_attribute'||lvl_no||',qpr_transformation.get_null)) ' ||
403: 'and '||

Line 402: '_attribute'||lvl_no||',qpr_transformation.get_null)) ' ||

398: 'and nvl(a.level' || attr_no || '_attribute'||lvl_no||
399: ',qpr_transformation.get_null)'||
400: ' between ' ||
401: 'nvl(b.attribute'||lvl_no||'_from, nvl(a.level' || attr_no ||
402: '_attribute'||lvl_no||',qpr_transformation.get_null)) ' ||
403: 'and '||
404: 'nvl(b.attribute'||lvl_no||'_to, nvl(a.level' || attr_no ||
405: '_attribute'||lvl_no||',qpr_transformation.get_null))'||
406: ') ' ||

Line 405: '_attribute'||lvl_no||',qpr_transformation.get_null))'||

401: 'nvl(b.attribute'||lvl_no||'_from, nvl(a.level' || attr_no ||
402: '_attribute'||lvl_no||',qpr_transformation.get_null)) ' ||
403: 'and '||
404: 'nvl(b.attribute'||lvl_no||'_to, nvl(a.level' || attr_no ||
405: '_attribute'||lvl_no||',qpr_transformation.get_null))'||
406: ') ' ||
407: ') ' ;
408: return(sql1);
409: end;

Line 468: 'nvl(b.level_value_number_flag , qpr_transformation.get_n) '||

464: '('||
465: 'b.level_value_from is null '||
466: 'or ' ||
467: '('||
468: 'nvl(b.level_value_number_flag , qpr_transformation.get_n) '||
469: '= qpr_transformation.get_n and ' ||
470: '((b.level_value_like_flag = qpr_transformation.get_y and '||
471: 'a.level' || cl || '_value like b.level_value_from) ' ||
472: 'or (b.level_value_like_flag = qpr_transformation.get_n '||

Line 469: '= qpr_transformation.get_n and ' ||

465: 'b.level_value_from is null '||
466: 'or ' ||
467: '('||
468: 'nvl(b.level_value_number_flag , qpr_transformation.get_n) '||
469: '= qpr_transformation.get_n and ' ||
470: '((b.level_value_like_flag = qpr_transformation.get_y and '||
471: 'a.level' || cl || '_value like b.level_value_from) ' ||
472: 'or (b.level_value_like_flag = qpr_transformation.get_n '||
473: 'and a.level' || cl || '_value >= b.level_value_from ' ||

Line 470: '((b.level_value_like_flag = qpr_transformation.get_y and '||

466: 'or ' ||
467: '('||
468: 'nvl(b.level_value_number_flag , qpr_transformation.get_n) '||
469: '= qpr_transformation.get_n and ' ||
470: '((b.level_value_like_flag = qpr_transformation.get_y and '||
471: 'a.level' || cl || '_value like b.level_value_from) ' ||
472: 'or (b.level_value_like_flag = qpr_transformation.get_n '||
473: 'and a.level' || cl || '_value >= b.level_value_from ' ||
474: 'and (b.level_value_to is null or ' ||

Line 472: 'or (b.level_value_like_flag = qpr_transformation.get_n '||

468: 'nvl(b.level_value_number_flag , qpr_transformation.get_n) '||
469: '= qpr_transformation.get_n and ' ||
470: '((b.level_value_like_flag = qpr_transformation.get_y and '||
471: 'a.level' || cl || '_value like b.level_value_from) ' ||
472: 'or (b.level_value_like_flag = qpr_transformation.get_n '||
473: 'and a.level' || cl || '_value >= b.level_value_from ' ||
474: 'and (b.level_value_to is null or ' ||
475: 'a.level'||cl||'_value <= b.level_value_to)))'||
476: ')'||

Line 479: 'nvl(b.level_value_number_flag , qpr_transformation.get_n) '||

475: 'a.level'||cl||'_value <= b.level_value_to)))'||
476: ')'||
477: ' or ' ||
478: '('||
479: 'nvl(b.level_value_number_flag , qpr_transformation.get_n) '||
480: '= qpr_transformation.get_y and '||
481: 'qpr_transformation.get_num(a.level' || cl || '_value) >= '||
482: 'qpr_transformation.get_num(b.level_value_from ) and ' ||
483: '(qpr_transformation.get_num(b.level_value_to) is null or '||

Line 480: '= qpr_transformation.get_y and '||

476: ')'||
477: ' or ' ||
478: '('||
479: 'nvl(b.level_value_number_flag , qpr_transformation.get_n) '||
480: '= qpr_transformation.get_y and '||
481: 'qpr_transformation.get_num(a.level' || cl || '_value) >= '||
482: 'qpr_transformation.get_num(b.level_value_from ) and ' ||
483: '(qpr_transformation.get_num(b.level_value_to) is null or '||
484: 'qpr_transformation.get_num(a.level' || cl || '_value) <= '||

Line 481: 'qpr_transformation.get_num(a.level' || cl || '_value) >= '||

477: ' or ' ||
478: '('||
479: 'nvl(b.level_value_number_flag , qpr_transformation.get_n) '||
480: '= qpr_transformation.get_y and '||
481: 'qpr_transformation.get_num(a.level' || cl || '_value) >= '||
482: 'qpr_transformation.get_num(b.level_value_from ) and ' ||
483: '(qpr_transformation.get_num(b.level_value_to) is null or '||
484: 'qpr_transformation.get_num(a.level' || cl || '_value) <= '||
485: 'qpr_transformation.get_num(b.level_value_to))'||

Line 482: 'qpr_transformation.get_num(b.level_value_from ) and ' ||

478: '('||
479: 'nvl(b.level_value_number_flag , qpr_transformation.get_n) '||
480: '= qpr_transformation.get_y and '||
481: 'qpr_transformation.get_num(a.level' || cl || '_value) >= '||
482: 'qpr_transformation.get_num(b.level_value_from ) and ' ||
483: '(qpr_transformation.get_num(b.level_value_to) is null or '||
484: 'qpr_transformation.get_num(a.level' || cl || '_value) <= '||
485: 'qpr_transformation.get_num(b.level_value_to))'||
486: ')'||

Line 483: '(qpr_transformation.get_num(b.level_value_to) is null or '||

479: 'nvl(b.level_value_number_flag , qpr_transformation.get_n) '||
480: '= qpr_transformation.get_y and '||
481: 'qpr_transformation.get_num(a.level' || cl || '_value) >= '||
482: 'qpr_transformation.get_num(b.level_value_from ) and ' ||
483: '(qpr_transformation.get_num(b.level_value_to) is null or '||
484: 'qpr_transformation.get_num(a.level' || cl || '_value) <= '||
485: 'qpr_transformation.get_num(b.level_value_to))'||
486: ')'||
487: ')';

Line 484: 'qpr_transformation.get_num(a.level' || cl || '_value) <= '||

480: '= qpr_transformation.get_y and '||
481: 'qpr_transformation.get_num(a.level' || cl || '_value) >= '||
482: 'qpr_transformation.get_num(b.level_value_from ) and ' ||
483: '(qpr_transformation.get_num(b.level_value_to) is null or '||
484: 'qpr_transformation.get_num(a.level' || cl || '_value) <= '||
485: 'qpr_transformation.get_num(b.level_value_to))'||
486: ')'||
487: ')';
488: sql1_text := sql1_text ||

Line 485: 'qpr_transformation.get_num(b.level_value_to))'||

481: 'qpr_transformation.get_num(a.level' || cl || '_value) >= '||
482: 'qpr_transformation.get_num(b.level_value_from ) and ' ||
483: '(qpr_transformation.get_num(b.level_value_to) is null or '||
484: 'qpr_transformation.get_num(a.level' || cl || '_value) <= '||
485: 'qpr_transformation.get_num(b.level_value_to))'||
486: ')'||
487: ')';
488: sql1_text := sql1_text ||
489: 'and '||

Line 494: 'b.level_value_like_flag = qpr_transformation.get_y '||

490: '('||
491: 'b.level_desc_from is null '||
492: 'or ' ||
493: '('||
494: 'b.level_value_like_flag = qpr_transformation.get_y '||
495: 'and a.level' || cl || '_desc like b.level_desc_from'||
496: ') '||
497: ' or '||
498: '('||

Line 499: 'b.level_value_like_flag=qpr_transformation.get_n and '||

495: 'and a.level' || cl || '_desc like b.level_desc_from'||
496: ') '||
497: ' or '||
498: '('||
499: 'b.level_value_like_flag=qpr_transformation.get_n and '||
500: 'a.level' || cl || '_desc >= b.level_desc_from and ' ||
501: '(b.level_desc_to is null or '||
502: 'a.level' || cl || '_desc <= b.level_desc_to)'||
503: ')'||

Line 619: END QPR_TRANSFORMATION ;

615: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
616:
617: END; --transformation process
618:
619: END QPR_TRANSFORMATION ;