APPS.PA_PERF_EXCP_UTILS dependencies on PA_PERF_EXCP_MSR_TEMP

Line 413: FROM PA_PERF_EXCP_MSR_TEMP

409:
410: CURSOR get_measure_index(l_measure_id IN NUMBER)
411: IS
412: SELECT measure_index
413: FROM PA_PERF_EXCP_MSR_TEMP
414: WHERE measure_id= l_measure_id;
415:
416: l_ret VARCHAR2(1);
417: j BINARY_INTEGER;

Line 449: For perfmance issue now using a global temporary table PA_PERF_EXCP_MSR_TEMP

445: /* Code added for bug#3894113, ends here */
446:
447: /*
448: Code fix for BUG#:4053713 starts
449: For perfmance issue now using a global temporary table PA_PERF_EXCP_MSR_TEMP
450: In this table we are storing the measure ids and their corresponding index in
451: the table type parameter p_measure_id.
452: This is required for using the bulk fetch instead of the cursor get_indicator
453: */

Line 455: --Purging the previous data from PA_PERF_EXCP_MSR_TEMP, if any

451: the table type parameter p_measure_id.
452: This is required for using the bulk fetch instead of the cursor get_indicator
453: */
454:
455: --Purging the previous data from PA_PERF_EXCP_MSR_TEMP, if any
456: delete from PA_PERF_EXCP_MSR_TEMP;
457:
458: --Inserting the measure id and thier corresponding index in p_measure_id parameter in the temporary table
459: FOR i IN p_measure_id.FIRST..p_measure_id.LAST LOOP

Line 456: delete from PA_PERF_EXCP_MSR_TEMP;

452: This is required for using the bulk fetch instead of the cursor get_indicator
453: */
454:
455: --Purging the previous data from PA_PERF_EXCP_MSR_TEMP, if any
456: delete from PA_PERF_EXCP_MSR_TEMP;
457:
458: --Inserting the measure id and thier corresponding index in p_measure_id parameter in the temporary table
459: FOR i IN p_measure_id.FIRST..p_measure_id.LAST LOOP
460: INSERT INTO PA_PERF_EXCP_MSR_TEMP(measure_index,measure_id)

Line 460: INSERT INTO PA_PERF_EXCP_MSR_TEMP(measure_index,measure_id)

456: delete from PA_PERF_EXCP_MSR_TEMP;
457:
458: --Inserting the measure id and thier corresponding index in p_measure_id parameter in the temporary table
459: FOR i IN p_measure_id.FIRST..p_measure_id.LAST LOOP
460: INSERT INTO PA_PERF_EXCP_MSR_TEMP(measure_index,measure_id)
461: VALUES(to_number(i),p_measure_id(i));
462: END LOOP;
463:
464: -- Executing the bulk fetch query to get the indicators icon

Line 473: AND ppt.measure_id in (select measure_id from PA_PERF_EXCP_MSR_TEMP)

469: AND ppt.perf_txn_obj_id = p_object_id
470: AND ppt.period_TYPE = Nvl(p_period_type, ppt.period_type)
471: AND nvl(ppt.period_name, '-9999')
472: = Nvl(p_period_name, '-9999')
473: AND ppt.measure_id in (select measure_id from PA_PERF_EXCP_MSR_TEMP)
474: AND ppt.current_flag = 'Y'
475: AND ppt.indicator_code = pl.lookup_code
476: AND pl.lookup_type = 'PA_PERF_INDICATORS'
477: ;

Line 483: --which we have stored in the PA_PERF_EXCP_MSR_TEMP.MEASURE_INDEX

479: if l_meaure_id_tbl.count > 0 then
480: FOR k IN l_meaure_id_tbl.FIRST..l_meaure_id_tbl.LAST loop
481:
482: --Fetching the index of the measure_id in the parameter p_measure_id
483: --which we have stored in the PA_PERF_EXCP_MSR_TEMP.MEASURE_INDEX
484: --This is required as we need to l_indicators the icon name corresponding to the measure
485: --in l_indicators at the same index as the index of the measure id in the input parameter p_measure_id
486: open get_measure_index(l_meaure_id_tbl(k));
487: fetch get_measure_index into j;