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 3229: l_fp_version_ids_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3225: X_MSG_COUNT OUT NOCOPY NUMBER,
3226: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3227: IS
3228: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1. MAINTAIN_BUDGET_VERSION';
3229: l_fp_version_ids_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3230:
3231: l_msg_count NUMBER;
3232: l_msg_data VARCHAR2(2000);
3233: l_data VARCHAR2(2000);

Line 4353: l_ra_id_tbl SYSTEM.pa_num_tbl_type;

4349:
4350: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
4351: l_budget_lines_exist VARCHAR2(1) DEFAULT 'N';
4352:
4353: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4354: l_task_id_tbl SYSTEM.pa_num_tbl_type;
4355: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
4356: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4357: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;

Line 4354: l_task_id_tbl SYSTEM.pa_num_tbl_type;

4350: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
4351: l_budget_lines_exist VARCHAR2(1) DEFAULT 'N';
4352:
4353: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4354: l_task_id_tbl SYSTEM.pa_num_tbl_type;
4355: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
4356: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4357: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
4358: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;

Line 4355: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;

4351: l_budget_lines_exist VARCHAR2(1) DEFAULT 'N';
4352:
4353: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
4354: l_task_id_tbl SYSTEM.pa_num_tbl_type;
4355: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
4356: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4357: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
4358: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
4359: l_total_qty_tbl SYSTEM.pa_num_tbl_type;

Line 4359: l_total_qty_tbl SYSTEM.pa_num_tbl_type;

4355: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
4356: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4357: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
4358: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
4359: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
4360: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4361: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4362: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4363: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4360: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;

4356: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4357: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
4358: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
4359: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
4360: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4361: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4362: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4363: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4364: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4361: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;

4357: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
4358: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
4359: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
4360: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4361: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4362: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4363: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4364: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4365: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;

Line 4362: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;

4358: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
4359: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
4360: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4361: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4362: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4363: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4364: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4365: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
4366: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;

Line 4363: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;

4359: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
4360: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4361: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4362: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4363: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4364: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4365: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
4366: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
4367: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;

Line 4364: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;

4360: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4361: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4362: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4363: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4364: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4365: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
4366: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
4367: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
4368:

Line 4365: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;

4361: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
4362: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
4363: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4364: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
4365: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
4366: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
4367: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
4368:
4369: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;

Line 4369: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;

4365: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
4366: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
4367: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
4368:
4369: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;
4370: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4371: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4372: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;
4373: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;

Line 4370: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;

4366: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
4367: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
4368:
4369: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;
4370: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4371: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4372: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;
4373: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;
4374: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

Line 4371: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;

4367: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
4368:
4369: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;
4370: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4371: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4372: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;
4373: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;
4374: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
4375:

Line 4372: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;

4368:
4369: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;
4370: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4371: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4372: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;
4373: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;
4374: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
4375:
4376:

Line 4373: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;

4369: l_disp_quant_tbl SYSTEM.pa_num_tbl_type;
4370: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4371: l_init_raw_cost_tbl SYSTEM.pa_num_tbl_type;
4372: l_init_burd_cost_tbl SYSTEM.pa_num_tbl_type;
4373: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;
4374: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
4375:
4376:
4377: l_ra_id_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4377: l_ra_id_tbl_1 SYSTEM.pa_num_tbl_type;

4373: l_init_revenue_tbl SYSTEM.pa_num_tbl_type;
4374: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
4375:
4376:
4377: l_ra_id_tbl_1 SYSTEM.pa_num_tbl_type;
4378: l_task_id_tbl_1 SYSTEM.pa_num_tbl_type;
4379: l_rlm_id_tbl_1 SYSTEM.pa_num_tbl_type;
4380: l_txn_currency_code_tbl_1 SYSTEM.pa_varchar2_15_tbl_type;
4381: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;

Line 4378: l_task_id_tbl_1 SYSTEM.pa_num_tbl_type;

4374: l_tras_source_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
4375:
4376:
4377: l_ra_id_tbl_1 SYSTEM.pa_num_tbl_type;
4378: l_task_id_tbl_1 SYSTEM.pa_num_tbl_type;
4379: l_rlm_id_tbl_1 SYSTEM.pa_num_tbl_type;
4380: l_txn_currency_code_tbl_1 SYSTEM.pa_varchar2_15_tbl_type;
4381: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4382: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;

Line 4379: l_rlm_id_tbl_1 SYSTEM.pa_num_tbl_type;

4375:
4376:
4377: l_ra_id_tbl_1 SYSTEM.pa_num_tbl_type;
4378: l_task_id_tbl_1 SYSTEM.pa_num_tbl_type;
4379: l_rlm_id_tbl_1 SYSTEM.pa_num_tbl_type;
4380: l_txn_currency_code_tbl_1 SYSTEM.pa_varchar2_15_tbl_type;
4381: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4382: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4383: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4383: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;

4379: l_rlm_id_tbl_1 SYSTEM.pa_num_tbl_type;
4380: l_txn_currency_code_tbl_1 SYSTEM.pa_varchar2_15_tbl_type;
4381: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4382: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4383: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;
4384: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4386: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4384: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;

4380: l_txn_currency_code_tbl_1 SYSTEM.pa_varchar2_15_tbl_type;
4381: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4382: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4383: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;
4384: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4386: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4385: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;

4381: l_planning_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4382: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4383: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;
4384: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4386: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4389: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4386: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;

4382: l_planning_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4383: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;
4384: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4386: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4389: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4390: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;

Line 4387: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;

4383: l_etc_qty_tbl_1 SYSTEM.pa_num_tbl_type;
4384: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4386: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4389: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4390: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4391: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;

Line 4388: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;

4384: l_txn_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4385: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4386: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4389: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4390: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4391: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4392: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;

Line 4389: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;

4385: l_txn_burdened_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4386: l_total_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4387: l_raw_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4388: l_burdened_cost_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4389: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4390: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4391: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4392: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;
4393: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4393: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;

4389: l_bill_rate_tbl_1 SYSTEM.pa_num_tbl_type;
4390: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4391: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4392: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;
4393: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;
4394: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4395: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4396: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4397: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4394: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;

4390: l_line_start_date_tbl_1 SYSTEM.pa_date_tbl_type;
4391: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4392: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;
4393: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;
4394: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4395: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4396: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4397: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4398: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;

Line 4395: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;

4391: l_line_end_date_tbl_1 SYSTEM.pa_date_tbl_type;
4392: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;
4393: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;
4394: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4395: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4396: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4397: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4398: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4399:

Line 4396: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;

4392: l_period_name_tbl_1 SYSTEM.pa_varchar2_30_tbl_type;
4393: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;
4394: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4395: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4396: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4397: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4398: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4399:
4400:

Line 4397: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;

4393: l_disp_quant_tbl_1 SYSTEM.pa_num_tbl_type;
4394: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4395: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4396: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4397: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4398: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4399:
4400:
4401: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 4398: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;

4394: l_init_quantity_tbl_1 SYSTEM.pa_num_tbl_type;
4395: l_init_raw_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4396: l_init_burd_cost_tbl_1 SYSTEM.pa_num_tbl_type;
4397: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4398: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4399:
4400:
4401: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4402: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

4407: l_input_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
4408: l_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
4409:
4410:
4411: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4412: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4413: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4414: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4415: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

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

4408: l_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
4409:
4410:
4411: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4412: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4413: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4414: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4415: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4416: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

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

4409:
4410:
4411: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4412: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4413: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4414: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4415: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4416: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
4417:

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

4410:
4411: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4412: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4413: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4414: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4415: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4416: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
4417:
4418:

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

4411: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4412: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4413: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4414: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4415: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4416: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
4417:
4418:
4419: l_upd_rbf_tbl_1 SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

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

4415: l_cal_raid_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4416: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
4417:
4418:
4419: l_upd_rbf_tbl_1 SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4420:
4421: l_rate_based_flag_tbl SYSTEM.pa_varchar2_15_tbl_type;
4422: l_res_rate_based_flag_tbl SYSTEM.pa_varchar2_15_tbl_type;
4423: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

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

4474: l_txn_avg_raw_cost_rate NUMBER;
4475: l_txn_avg_burden_cost_rate NUMBER;
4476: l_txn_avg_bill_rate NUMBER;
4477:
4478: l_txn_raw_cost_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4479: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4480: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4481: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4482: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

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

4475: l_txn_avg_burden_cost_rate NUMBER;
4476: l_txn_avg_bill_rate NUMBER;
4477:
4478: l_txn_raw_cost_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4479: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4480: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4481: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4482: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4483: l_txn_avg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

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

4476: l_txn_avg_bill_rate NUMBER;
4477:
4478: l_txn_raw_cost_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4479: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4480: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4481: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4482: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4483: l_txn_avg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4484: l_txn_src_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();

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

4477:
4478: l_txn_raw_cost_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4479: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4480: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4481: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4482: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4483: l_txn_avg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4484: l_txn_src_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4485: l_etc_source_tbl SYSTEM.pa_varchar2_80_tbl_type :=SYSTEM.pa_varchar2_80_tbl_type();

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

4478: l_txn_raw_cost_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4479: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4480: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4481: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4482: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4483: l_txn_avg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4484: l_txn_src_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4485: l_etc_source_tbl SYSTEM.pa_varchar2_80_tbl_type :=SYSTEM.pa_varchar2_80_tbl_type();
4486:

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

4479: l_txn_burd_cst_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4480: l_txn_bill_rate_ovrrid_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4481: l_txn_avg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4482: l_txn_avg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4483: l_txn_avg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4484: l_txn_src_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4485: l_etc_source_tbl SYSTEM.pa_varchar2_80_tbl_type :=SYSTEM.pa_varchar2_80_tbl_type();
4486:
4487:

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

4487:
4488: l_period_data_modified VARCHAR2(1) DEFAULT 'N';
4489: l_ra_multi_curr VARCHAR2(1) DEFAULT 'N';
4490:
4491: l_task_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4492: l_unit_of_measure_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
4493: l_found VARCHAR2(1);
4494: l_call_calculate_flag VARCHAR2(1) := 'N';
4495: l_calc_cur_txn_flag VARCHAR2(1) := 'N';