DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_PLSQL_DATATYPES

Line 6116: l_amt_typs_to_be_populated_tbl pa_plsql_datatypes.char30TabTyp;

6112: l_module_name VARCHAR2(100):='PAFPWAPB.get_total_fcst_amounts';
6113:
6114: --End of variables used for debugging
6115: l_varchar_index VARCHAR2(50);
6116: l_amt_typs_to_be_populated_tbl pa_plsql_datatypes.char30TabTyp;
6117: l_amt_typ_index NUMBER;
6118: l_amt_exists_flag VARCHAR2(1);
6119: l_existing_fcst_amount NUMBER;
6120: l_existing_etc_amount NUMBER;

Line 6125: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;

6121: l_entered_fcst_amount NUMBER;
6122: l_entered_etc_amount NUMBER;
6123: l_total_amount NUMBER;
6124: l_index NUMBER;
6125: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;
6126: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6127: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6128: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6129: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;

Line 6126: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;

6122: l_entered_etc_amount NUMBER;
6123: l_total_amount NUMBER;
6124: l_index NUMBER;
6125: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;
6126: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6127: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6128: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6129: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6130: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;

Line 6127: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;

6123: l_total_amount NUMBER;
6124: l_index NUMBER;
6125: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;
6126: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6127: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6128: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6129: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6130: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6131: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;

Line 6128: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;

6124: l_index NUMBER;
6125: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;
6126: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6127: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6128: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6129: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6130: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6131: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6132: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;

Line 6129: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;

6125: l_fcst_qty_tbl pa_plsql_datatypes.numTabTyp;
6126: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6127: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6128: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6129: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6130: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6131: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6132: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6133: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;

Line 6130: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;

6126: l_etc_qty_tbl pa_plsql_datatypes.numTabTyp;
6127: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6128: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6129: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6130: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6131: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6132: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6133: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6134: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;

Line 6131: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;

6127: l_fcst_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6128: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6129: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6130: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6131: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6132: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6133: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6134: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;
6135: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;

Line 6132: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;

6128: l_etc_raw_cost_tbl pa_plsql_datatypes.numTabTyp;
6129: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6130: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6131: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6132: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6133: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6134: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;
6135: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;
6136: BEGIN

Line 6133: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;

6129: l_fcst_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6130: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6131: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6132: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6133: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6134: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;
6135: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;
6136: BEGIN
6137: x_msg_count := 0;

Line 6134: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;

6130: l_etc_burd_cost_tbl pa_plsql_datatypes.numTabTyp;
6131: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6132: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6133: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6134: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;
6135: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;
6136: BEGIN
6137: x_msg_count := 0;
6138: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6135: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;

6131: l_fcst_revenue_tbl pa_plsql_datatypes.numTabTyp;
6132: l_etc_revenue_tbl pa_plsql_datatypes.numTabTyp;
6133: l_txn_currency_code_tbl pa_plsql_datatypes.char15TabTyp;
6134: l_start_date_tbl pa_plsql_datatypes.dateTabTyp;
6135: l_end_date_tbl pa_plsql_datatypes.dateTabTyp;
6136: BEGIN
6137: x_msg_count := 0;
6138: x_return_status := FND_API.G_RET_STS_SUCCESS;
6139: