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_FORECAST_HDR_PKG dependencies on PA_FORECAST_ITEMS

Line 6: -- This procedure will insert the record in pa_forecast_items table

2: --/* $Header: PARFFIHB.pls 120.2 2005/08/19 16:51:21 mwasowic noship $ */
3: l_empty_tab_record EXCEPTION; -- Variable to raise the exception if the passing table of records is empty
4:
5:
6: -- This procedure will insert the record in pa_forecast_items table
7: -- Input parameters
8: -- Parameters Type Required Description
9: -- P_Forecast_Hdr_Tab FIHDRTABTYP YES It contains the forecast items record for header
10: --

Line 69: l_tmp_forecast_item_type pa_forecast_items.forecast_item_type%TYPE;

65: -- added for Bug Fix 4537865
66: l_new_msg_data VARCHAR2(2000);
67: -- added for Bug Fix 4537865
68: /* Bug 2390990 Begin */
69: l_tmp_forecast_item_type pa_forecast_items.forecast_item_type%TYPE;
70: l_start_date_found BOOLEAN;
71: l_end_date_found BOOLEAN;
72: l_start_date pa_forecast_items.item_date%TYPE;
73: l_end_date pa_forecast_items.item_date%TYPE;

Line 72: l_start_date pa_forecast_items.item_date%TYPE;

68: /* Bug 2390990 Begin */
69: l_tmp_forecast_item_type pa_forecast_items.forecast_item_type%TYPE;
70: l_start_date_found BOOLEAN;
71: l_end_date_found BOOLEAN;
72: l_start_date pa_forecast_items.item_date%TYPE;
73: l_end_date pa_forecast_items.item_date%TYPE;
74: l_token VARCHAR2(1000);
75: l_fi_rejected_prd_missing EXCEPTION;
76: /* Bug 2390990 End */

Line 73: l_end_date pa_forecast_items.item_date%TYPE;

69: l_tmp_forecast_item_type pa_forecast_items.forecast_item_type%TYPE;
70: l_start_date_found BOOLEAN;
71: l_end_date_found BOOLEAN;
72: l_start_date pa_forecast_items.item_date%TYPE;
73: l_end_date pa_forecast_items.item_date%TYPE;
74: l_token VARCHAR2(1000);
75: l_fi_rejected_prd_missing EXCEPTION;
76: /* Bug 2390990 End */
77:

Line 256: INSERT INTO PA_FORECAST_ITEMS

252:
253:
254: PA_FORECASTITEM_PVT.print_message('act ins ');
255: FORALL l_j IN p_forecast_hdr_tab.FIRST..p_forecast_hdr_tab.LAST
256: INSERT INTO PA_FORECAST_ITEMS
257: (
258: forecast_item_id ,
259: forecast_item_type ,
260: project_org_id ,

Line 368: -- PA_FORECAST_ITEMS_UTLS.log_message('end of the forecast inser row .... ');

364: fnd_global.conc_program_id() ,
365: trunc(sysdate) ,
366: 'N');
367:
368: -- PA_FORECAST_ITEMS_UTLS.log_message('end of the forecast inser row .... ');
369: PA_DEBUG.Reset_Err_Stack;
370: EXCEPTION
371: WHEN l_empty_tab_record THEN
372: NULL;

Line 424: -- PA_FORECAST_ITEMS_UTLS.log_message('ERROR ....'||sqlerrm);

420: p_procedure_name => PA_DEBUG.G_Err_Stack);
421:
422: RAISE;
423:
424: -- PA_FORECAST_ITEMS_UTLS.log_message('ERROR ....'||sqlerrm);
425: END insert_rows;
426:
427: -- This procedure will update the record in pa_forecast_items table
428: -- Input parameters

Line 427: -- This procedure will update the record in pa_forecast_items table

423:
424: -- PA_FORECAST_ITEMS_UTLS.log_message('ERROR ....'||sqlerrm);
425: END insert_rows;
426:
427: -- This procedure will update the record in pa_forecast_items table
428: -- Input parameters
429: -- Parameters Type Required Description
430: -- P_Forecast_Hdr_Tab FIHDRTABTYP YES It contains the forecast items record for header
431: --

Line 490: l_tmp_forecast_item_type pa_forecast_items.forecast_item_type%TYPE;

486: -- added for bug 4537865
487: l_new_msg_data VARCHAR2(2000);
488: -- added for bug 4537865
489: /* Bug 2390990 Begin */
490: l_tmp_forecast_item_type pa_forecast_items.forecast_item_type%TYPE;
491: l_start_date_found BOOLEAN;
492: l_end_date_found BOOLEAN;
493: l_start_date pa_forecast_items.item_date%TYPE;
494: l_end_date pa_forecast_items.item_date%TYPE;

Line 493: l_start_date pa_forecast_items.item_date%TYPE;

489: /* Bug 2390990 Begin */
490: l_tmp_forecast_item_type pa_forecast_items.forecast_item_type%TYPE;
491: l_start_date_found BOOLEAN;
492: l_end_date_found BOOLEAN;
493: l_start_date pa_forecast_items.item_date%TYPE;
494: l_end_date pa_forecast_items.item_date%TYPE;
495: l_token VARCHAR2(1000);
496: l_fi_rejected_prd_missing EXCEPTION;
497: /* Bug 2390990 End */

Line 494: l_end_date pa_forecast_items.item_date%TYPE;

490: l_tmp_forecast_item_type pa_forecast_items.forecast_item_type%TYPE;
491: l_start_date_found BOOLEAN;
492: l_end_date_found BOOLEAN;
493: l_start_date pa_forecast_items.item_date%TYPE;
494: l_end_date pa_forecast_items.item_date%TYPE;
495: l_token VARCHAR2(1000);
496: l_fi_rejected_prd_missing EXCEPTION;
497: /* Bug 2390990 End */
498:

Line 675: UPDATE PA_FORECAST_ITEMS

671:
672: END LOOP;
673:
674: FORALL l_J IN p_forecast_hdr_tab.FIRST..p_forecast_hdr_tab.LAST
675: UPDATE PA_FORECAST_ITEMS
676: SET
677: forecast_item_type = l_forecast_item_type(l_j) ,
678: project_org_id = l_project_org_id(l_j) ,
679: expenditure_org_id = l_expenditure_org_id(l_j) ,

Line 881: update pa_forecast_items

877: l_msg_index_out NUMBER;
878: l_new_msg_data VARCHAR2(2000);
879:
880: BEGIN
881: update pa_forecast_items
882: set
883: forecast_amt_calc_flag = 'N'
884: where assignment_id = p_assignment_id;
885: