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_FP_WEBADI_PKG dependencies on PA_PLSQL_DATATYPES

Line 6210: l_amt_typs_to_be_populated_tbl pa_plsql_datatypes.char30TabTyp;

6206: l_module_name VARCHAR2(100):='PAFPWAPB.get_total_fcst_amounts';
6207:
6208: --End of variables used for debugging
6209: l_varchar_index VARCHAR2(50);
6210: l_amt_typs_to_be_populated_tbl pa_plsql_datatypes.char30TabTyp;
6211: l_amt_typ_index NUMBER;
6212: l_amt_exists_flag VARCHAR2(1);
6213: l_existing_fcst_amount NUMBER;
6214: l_existing_etc_amount NUMBER;

Line 6219: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;

6215: l_entered_fcst_amount NUMBER;
6216: l_entered_etc_amount NUMBER;
6217: l_total_amount NUMBER;
6218: l_index NUMBER;
6219: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;
6220: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6221: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6222: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6223: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;

Line 6220: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;

6216: l_entered_etc_amount NUMBER;
6217: l_total_amount NUMBER;
6218: l_index NUMBER;
6219: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;
6220: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6221: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6222: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6223: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6224: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;

Line 6221: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;

6217: l_total_amount NUMBER;
6218: l_index NUMBER;
6219: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;
6220: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6221: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6222: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6223: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6224: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6225: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;

Line 6222: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;

6218: l_index NUMBER;
6219: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;
6220: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6221: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6222: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6223: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6224: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6225: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6226: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;

Line 6223: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;

6219: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;
6220: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6221: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6222: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6223: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6224: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6225: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6226: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6227: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;

Line 6224: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;

6220: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6221: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6222: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6223: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6224: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6225: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6226: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6227: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6228: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;

Line 6225: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;

6221: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6222: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6223: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6224: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6225: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6226: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6227: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6228: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;
6229: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;

Line 6226: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;

6222: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6223: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6224: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6225: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6226: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6227: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6228: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;
6229: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;
6230: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- cbs enhancement changes bug#16445106

Line 6227: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;

6223: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6224: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6225: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6226: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6227: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6228: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;
6229: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;
6230: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- cbs enhancement changes bug#16445106
6231: BEGIN

Line 6228: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;

6224: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6225: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6226: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6227: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6228: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;
6229: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;
6230: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- cbs enhancement changes bug#16445106
6231: BEGIN
6232: x_msg_count := 0;

Line 6229: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;

6225: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6226: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6227: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6228: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;
6229: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;
6230: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- cbs enhancement changes bug#16445106
6231: BEGIN
6232: x_msg_count := 0;
6233: x_return_status := FND_API.G_RET_STS_SUCCESS;