APPS.PJI_REP_MEASURE_UTIL dependencies on PA_PERF_TEMP_OBJ_MEASURE

Line 195: -- DELETE PA_PERF_TEMP_OBJ_MEASURE_debug;

191: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
192:
193:
194: --BEGIN
195: -- DELETE PA_PERF_TEMP_OBJ_MEASURE_debug;
196: -- INSERT INTO PA_PERF_TEMP_OBJ_MEASURE_debug SELECT * FROM PA_PERF_TEMP_OBJ_MEASURE;
197: -- COMMIT;
198: --END;
199:

Line 196: -- INSERT INTO PA_PERF_TEMP_OBJ_MEASURE_debug SELECT * FROM PA_PERF_TEMP_OBJ_MEASURE;

192:
193:
194: --BEGIN
195: -- DELETE PA_PERF_TEMP_OBJ_MEASURE_debug;
196: -- INSERT INTO PA_PERF_TEMP_OBJ_MEASURE_debug SELECT * FROM PA_PERF_TEMP_OBJ_MEASURE;
197: -- COMMIT;
198: --END;
199:
200:

Line 215: pa_perf_temp_obj_measure excp

211: l_project_ids_tbl
212: , l_calendar_type_tbl
213: , l_currency_type_tbl
214: FROM
215: pa_perf_temp_obj_measure excp
216: WHERE 1=1
217: AND excp.object_type = 'PA_PROJECTS';
218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN

Line 232: '(collected from table PA_PERF_TEMP_OBJ_MEASURE) = ' || l_project_ids_tbl.LAST,

228:
229: IF g_debug_mode = 'Y' THEN
230: Pji_Utils.WRITE2LOG(
231: 'PJI_REP_MEASURE_UTIL.compute_proj_perf_exceptions: l_project_ids_tbl.LAST ' ||
232: '(collected from table PA_PERF_TEMP_OBJ_MEASURE) = ' || l_project_ids_tbl.LAST,
233: TRUE, g_msg_level_runtime_info
234: );
235: END IF;
236:

Line 279: pa_perf_temp_obj_measure excp

275: , l_measure_set_codes_tbl
276: , l_xtd_types_tbl
277: , l_measure_values_tbl --will contain the values for the requested measures
278: FROM
279: pa_perf_temp_obj_measure excp
280: , pji_mt_measures_b msrs
281: WHERE 1=1
282: AND excp.object_type = 'PA_PROJECTS'
283: AND msrs.measure_id = excp.measure_id

Line 531: UPDATE pa_perf_temp_obj_measure

527:
528: END LOOP;
529:
530: FORALL j IN 1..l_measure_set_codes_tbl.LAST
531: UPDATE pa_perf_temp_obj_measure
532: SET measure_value = l_measure_values_tbl(j)
533: , period_name = l_period_name
534: WHERE ROWID = CHARTOROWID(l_rowids_tbl(j));
535:

Line 554: --INSERT INTO PA_PERF_TEMP_OBJ_MEASURE_debug SELECT * FROM PA_PERF_TEMP_OBJ_MEASURE;

550: END IF;
551:
552: -- ##########################################################
553: --BEGIN
554: --INSERT INTO PA_PERF_TEMP_OBJ_MEASURE_debug SELECT * FROM PA_PERF_TEMP_OBJ_MEASURE;
555: --COMMIT;
556: --END;
557: -- ##########################################################
558: