126: , prov_wghted_hours_people
127: , prov_wghted_hours_org
128: , reduce_capacity
129: , delete_flag
130: FROM pa_rep_util_summ00_tmp
131: WHERE rownum <= l_fetch_size;
132:
133: --
134: -- Coded as a performance fix by mpuvathi
401: /*
402: * delete the processed data from the intitial temporary workspace
403: */
404:
405: DELETE FROM pa_rep_util_summ00_tmp
406: WHERE row_id IN (SELECT row_id FROM pa_rep_util_summ0_tmp);
407:
408:
409: IF l_debug ='Y'THEN -- bug 2674619
481: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
482: END IF;
483:
484: INSERT
485: INTO pa_rep_util_summ00_tmp(
486: Row_id
487: ,Parent_Row_Id
488: ,Expenditure_Organization_Id
489: ,Person_Id
591: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
592: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
593: END IF;
594: INSERT
595: INTO pa_rep_util_summ00_tmp(
596: Row_id
597: ,Parent_Row_Id
598: ,Expenditure_Organization_Id
599: ,Person_Id
700: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
701: END IF;
702:
703: INSERT
704: INTO pa_rep_util_summ00_tmp(
705: Row_id
706: ,Parent_Row_Id
707: ,Expenditure_Organization_Id
708: ,Person_Id
813: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
814: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
815: END IF;
816: INSERT
817: INTO pa_rep_util_summ00_tmp(
818: Row_id
819: ,Parent_Row_Id
820: ,Expenditure_Organization_Id
821: ,Person_Id
927: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
928: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
929: END IF;
930: INSERT
931: INTO pa_rep_util_summ00_tmp(
932: Row_id
933: ,Parent_Row_Id
934: ,Expenditure_Organization_Id
935: ,Person_Id
1038: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
1039: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1040: END IF;
1041: INSERT
1042: INTO pa_rep_util_summ00_tmp(
1043: Row_id
1044: ,Parent_Row_Id
1045: ,Expenditure_Organization_Id
1046: ,Person_Id
1156: PA_DEBUG.g_err_stage := '205: Before inserting recs into Temp Table';
1157: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
1158: END IF;
1159: INSERT
1160: INTO pa_rep_util_summ00_tmp(
1161: Row_id
1162: ,Parent_Row_Id
1163: ,Expenditure_Organization_Id
1164: ,Person_Id