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_ITEMS

Line 283: PA_DEBUG.G_Err_Stage := '800 : Records Updated in PA_FORECAST_ITEMS_DETAILS : '|| l_records_updated;

279: RETURNING ROWID BULK COLLECT INTO l_fid_rowid_tab;
280:
281: l_records_updated := SQL%ROWCOUNT;
282: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
283: PA_DEBUG.G_Err_Stage := '800 : Records Updated in PA_FORECAST_ITEMS_DETAILS : '|| l_records_updated;
284: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
285: END IF;
286:
287: -- Check if the all the Forecast_Item_Detail records corresponding to the

Line 381: ** The delete statement for pa_forecast_items is removed.

377: END IF;
378: --
379: /*
380: ** Bug 2263074
381: ** The delete statement for pa_forecast_items is removed.
382: */
383: --
384: ELSIF l_process_method = 'A' THEN
385: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 419: ** The delete statement for pa_forecast_items is removed.

415: END IF;
416: --
417: /*
418: ** Bug 2263074
419: ** The delete statement for pa_forecast_items is removed.
420: */
421: --
422: END IF;
423: -- mpuvathi

Line 560: FROM pa_forecast_items fi

556: ,NVL(fid.resource_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_people
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

Line 667: FROM pa_forecast_items fi

663: ,NVL(fid.resource_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_people
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

Line 774: FROM pa_forecast_items fi

770: ,NVL(fid.resource_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_people
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

Line 874: FROM pa_forecast_items fi

870: ,NVL(fid.resource_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_people
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

Line 985: FROM pa_forecast_items fi

981: ,NVL(fid.resource_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_people
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

Line 1090: FROM pa_forecast_items fi

1086: ,NVL(fid.resource_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_people
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

Line 1194: FROM pa_forecast_items fi

1190: ,NVL(fid.resource_util_weighted, 0) * decode(fid.provisional_flag, 'Y', 1, 0) prov_wghted_hours_people
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