DBA Data[Home] [Help]

APPS.PA_SUMMARIZE_FORECAST_UTIL_PVT dependencies on PA_REP_UTIL_SUMM00_TMP

Line 126: FROM pa_rep_util_summ00_tmp

122: , prov_wghted_hours_people
123: , prov_wghted_hours_org
124: , reduce_capacity
125: , delete_flag
126: FROM pa_rep_util_summ00_tmp
127: WHERE rownum <= l_fetch_size;
128:
129: --
130: -- Coded as a performance fix by mpuvathi

Line 424: delete from pa_rep_util_summ00_tmp

420: */
421: --
422: END IF;
423: -- mpuvathi
424: delete from pa_rep_util_summ00_tmp
425: where row_id in (select row_id from pa_rep_util_summ0_tmp)
426: ;
427: -- mpuvathi
428: COMMIT;

Line 500: INSERT INTO pa_rep_util_summ00_tmp

496: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PA');
497: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
498: PA_DEBUG.G_Err_Stage := '2000 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA';
499: END IF;
500: INSERT INTO pa_rep_util_summ00_tmp
501: ( row_id
502: ,parent_row_id
503: ,expenditure_organization_id
504: ,person_id

Line 607: INSERT INTO pa_rep_util_summ00_tmp

603: PA_DEBUG.G_Err_Stage := '2100 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL';
604: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
605: END IF;
606:
607: INSERT INTO pa_rep_util_summ00_tmp
608: ( row_id
609: ,parent_row_id
610: ,expenditure_organization_id
611: ,person_id

Line 714: INSERT INTO pa_rep_util_summ00_tmp

710: PA_DEBUG.G_Err_Stage := '2200 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GE';
711: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
712: END IF;
713:
714: INSERT INTO pa_rep_util_summ00_tmp
715: ( row_id
716: ,parent_row_id
717: ,expenditure_organization_id
718: ,person_id

Line 814: INSERT INTO pa_rep_util_summ00_tmp

810: PA_DEBUG.G_Err_Stage := '2300 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GL';
811: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
812: END IF;
813:
814: INSERT INTO pa_rep_util_summ00_tmp
815: ( row_id
816: ,parent_row_id
817: ,expenditure_organization_id
818: ,person_id

Line 925: INSERT INTO pa_rep_util_summ00_tmp

921: PA_DEBUG.G_Err_Stage := '2400 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GE';
922: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
923: END IF;
924:
925: INSERT INTO pa_rep_util_summ00_tmp
926: ( row_id
927: ,parent_row_id
928: ,expenditure_organization_id
929: ,person_id

Line 1030: INSERT INTO pa_rep_util_summ00_tmp

1026: PA_DEBUG.G_Err_Stage := '2500 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL and GE';
1027: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1028: END IF;
1029:
1030: INSERT INTO pa_rep_util_summ00_tmp
1031: ( row_id
1032: ,parent_row_id
1033: ,expenditure_organization_id
1034: ,person_id

Line 1134: INSERT INTO pa_rep_util_summ00_tmp

1130: PA_DEBUG.G_Err_Stage := '2600 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA, GL and GE';
1131: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1132: END IF;
1133:
1134: INSERT INTO pa_rep_util_summ00_tmp
1135: ( row_id
1136: ,parent_row_id
1137: ,expenditure_organization_id
1138: ,person_id