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.PA_SUMMARIZE_FORECAST_UTIL_PVT dependencies on PA_REP_UTIL_SUMM0_TMP

Line 66: INTO pa_rep_util_summ0_tmp

62: -- Starts here
63: --
64:
65: INSERT
66: INTO pa_rep_util_summ0_tmp
67: ( row_id
68: , parent_row_id
69: , expenditure_organization_id
70: , person_id

Line 276: FROM pa_rep_util_summ0_tmp B

272: UPDATE pa_forecast_item_details A
273: SET util_summarized_code = 'S'
274: WHERE util_summarized_code = 'N'
275: AND exists ( SELECT row_id
276: FROM pa_rep_util_summ0_tmp B
277: WHERE A.ROWID = B.ROW_ID -- bug 3132246
278: )
279: RETURNING ROWID BULK COLLECT INTO l_fid_rowid_tab;
280:

Line 290: -- id not process_method = 'F'(FILTER - will be based on the PA_REP_UTIL_SUMM0_TMP.delete_flag).

286:
287: -- Check if the all the Forecast_Item_Detail records corresponding to the
288: -- those in temp0 have been updated with util_summarized_code = 'S'.
289: -- If YES, process_method = 'A' (ALL)
290: -- id not process_method = 'F'(FILTER - will be based on the PA_REP_UTIL_SUMM0_TMP.delete_flag).
291: -- The delete flag in pa_rep_util_summ0_tmp is initialized
292: -- to 'Y' when first inserted. But if update of util_summarized_code = 'S'
293: -- is successful, for those records, delete_flag of their corresponding records in temp table
294: -- are updated to 'N' - meaning that, those records SHOULD be processed and hence

Line 291: -- The delete flag in pa_rep_util_summ0_tmp is initialized

287: -- Check if the all the Forecast_Item_Detail records corresponding to the
288: -- those in temp0 have been updated with util_summarized_code = 'S'.
289: -- If YES, process_method = 'A' (ALL)
290: -- id not process_method = 'F'(FILTER - will be based on the PA_REP_UTIL_SUMM0_TMP.delete_flag).
291: -- The delete flag in pa_rep_util_summ0_tmp is initialized
292: -- to 'Y' when first inserted. But if update of util_summarized_code = 'S'
293: -- is successful, for those records, delete_flag of their corresponding records in temp table
294: -- are updated to 'N' - meaning that, those records SHOULD be processed and hence
295: -- to be considered as NOT deleted.

Line 303: UPDATE pa_rep_util_summ0_tmp tmp

299:
300: IF (l_records_updated < l_records_inserted AND l_fid_rowid_tab.COUNT > 0) THEN /* added second condition 2084888 */
301: l_process_method := 'F';
302: FORALL i IN l_fid_rowid_tab.FIRST .. l_fid_rowid_tab.LAST
303: UPDATE pa_rep_util_summ0_tmp tmp
304: SET tmp.delete_flag = 'N'
305: WHERE tmp.row_id = l_fid_rowid_tab(i);
306: END IF;
307:

Line 369: FROM pa_rep_util_summ0_tmp

365: ,program_id = l_program_id
366: ,program_update_date = l_program_update_date
367: WHERE util_summarized_code = 'S' -- Do we require this?
368: AND ROWID IN (SELECT row_id
369: FROM pa_rep_util_summ0_tmp
370: WHERE delete_flag = 'N'
371: );
372: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
373: PA_DEBUG.G_Err_Stage := '1100 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);

Line 408: FROM pa_rep_util_summ0_tmp

404: ,program_id = l_program_id
405: ,program_update_date = l_program_update_date
406: WHERE util_summarized_code = 'S' -- Do we require this?
407: AND ROWID IN (SELECT row_id
408: FROM pa_rep_util_summ0_tmp
409: );
410: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
411: PA_DEBUG.G_Err_Stage := '1400 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
412: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);

Line 425: where row_id in (select row_id from pa_rep_util_summ0_tmp)

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;
429: END LOOP;

Line 498: PA_DEBUG.G_Err_Stage := '2000 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA';

494: BEGIN
495: -- Set the error stack
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

Line 580: PA_DEBUG.G_Err_Stage := '2050 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA';

576:
577: commit;
578: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
579: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
580: PA_DEBUG.G_Err_Stage := '2050 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA';
581: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
582: END IF;
583:
584: -- Reset the error stack

Line 603: PA_DEBUG.G_Err_Stage := '2100 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL';

599: BEGIN
600: -- Set the error satack
601: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GL');
602: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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

Line 686: PA_DEBUG.G_Err_Stage := '2150 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL';

682: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999 ; /* BUG# 3118592 */
683:
684:
685: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
686: PA_DEBUG.G_Err_Stage := '2150 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL';
687: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
688: END IF;
689:
690: -- Reset the error stack

Line 710: PA_DEBUG.G_Err_Stage := '2200 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GE';

706: -- Set the error satack
707: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GE');
708:
709: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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

Line 786: PA_DEBUG.G_Err_Stage := '2250 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GE';

782: AND fid.amount_type_id = l_quantity_id
783: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999; /* BUG# 3118592 */
784:
785: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
786: PA_DEBUG.G_Err_Stage := '2250 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GE';
787: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
788: END IF;
789:
790: -- Reset the error stack

Line 810: PA_DEBUG.G_Err_Stage := '2300 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GL';

806: -- Set the error satack
807: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGL');
808:
809: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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

Line 897: PA_DEBUG.G_Err_Stage := '2350 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GL';

893: --AND fi.pvdr_period_set_name = gp.period_set_name /* commented for bug 3488229 */
894: AND fi.pvdr_gl_period_name = gp.period_name
895: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999 ; /* BUG# 3118592 */
896: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
897: PA_DEBUG.G_Err_Stage := '2350 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GL';
898: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
899: END IF;
900:
901: -- Reset the error stack

Line 921: PA_DEBUG.G_Err_Stage := '2400 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GE';

917: -- Set the error satack
918: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGE');
919:
920: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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

Line 1002: PA_DEBUG.G_Err_Stage := '2450 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GE';

998: --AND fi.pvdr_period_set_name = pp.period_set_name /* commented for bug 3488229 */
999: AND fi.pvdr_pa_period_name = pp.period_name
1000: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999 ; /* BUG# 3118592 */
1001: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1002: PA_DEBUG.G_Err_Stage := '2450 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA and GE';
1003: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1004: END IF;
1005:
1006: -- Reset the error stack

Line 1026: PA_DEBUG.G_Err_Stage := '2500 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL and GE';

1022: -- Set the error satack
1023: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_GLGE');
1024:
1025: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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

Line 1107: PA_DEBUG.G_Err_Stage := '2550 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL and GE';

1103: --AND fi.pvdr_period_set_name = gp.period_set_name /* commented for bug 3488229 */
1104: AND fi.pvdr_gl_period_name = gp.period_name
1105: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999; /* BUG# 3118592 */
1106: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1107: PA_DEBUG.G_Err_Stage := '2550 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for GL and GE';
1108: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1109: END IF;
1110:
1111: -- Reset the error stack

Line 1130: PA_DEBUG.G_Err_Stage := '2600 : Before Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA, GL and GE';

1126: BEGIN
1127: -- Set the error satack
1128: PA_DEBUG.Set_Curr_Function( p_function => 'Insert_Fcst_Into_Tmp_PAGLGE');
1129: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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

Line 1218: PA_DEBUG.G_Err_Stage := '2650 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA, GL and GE';

1214: AND fi.pvdr_gl_period_name = gp.period_name
1215: AND fi.item_date BETWEEN l_fc_start_date AND TRUNC(l_fc_end_date)+0.99999 ; /* BUG# 3118592 */
1216:
1217: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1218: PA_DEBUG.G_Err_Stage := '2650 : After Inserting Forecast data into PA_REP_UTIL_SUMM0_TMP for PA, GL and GE';
1219: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
1220: END IF;
1221:
1222: -- Reset the error stack