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_GEN_FCST_AMT_PUB1 dependencies on PA_NUM_TBL_TYPE

Line 756: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

752: X_MSG_COUNT OUT NOCOPY NUMBER,
753: X_MSG_DATA OUT NOCOPY VARCHAR2)
754: IS
755: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub1.call_summ_pop_tmps';
756: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
757: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
758: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
759: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
760: l_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 757: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

753: X_MSG_DATA OUT NOCOPY VARCHAR2)
754: IS
755: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub1.call_summ_pop_tmps';
756: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
757: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
758: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
759: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
760: l_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
761:

Line 758: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

754: IS
755: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub1.call_summ_pop_tmps';
756: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
757: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
758: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
759: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
760: l_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
761:
762: l_msg_count NUMBER;

Line 3252: l_fp_version_ids_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3248: X_MSG_COUNT OUT NOCOPY NUMBER,
3249: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3250: IS
3251: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1. MAINTAIN_BUDGET_VERSION';
3252: l_fp_version_ids_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3253:
3254: l_msg_count NUMBER;
3255: l_msg_data VARCHAR2(2000);
3256: l_data VARCHAR2(2000);

Line 4377: l_ra_id_tbl SYSTEM.pa_num_tbl_type;

4373:
4374: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
4375: l_budget_lines_exist VARCHAR2(1) DEFAULT 'N';
4376:
4377: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4378: l_task_id_tbl SYSTEM.pa_num_tbl_type;
4379: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
4380: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4381: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;

Line 4378: l_task_id_tbl SYSTEM.pa_num_tbl_type;

4374: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
4375: l_budget_lines_exist VARCHAR2(1) DEFAULT 'N';
4376:
4377: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4378: l_task_id_tbl SYSTEM.pa_num_tbl_type;
4379: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
4380: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4381: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
4382: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;

Line 4379: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;

4375: l_budget_lines_exist VARCHAR2(1) DEFAULT 'N';
4376:
4377: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4378: l_task_id_tbl SYSTEM.pa_num_tbl_type;
4379: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
4380: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4381: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
4382: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
4383: l_total_qty_tbl SYSTEM.pa_num_tbl_type;

Line 4383: l_total_qty_tbl SYSTEM.pa_num_tbl_type;

4379: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
4380: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4381: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
4382: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
4383: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
4384: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4386: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4384: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;

4380: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4381: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
4382: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
4383: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
4384: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4386: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4385: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;

4381: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
4382: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
4383: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
4384: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4386: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4389: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4386: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;

4382: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
4383: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
4384: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4386: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4389: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
4390: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;

Line 4387: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;

4383: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
4384: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4386: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4389: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
4390: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
4391: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;

Line 4388: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;

4384: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4386: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4389: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
4390: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
4391: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
4392:

Line 4389: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;

4385: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4386: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4389: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
4390: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
4391: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
4392:
4393: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;

Line 4393: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;

4389: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
4390: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
4391: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
4392:
4393: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;
4394: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4395: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4396: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;
4397: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;

Line 4394: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;

4390: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
4391: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
4392:
4393: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;
4394: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4395: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4396: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;
4397: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;
4398: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

Line 4395: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;

4391: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
4392:
4393: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;
4394: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4395: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4396: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;
4397: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;
4398: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
4399:

Line 4396: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;

4392:
4393: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;
4394: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4395: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4396: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;
4397: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;
4398: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
4399:
4400:

Line 4397: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;

4393: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;
4394: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4395: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4396: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;
4397: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;
4398: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
4399:
4400:
4401: l_ra_id_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4401: l_ra_id_tbl_1 SYSTEM.pa_num_tbl_type;

4397: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;
4398: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
4399:
4400:
4401: l_ra_id_tbl_1 SYSTEM.pa_num_tbl_type;
4402: l_task_id_tbl_1 SYSTEM.pa_num_tbl_type;
4403: l_rlm_id_tbl_1 SYSTEM.pa_num_tbl_type;
4404: l_txn_currency_code_tbl_1 SYSTEM.pa_varchar2_15_tbl_type;
4405: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;

Line 4402: l_task_id_tbl_1 SYSTEM.pa_num_tbl_type;

4398: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
4399:
4400:
4401: l_ra_id_tbl_1 SYSTEM.pa_num_tbl_type;
4402: l_task_id_tbl_1 SYSTEM.pa_num_tbl_type;
4403: l_rlm_id_tbl_1 SYSTEM.pa_num_tbl_type;
4404: l_txn_currency_code_tbl_1 SYSTEM.pa_varchar2_15_tbl_type;
4405: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4406: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;

Line 4403: l_rlm_id_tbl_1 SYSTEM.pa_num_tbl_type;

4399:
4400:
4401: l_ra_id_tbl_1 SYSTEM.pa_num_tbl_type;
4402: l_task_id_tbl_1 SYSTEM.pa_num_tbl_type;
4403: l_rlm_id_tbl_1 SYSTEM.pa_num_tbl_type;
4404: l_txn_currency_code_tbl_1 SYSTEM.pa_varchar2_15_tbl_type;
4405: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4406: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4407: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4407: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;

4403: l_rlm_id_tbl_1 SYSTEM.pa_num_tbl_type;
4404: l_txn_currency_code_tbl_1 SYSTEM.pa_varchar2_15_tbl_type;
4405: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4406: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4407: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;
4408: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4409: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4410: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4411: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4408: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;

4404: l_txn_currency_code_tbl_1 SYSTEM.pa_varchar2_15_tbl_type;
4405: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4406: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4407: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;
4408: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4409: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4410: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4411: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4412: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4409: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;

4405: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4406: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4407: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;
4408: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4409: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4410: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4411: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4412: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4413: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4410: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;

4406: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4407: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;
4408: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4409: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4410: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4411: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4412: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4413: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4414: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;

Line 4411: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;

4407: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;
4408: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4409: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4410: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4411: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4412: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4413: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4414: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4415: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;

Line 4412: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;

4408: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4409: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4410: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4411: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4412: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4413: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4414: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4415: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4416: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;

Line 4413: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;

4409: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4410: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4411: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4412: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4413: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4414: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4415: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4416: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;
4417: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4417: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;

4413: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4414: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4415: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4416: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;
4417: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;
4418: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4419: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4420: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4421: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4418: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;

4414: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4415: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4416: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;
4417: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;
4418: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4419: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4420: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4421: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4422: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4419: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;

4415: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4416: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;
4417: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;
4418: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4419: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4420: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4421: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4422: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4423:

Line 4420: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;

4416: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;
4417: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;
4418: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4419: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4420: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4421: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4422: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4423:
4424:

Line 4421: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;

4417: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;
4418: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4419: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4420: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4421: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4422: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4423:
4424:
4425: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 4422: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;

4418: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4419: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4420: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4421: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4422: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4423:
4424:
4425: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4426: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 4435: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4431: l_input_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
4432: l_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
4433:
4434:
4435: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4436: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4437: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4438: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4439: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 4436: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4432: l_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
4433:
4434:
4435: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4436: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4437: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4438: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4439: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4440: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

Line 4437: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4433:
4434:
4435: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4436: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4437: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4438: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4439: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4440: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
4441:

Line 4438: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4434:
4435: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4436: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4437: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4438: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4439: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4440: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
4441:
4442:

Line 4439: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4435: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4436: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4437: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4438: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4439: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4440: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
4441:
4442:
4443: l_upd_rbf_tbl_1 SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 4443: l_upd_rbf_tbl_1 SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4439: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4440: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
4441:
4442:
4443: l_upd_rbf_tbl_1 SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4444:
4445: l_rate_based_flag_tbl SYSTEM.pa_varchar2_15_tbl_type;
4446: l_res_rate_based_flag_tbl SYSTEM.pa_varchar2_15_tbl_type;
4447: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

Line 4502: l_txn_raw_cost_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4498: l_txn_avg_raw_cost_rate NUMBER;
4499: l_txn_avg_burden_cost_rate NUMBER;
4500: l_txn_avg_bill_rate NUMBER;
4501:
4502: l_txn_raw_cost_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4503: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4504: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4505: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4506: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 4503: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4499: l_txn_avg_burden_cost_rate NUMBER;
4500: l_txn_avg_bill_rate NUMBER;
4501:
4502: l_txn_raw_cost_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4503: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4504: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4505: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4506: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4507: l_txn_avg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 4504: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4500: l_txn_avg_bill_rate NUMBER;
4501:
4502: l_txn_raw_cost_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4503: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4504: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4505: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4506: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4507: l_txn_avg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4508: l_txn_src_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

Line 4505: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4501:
4502: l_txn_raw_cost_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4503: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4504: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4505: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4506: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4507: l_txn_avg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4508: l_txn_src_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4509: l_etc_source_tbl SYSTEM.pa_varchar2_80_tbl_type :=SYSTEM.pa_varchar2_80_tbl_type();

Line 4506: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4502: l_txn_raw_cost_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4503: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4504: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4505: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4506: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4507: l_txn_avg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4508: l_txn_src_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4509: l_etc_source_tbl SYSTEM.pa_varchar2_80_tbl_type :=SYSTEM.pa_varchar2_80_tbl_type();
4510:

Line 4507: l_txn_avg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4503: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4504: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4505: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4506: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4507: l_txn_avg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4508: l_txn_src_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4509: l_etc_source_tbl SYSTEM.pa_varchar2_80_tbl_type :=SYSTEM.pa_varchar2_80_tbl_type();
4510:
4511:

Line 4515: l_task_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

4511:
4512: l_period_data_modified VARCHAR2(1) DEFAULT 'N';
4513: l_ra_multi_curr VARCHAR2(1) DEFAULT 'N';
4514:
4515: l_task_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4516: l_unit_of_measure_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
4517: l_found VARCHAR2(1);
4518: l_call_calculate_flag VARCHAR2(1) := 'N';
4519: l_calc_cur_txn_flag VARCHAR2(1) := 'N';