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

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

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

Line 69: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');

65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: /* Checking for the empty table of record */
68: IF (p_forecast_dtls_tab.count = 0 ) THEN
69: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');
70: RAISE l_empty_tab_record;
71: END IF;
72:
73: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');

Line 73: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');

69: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');
70: RAISE l_empty_tab_record;
71: END IF;
72:
73: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');
74:
75: FOR l_J IN p_forecast_dtls_tab.FIRST..p_forecast_dtls_tab.LAST LOOP
76: l_forecast_item_id(l_j) := p_forecast_dtls_tab(l_j).forecast_item_id;
77: l_amount_type_id(l_j) := p_forecast_dtls_tab(l_j).amount_type_id;

Line 177: -- Start Bug 2592045: Need to select expenditure_organization_id from pa_forecast_items table

173: request_id ,
174: program_application_id ,
175: program_id ,
176: program_update_date )
177: -- Start Bug 2592045: Need to select expenditure_organization_id from pa_forecast_items table
178: select
179: -- End Bug 2592045
180: l_forecast_item_id(l_j) ,
181: l_amount_type_id(l_j) ,

Line 200: -- Start Bug 2592045: Need to select expenditure_organization_id from pa_forecast_items table

196: l_PROVISIONAL_QTY(l_j) ,
197: l_JOB_ID(l_j) ,
198: l_PROJECT_ID(l_j) ,
199: l_RESOURCE_ID(l_j) ,
200: -- Start Bug 2592045: Need to select expenditure_organization_id from pa_forecast_items table
201: expenditure_organization_id,
202: --l_EXPENDITURE_ORGANIZATION_ID(l_j) ,
203: -- End Bug 2592045
204: l_pvdr_acct_curr_code(l_j) ,

Line 236: from pa_forecast_items fi

232: fnd_global.prog_appl_id () ,
233: fnd_global.conc_program_id() ,
234: trunc(sysdate)
235: -- Start Bug 2592045: Finish select statement.
236: from pa_forecast_items fi
237: where fi.forecast_item_id = l_forecast_item_id(l_j);
238: -- End Bug 2592045
239:
240: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');

Line 240: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');

236: from pa_forecast_items fi
237: where fi.forecast_item_id = l_forecast_item_id(l_j);
238: -- End Bug 2592045
239:
240: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');
241: PA_DEBUG.Reset_Err_Stack;
242: EXCEPTION
243: WHEN l_empty_tab_record THEN
244: NULL;

Line 255: PA_FORECAST_ITEMS_UTILS.log_message('ERROR ....'||sqlerrm);

251: p_procedure_name => PA_DEBUG.G_Err_Stack);
252:
253: RAISE;
254:
255: PA_FORECAST_ITEMS_UTILS.log_message('ERROR ....'||sqlerrm);
256: END insert_rows;
257:
258: -- This procedure will update the record in pa_forecast_items table
259: -- Input parameters

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

254:
255: PA_FORECAST_ITEMS_UTILS.log_message('ERROR ....'||sqlerrm);
256: END insert_rows;
257:
258: -- This procedure will update the record in pa_forecast_items table
259: -- Input parameters
260: -- Parameters Type Required Description
261: -- P_Forecast_Dtls_Tab FIHDRTABTYP YES It contains the forecast items record for details
262: --

Line 321: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');

317: x_return_status := FND_API.G_RET_STS_SUCCESS;
318:
319: /* Checking for the empty table of record */
320: IF (p_forecast_dtls_tab.count = 0 ) THEN
321: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');
322: RAISE l_empty_tab_record;
323: END IF;
324:
325: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');

Line 325: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');

321: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');
322: RAISE l_empty_tab_record;
323: END IF;
324:
325: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');
326:
327: FOR l_j IN p_forecast_dtls_tab.FIRST..p_forecast_dtls_tab.LAST LOOP
328: l_forecast_item_id(l_j) := p_forecast_dtls_tab(l_j).forecast_item_id;
329: l_amount_type_id(l_j) := p_forecast_dtls_tab(l_j).amount_type_id;

Line 400: (select expenditure_organization_id from pa_forecast_items fi

396: RESOURCE_ID = l_RESOURCE_ID(l_j) ,
397: -- Start Bug 2592045
398: --EXPENDITURE_ORGANIZATION_ID = l_EXPENDITURE_ORGANIZATION_ID(l_j) ,
399: EXPENDITURE_ORGANIZATION_ID =
400: (select expenditure_organization_id from pa_forecast_items fi
401: where fi.forecast_item_id = l_forecast_item_id(l_j)),
402: -- End Bug 2592045
403: pvdr_acct_curr_code = l_pvdr_acct_curr_code(l_j) ,
404: pvdr_acct_amount = l_pvdr_acct_amount(l_j) ,

Line 431: PA_FORECAST_ITEMS_UTILS.log_message('end of update row .... ');

427: last_update_login = fnd_global.login_id
428: WHERE forecast_item_id = l_forecast_item_id(l_j)
429: AND line_num = l_line_num(l_j);
430:
431: PA_FORECAST_ITEMS_UTILS.log_message('end of update row .... ');
432: PA_DEBUG.Reset_Err_Stack;
433: EXCEPTION
434: WHEN l_empty_tab_record THEN
435: NULL;

Line 445: PA_FORECAST_ITEMS_UTILS.log_message('ERROR in update row '||sqlerrm);

441: (p_pkg_name => 'PA_FORECAST_DTLS_PKG.Update_Rows',
442: p_procedure_name => PA_DEBUG.G_Err_Stack);
443: RAISE;
444:
445: PA_FORECAST_ITEMS_UTILS.log_message('ERROR in update row '||sqlerrm);
446: END update_rows;
447:
448: END PA_FORECAST_DTLS_PKG;