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_FORECAST_ITEM_DETAILS

Line 272: UPDATE pa_forecast_item_details A

268: -- rowids available in the temp0 table.
269: -- The local rowid plsql table collects all the rowids
270: -- for which update was successful.
271:
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

Line 330: -- 1. Delete those records from pa_forecast_item_details which have been processed

326: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
327: END IF;
328:
329: -- If the process_method is 'F' (Filter):
330: -- 1. Delete those records from pa_forecast_item_details which have been processed
331: -- i.e. summarised code is 'S' and temp table delete flag is 'N'
332: -- 2. Update the util_summarized_code to NULL for those records which have been processed
333: -- 3. Delete pa_forecat_items (master) records for which processed detail records have been
334: -- deleted and no further detail record exists

Line 337: -- 1. Delete those records from pa_forecast_item_details which have been processed and for

333: -- 3. Delete pa_forecat_items (master) records for which processed detail records have been
334: -- deleted and no further detail record exists
335: --
336: -- If process_method is 'A' (All):
337: -- 1. Delete those records from pa_forecast_item_details which have been processed and for
338: -- for which a record exsists in temp table. i.e. summarised code is 'S'
339: -- and temp table delete flag is 'Y'
340: -- 2. Update the util_summarized_code to NULL for those records which have been processed
341: --

Line 349: PA_DEBUG.G_Err_Stage := '1000 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);

345:
346: IF l_process_method = 'F' THEN
347: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
348: /* Commented for Bug 2984871
349: PA_DEBUG.G_Err_Stage := '1000 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
350: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
351: PA_DEBUG.G_Err_Stage := '1050 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
352: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
353: /*Code Changes for Bug No.2984871 start */

Line 351: PA_DEBUG.G_Err_Stage := '1050 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;

347: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
348: /* Commented for Bug 2984871
349: PA_DEBUG.G_Err_Stage := '1000 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
350: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
351: PA_DEBUG.G_Err_Stage := '1050 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
352: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
353: /*Code Changes for Bug No.2984871 start */
354: PA_DEBUG.G_Err_Stage := '1050 : process method = ' || l_process_method ;
355: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);

Line 359: UPDATE pa_forecast_item_details

355: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
356: /*Code Changes for Bug No.2984871 end */
357: END IF;
358: --
359: UPDATE pa_forecast_item_details
360: SET util_summarized_code = NULL
361: ,last_update_date = l_last_update_date
362: ,last_updated_by = l_last_updated_by
363: ,request_id = l_request_id

Line 373: PA_DEBUG.G_Err_Stage := '1100 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);

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);
374: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
375: PA_DEBUG.G_Err_Stage := '1150 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
376: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
377: END IF;

Line 375: PA_DEBUG.G_Err_Stage := '1150 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;

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);
374: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
375: PA_DEBUG.G_Err_Stage := '1150 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
376: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
377: END IF;
378: --
379: /*

Line 387: PA_DEBUG.G_Err_Stage := '1300 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);

383: --
384: ELSIF l_process_method = 'A' THEN
385: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
386: /* Commented for Bug 2984871
387: PA_DEBUG.G_Err_Stage := '1300 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
388: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
389: PA_DEBUG.G_Err_Stage := '1350 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
390: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
391:

Line 389: PA_DEBUG.G_Err_Stage := '1350 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;

385: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
386: /* Commented for Bug 2984871
387: PA_DEBUG.G_Err_Stage := '1300 : Records Deleted from PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);
388: PA_DEBUG.Log_Message(p_message => pa_debug.G_Err_Stage);
389: PA_DEBUG.G_Err_Stage := '1350 : After deleting from PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
390: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);*/
391:
392: /*Code Changes for Bug No.2984871 start */
393: PA_DEBUG.G_Err_Stage := '1350 : process method = ' || l_process_method ;

Line 398: UPDATE pa_forecast_item_details

394: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
395: /*Code Changes for Bug No.2984871 end */
396: END IF;
397: --
398: UPDATE pa_forecast_item_details
399: SET util_summarized_code = NULL
400: ,last_update_date = l_last_update_date
401: ,last_updated_by = l_last_updated_by
402: ,request_id = l_request_id

Line 411: PA_DEBUG.G_Err_Stage := '1400 : Records Updated in PA_FORECAST_ITEM_DETAILS: ' || to_char(SQL%ROWCOUNT);

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);
413: PA_DEBUG.G_Err_Stage := '1450 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
414: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
415: END IF;

Line 413: PA_DEBUG.G_Err_Stage := '1450 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;

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);
413: PA_DEBUG.G_Err_Stage := '1450 : After Updating PA_FORECAST_ITEM_DETAILS for process method ' || l_process_method ;
414: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
415: END IF;
416: --
417: /*

Line 465: ** The delete statement for pa_forecast_item_details is removed.

461: * which are processed (util_summarized_code is null).
462: */
463: /*
464: ** Bug 2263074
465: ** The delete statement for pa_forecast_item_details is removed.
466: */
467:
468: COMMIT;
469: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 561: ,pa_forecast_item_details fid

557: ,NVL(fid.org_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_org
558: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
559: ,'Y' delete_flag
560: FROM pa_forecast_items fi
561: ,pa_forecast_item_details fid
562: ,gl_periods pp
563: WHERE fi.forecast_item_id = fid.forecast_item_id
564: AND fi.expenditure_org_id = l_org_id
565: AND fid.expenditure_org_id = l_org_id

Line 668: ,pa_forecast_item_details fid

664: ,NVL(fid.org_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_org
665: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
666: ,'Y' delete_flag
667: FROM pa_forecast_items fi
668: ,pa_forecast_item_details fid
669: ,gl_periods gp
670: WHERE fi.forecast_item_id = fid.forecast_item_id
671: AND fi.expenditure_org_id = l_org_id
672: AND fid.expenditure_org_id = l_org_id

Line 775: ,pa_forecast_item_details fid

771: ,NVL(fid.org_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_org
772: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
773: ,'Y' delete_flag
774: FROM pa_forecast_items fi
775: ,pa_forecast_item_details fid
776: WHERE fi.forecast_item_id = fid.forecast_item_id
777: AND fi.expenditure_org_id = l_org_id
778: AND fid.expenditure_org_id = l_org_id
779: AND fi.forecast_item_type IN ('A', 'U')

Line 875: ,pa_forecast_item_details fid

871: ,NVL(fid.org_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_org
872: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
873: ,'Y' delete_flag
874: FROM pa_forecast_items fi
875: ,pa_forecast_item_details fid
876: ,gl_periods pp
877: ,gl_periods gp
878: WHERE fi.forecast_item_id = fid.forecast_item_id
879: AND fi.expenditure_org_id = l_org_id

Line 986: ,pa_forecast_item_details fid

982: ,NVL(fid.org_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_org
983: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
984: ,'Y' delete_flag
985: FROM pa_forecast_items fi
986: ,pa_forecast_item_details fid
987: ,gl_periods pp
988: WHERE fi.forecast_item_id = fid.forecast_item_id
989: AND fi.expenditure_org_id = l_org_id
990: AND fid.expenditure_org_id = l_org_id

Line 1091: ,pa_forecast_item_details fid

1087: ,NVL(fid.org_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_org
1088: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
1089: ,'Y' delete_flag
1090: FROM pa_forecast_items fi
1091: ,pa_forecast_item_details fid
1092: ,gl_periods gp
1093: WHERE fi.forecast_item_id = fid.forecast_item_id
1094: AND fi.expenditure_org_id = l_org_id
1095: AND fid.expenditure_org_id = l_org_id

Line 1195: ,pa_forecast_item_details fid

1191: ,NVL(fid.org_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_org
1192: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
1193: ,'Y' delete_flag
1194: FROM pa_forecast_items fi
1195: ,pa_forecast_item_details fid
1196: ,gl_periods pp
1197: ,gl_periods gp
1198: WHERE fi.forecast_item_id = fid.forecast_item_id
1199: AND fi.expenditure_org_id = l_org_id