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_DATE_TBL_TYPE

Line 1666: p_prd_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,

1662: PROCEDURE prepare_val_input
1663: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
1664: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
1665: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
1666: p_prd_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
1667: p_prd_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
1668: p_org_id IN pa_projects_all.org_id%TYPE,
1669: x_budget_lines OUT NOCOPY PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE, --File.Sql.39 bug 4440895
1670: x_etc_quantity_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895

Line 1667: p_prd_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,

1663: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
1664: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
1665: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
1666: p_prd_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
1667: p_prd_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
1668: p_org_id IN pa_projects_all.org_id%TYPE,
1669: x_budget_lines OUT NOCOPY PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE, --File.Sql.39 bug 4440895
1670: x_etc_quantity_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1671: x_etc_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895

Line 1677: x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE, --File.Sql.39 bug 4440895

1673: x_etc_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1674: x_raw_cost_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1675: x_burd_cost_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1676: x_bill_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1677: x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE, --File.Sql.39 bug 4440895
1678: x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE, --File.Sql.39 bug 4440895
1679: x_uom_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE, --File.Sql.39 bug 4440895
1680: x_mfc_cost_type_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE, --File.Sql.39 bug 4440895
1681: x_spread_curve_name_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE, --File.Sql.39 bug 4440895

Line 1678: x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE, --File.Sql.39 bug 4440895

1674: x_raw_cost_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1675: x_burd_cost_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1676: x_bill_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1677: x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE, --File.Sql.39 bug 4440895
1678: x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE, --File.Sql.39 bug 4440895
1679: x_uom_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE, --File.Sql.39 bug 4440895
1680: x_mfc_cost_type_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE, --File.Sql.39 bug 4440895
1681: x_spread_curve_name_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE, --File.Sql.39 bug 4440895
1682: x_sp_fixed_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE, --File.Sql.39 bug 4440895

Line 1682: x_sp_fixed_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE, --File.Sql.39 bug 4440895

1678: x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE, --File.Sql.39 bug 4440895
1679: x_uom_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE, --File.Sql.39 bug 4440895
1680: x_mfc_cost_type_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE, --File.Sql.39 bug 4440895
1681: x_spread_curve_name_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE, --File.Sql.39 bug 4440895
1682: x_sp_fixed_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE, --File.Sql.39 bug 4440895
1683: x_etc_method_name_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE, --File.Sql.39 bug 4440895
1684: x_spread_curve_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1685: x_delete_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895
1686: x_ra_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895

Line 1713: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

1709: l_msg_index_out NUMBER;
1710: l_data VARCHAR2(2000);
1711:
1712: -- variable to held the start_date and end_date of individual periods
1713: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1714: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1715:
1716: l_inf_tbl_data_prev_rec inf_tbl_data_csr%ROWTYPE;
1717: l_inf_tbl_data_curr_rec inf_tbl_data_csr%ROWTYPE;

Line 1714: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

1710: l_data VARCHAR2(2000);
1711:
1712: -- variable to held the start_date and end_date of individual periods
1713: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1714: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1715:
1716: l_inf_tbl_data_prev_rec inf_tbl_data_csr%ROWTYPE;
1717: l_inf_tbl_data_curr_rec inf_tbl_data_csr%ROWTYPE;
1718: l_inf_tbl_data_next_rec inf_tbl_data_csr%ROWTYPE;

Line 1837: l_plan_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

1833: l_rc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1834: l_bc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1835: l_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1836: l_uom_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
1837: l_plan_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1838: l_delete_flag VARCHAR2(1);
1839: l_plan_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1840: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
1841: l_spread_curve_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

Line 1839: l_plan_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

1835: l_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1836: l_uom_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
1837: l_plan_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1838: l_delete_flag VARCHAR2(1);
1839: l_plan_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1840: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
1841: l_spread_curve_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1842: l_etc_method_code_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
1843: l_mfc_cost_type_name_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();

Line 1844: l_sp_fixed_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

1840: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
1841: l_spread_curve_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1842: l_etc_method_code_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
1843: l_mfc_cost_type_name_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
1844: l_sp_fixed_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1845: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1846:
1847: -- variables to be used to call process_errors
1848: l_err_val_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 6169: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,

6165: p_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE, -- cbs enhancement changes bug#16445106
6166: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
6167: p_line_start_date IN DATE,
6168: p_line_end_date IN DATE,
6169: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,
6170: p_prd_mask_end_date_tbl IN SYSTEM.pa_date_tbl_type,
6171: p_st_index_in_prd_mask IN NUMBER,
6172: p_end_index_in_prd_mask IN NUMBER,
6173: p_etc_start_date IN DATE,

Line 6170: p_prd_mask_end_date_tbl IN SYSTEM.pa_date_tbl_type,

6166: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
6167: p_line_start_date IN DATE,
6168: p_line_end_date IN DATE,
6169: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,
6170: p_prd_mask_end_date_tbl IN SYSTEM.pa_date_tbl_type,
6171: p_st_index_in_prd_mask IN NUMBER,
6172: p_end_index_in_prd_mask IN NUMBER,
6173: p_etc_start_date IN DATE,
6174: p_etc_quantity IN NUMBER,

Line 6789: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,

6785: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,
6786: p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
6787: p_first_pd_bf_pm_en_dt IN DATE,
6788: p_last_pd_af_pm_st_dt IN DATE,
6789: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,
6790: p_prd_mask_end_date_tbl IN SYSTEM.pa_date_tbl_type,
6791: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type,
6792: p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type,
6793: p_etc_quantity_tbl IN SYSTEM.pa_num_tbl_type,

Line 6790: p_prd_mask_end_date_tbl IN SYSTEM.pa_date_tbl_type,

6786: p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
6787: p_first_pd_bf_pm_en_dt IN DATE,
6788: p_last_pd_af_pm_st_dt IN DATE,
6789: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,
6790: p_prd_mask_end_date_tbl IN SYSTEM.pa_date_tbl_type,
6791: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type,
6792: p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type,
6793: p_etc_quantity_tbl IN SYSTEM.pa_num_tbl_type,
6794: p_etc_raw_cost_tbl IN SYSTEM.pa_num_tbl_type,

Line 6791: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type,

6787: p_first_pd_bf_pm_en_dt IN DATE,
6788: p_last_pd_af_pm_st_dt IN DATE,
6789: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,
6790: p_prd_mask_end_date_tbl IN SYSTEM.pa_date_tbl_type,
6791: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type,
6792: p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type,
6793: p_etc_quantity_tbl IN SYSTEM.pa_num_tbl_type,
6794: p_etc_raw_cost_tbl IN SYSTEM.pa_num_tbl_type,
6795: p_etc_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type,

Line 6792: p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type,

6788: p_last_pd_af_pm_st_dt IN DATE,
6789: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,
6790: p_prd_mask_end_date_tbl IN SYSTEM.pa_date_tbl_type,
6791: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type,
6792: p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type,
6793: p_etc_quantity_tbl IN SYSTEM.pa_num_tbl_type,
6794: p_etc_raw_cost_tbl IN SYSTEM.pa_num_tbl_type,
6795: p_etc_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type,
6796: p_etc_revenue_tbl IN SYSTEM.pa_num_tbl_type,

Line 6803: p_sp_fixed_date_tbl IN SYSTEM.pa_date_tbl_type,

6799: p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type,
6800: p_spread_curve_id_tbl IN SYSTEM.pa_num_tbl_type,
6801: p_mfc_cost_type_id_tbl IN SYSTEM.pa_num_tbl_type,
6802: p_etc_method_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type ,
6803: p_sp_fixed_date_tbl IN SYSTEM.pa_date_tbl_type,
6804: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type ,
6805: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,
6806: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type,
6807: p_cbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type, -- cbs enhancement changes bug#16445106

Line 6814: x_planning_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

6810: x_rlm_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6811: x_cbs_element_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- cbs enhancement changes bug#16445106
6812: x_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6813: x_txn_currency_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_15_tbl_type , --File.Sql.39 bug 4440895
6814: x_planning_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6815: x_planning_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6816: x_total_qty_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6817: x_total_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6818: x_total_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895

Line 6815: x_planning_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

6811: x_cbs_element_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- cbs enhancement changes bug#16445106
6812: x_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6813: x_txn_currency_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_15_tbl_type , --File.Sql.39 bug 4440895
6814: x_planning_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6815: x_planning_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6816: x_total_qty_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6817: x_total_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6818: x_total_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6819: x_total_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895

Line 6823: x_line_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

6819: x_total_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6820: x_raw_cost_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6821: x_burdened_cost_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6822: x_bill_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6823: x_line_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6824: x_line_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6825: x_proj_cost_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6826: x_proj_cost_rate_date_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6827: x_proj_cost_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895

Line 6824: x_line_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

6820: x_raw_cost_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6821: x_burdened_cost_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6822: x_bill_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6823: x_line_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6824: x_line_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6825: x_proj_cost_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6826: x_proj_cost_rate_date_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6827: x_proj_cost_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6828: x_proj_cost_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

Line 6828: x_proj_cost_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

6824: x_line_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6825: x_proj_cost_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6826: x_proj_cost_rate_date_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6827: x_proj_cost_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6828: x_proj_cost_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6829: x_proj_rev_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6830: x_proj_rev_rate_date_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6831: x_proj_rev_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6832: x_proj_rev_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

Line 6832: x_proj_rev_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

6828: x_proj_cost_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6829: x_proj_rev_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6830: x_proj_rev_rate_date_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6831: x_proj_rev_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6832: x_proj_rev_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6833: x_pfunc_cost_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6834: x_pfunc_cost_rate_date_typ_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6835: x_pfunc_cost_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6836: x_pfunc_cost_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

Line 6836: x_pfunc_cost_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

6832: x_proj_rev_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6833: x_pfunc_cost_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6834: x_pfunc_cost_rate_date_typ_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6835: x_pfunc_cost_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6836: x_pfunc_cost_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6837: x_pfunc_rev_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6838: x_pfunc_rev_rate_date_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6839: x_pfunc_rev_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6840: x_pfunc_rev_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

Line 6840: x_pfunc_rev_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

6836: x_pfunc_cost_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6837: x_pfunc_rev_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6838: x_pfunc_rev_rate_date_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6839: x_pfunc_rev_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6840: x_pfunc_rev_rate_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6841: x_delete_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
6842: x_spread_curve_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6843: x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6844: x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895

Line 6845: x_sp_fixed_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895

6841: x_delete_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
6842: x_spread_curve_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6843: x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6844: x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6845: x_sp_fixed_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type, --File.Sql.39 bug 4440895
6846: x_res_class_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6847: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type , --File.Sql.39 bug 4440895
6848: x_rbs_elem_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6849: x_change_reason_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, --File.Sql.39 bug 4440895

Line 6916: l_prd_mask_st_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

6912:
6913: --These tbls will be prepared in this manner
6914: ----First element is for the proceeding bucket . Next p_prd_mask_st_date_tbl.COUNT buckets will contain
6915: ----start/end dates of the periods in the period mask. Last element will be for the succeeding bucket.
6916: l_prd_mask_st_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
6917: l_prd_mask_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
6918:
6919: tt NUMBER;
6920:

Line 6917: l_prd_mask_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

6913: --These tbls will be prepared in this manner
6914: ----First element is for the proceeding bucket . Next p_prd_mask_st_date_tbl.COUNT buckets will contain
6915: ----start/end dates of the periods in the period mask. Last element will be for the succeeding bucket.
6916: l_prd_mask_st_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
6917: l_prd_mask_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
6918:
6919: tt NUMBER;
6920:
6921: BEGIN

Line 7075: x_planning_start_date_tbl := SYSTEM.pa_date_tbl_type();

7071: x_rlm_id_tbl := SYSTEM.pa_num_tbl_type();
7072: x_cbs_element_id_tbl := SYSTEM.pa_num_tbl_type(); -- cbs enhancement changes bug#16445106
7073: x_ra_id_tbl := SYSTEM.pa_num_tbl_type();
7074: x_txn_currency_code_tbl := SYSTEM.pa_varchar2_15_tbl_type();
7075: x_planning_start_date_tbl := SYSTEM.pa_date_tbl_type();
7076: x_planning_end_date_tbl := SYSTEM.pa_date_tbl_type();
7077: x_total_qty_tbl := SYSTEM.pa_num_tbl_type();
7078: x_total_raw_cost_tbl := SYSTEM.pa_num_tbl_type();
7079: x_total_burdened_cost_tbl := SYSTEM.pa_num_tbl_type();

Line 7076: x_planning_end_date_tbl := SYSTEM.pa_date_tbl_type();

7072: x_cbs_element_id_tbl := SYSTEM.pa_num_tbl_type(); -- cbs enhancement changes bug#16445106
7073: x_ra_id_tbl := SYSTEM.pa_num_tbl_type();
7074: x_txn_currency_code_tbl := SYSTEM.pa_varchar2_15_tbl_type();
7075: x_planning_start_date_tbl := SYSTEM.pa_date_tbl_type();
7076: x_planning_end_date_tbl := SYSTEM.pa_date_tbl_type();
7077: x_total_qty_tbl := SYSTEM.pa_num_tbl_type();
7078: x_total_raw_cost_tbl := SYSTEM.pa_num_tbl_type();
7079: x_total_burdened_cost_tbl := SYSTEM.pa_num_tbl_type();
7080: x_total_revenue_tbl := SYSTEM.pa_num_tbl_type();

Line 7084: x_line_start_date_tbl := SYSTEM.pa_date_tbl_type();

7080: x_total_revenue_tbl := SYSTEM.pa_num_tbl_type();
7081: x_raw_cost_rate_tbl := SYSTEM.pa_num_tbl_type();
7082: x_burdened_cost_rate_tbl := SYSTEM.pa_num_tbl_type();
7083: x_bill_rate_tbl := SYSTEM.pa_num_tbl_type();
7084: x_line_start_date_tbl := SYSTEM.pa_date_tbl_type();
7085: x_line_end_date_tbl := SYSTEM.pa_date_tbl_type();
7086: x_proj_cost_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7087: x_proj_cost_rate_date_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7088: x_proj_cost_rate_tbl := SYSTEM.pa_num_tbl_type();

Line 7085: x_line_end_date_tbl := SYSTEM.pa_date_tbl_type();

7081: x_raw_cost_rate_tbl := SYSTEM.pa_num_tbl_type();
7082: x_burdened_cost_rate_tbl := SYSTEM.pa_num_tbl_type();
7083: x_bill_rate_tbl := SYSTEM.pa_num_tbl_type();
7084: x_line_start_date_tbl := SYSTEM.pa_date_tbl_type();
7085: x_line_end_date_tbl := SYSTEM.pa_date_tbl_type();
7086: x_proj_cost_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7087: x_proj_cost_rate_date_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7088: x_proj_cost_rate_tbl := SYSTEM.pa_num_tbl_type();
7089: x_proj_cost_rate_date_tbl := SYSTEM.pa_date_tbl_type();

Line 7089: x_proj_cost_rate_date_tbl := SYSTEM.pa_date_tbl_type();

7085: x_line_end_date_tbl := SYSTEM.pa_date_tbl_type();
7086: x_proj_cost_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7087: x_proj_cost_rate_date_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7088: x_proj_cost_rate_tbl := SYSTEM.pa_num_tbl_type();
7089: x_proj_cost_rate_date_tbl := SYSTEM.pa_date_tbl_type();
7090: x_proj_rev_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7091: x_proj_rev_rate_date_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7092: x_proj_rev_rate_tbl := SYSTEM.pa_num_tbl_type();
7093: x_proj_rev_rate_date_tbl := SYSTEM.pa_date_tbl_type();

Line 7093: x_proj_rev_rate_date_tbl := SYSTEM.pa_date_tbl_type();

7089: x_proj_cost_rate_date_tbl := SYSTEM.pa_date_tbl_type();
7090: x_proj_rev_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7091: x_proj_rev_rate_date_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7092: x_proj_rev_rate_tbl := SYSTEM.pa_num_tbl_type();
7093: x_proj_rev_rate_date_tbl := SYSTEM.pa_date_tbl_type();
7094: x_pfunc_cost_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7095: x_pfunc_cost_rate_date_typ_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7096: x_pfunc_cost_rate_tbl := SYSTEM.pa_num_tbl_type();
7097: x_pfunc_cost_rate_date_tbl := SYSTEM.pa_date_tbl_type();

Line 7097: x_pfunc_cost_rate_date_tbl := SYSTEM.pa_date_tbl_type();

7093: x_proj_rev_rate_date_tbl := SYSTEM.pa_date_tbl_type();
7094: x_pfunc_cost_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7095: x_pfunc_cost_rate_date_typ_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7096: x_pfunc_cost_rate_tbl := SYSTEM.pa_num_tbl_type();
7097: x_pfunc_cost_rate_date_tbl := SYSTEM.pa_date_tbl_type();
7098: x_pfunc_rev_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7099: x_pfunc_rev_rate_date_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7100: x_pfunc_rev_rate_tbl := SYSTEM.pa_num_tbl_type();
7101: x_pfunc_rev_rate_date_tbl := SYSTEM.pa_date_tbl_type();

Line 7101: x_pfunc_rev_rate_date_tbl := SYSTEM.pa_date_tbl_type();

7097: x_pfunc_cost_rate_date_tbl := SYSTEM.pa_date_tbl_type();
7098: x_pfunc_rev_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7099: x_pfunc_rev_rate_date_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7100: x_pfunc_rev_rate_tbl := SYSTEM.pa_num_tbl_type();
7101: x_pfunc_rev_rate_date_tbl := SYSTEM.pa_date_tbl_type();
7102: x_delete_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7103: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
7104: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
7105: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();

Line 7106: x_sp_fixed_date_tbl := SYSTEM.pa_date_tbl_type();

7102: x_delete_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7103: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
7104: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
7105: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7106: x_sp_fixed_date_tbl := SYSTEM.pa_date_tbl_type();
7107: x_res_class_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7108: x_rate_based_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7109: x_rbs_elem_id_tbl := SYSTEM.pa_num_tbl_type();
7110: x_change_reason_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();

Line 8023: p_prd_mask_st_date_tbl =>SYSTEM.pa_date_tbl_type(),

8019: p_cbs_element_id =>p_budget_lines_tbl(kk).cbs_element_id, -- cbs enhancement changes bug#16445106
8020: p_txn_currency_code =>p_budget_lines_tbl(kk).txn_currency_code,
8021: p_line_start_date =>NULL,
8022: p_line_end_date =>NULL,
8023: p_prd_mask_st_date_tbl =>SYSTEM.pa_date_tbl_type(),
8024: p_prd_mask_end_date_tbl =>SYSTEM.pa_date_tbl_type(),
8025: p_st_index_in_prd_mask =>NULL,
8026: p_end_index_in_prd_mask =>NULL,
8027: p_etc_start_date =>p_etc_start_date,

Line 8024: p_prd_mask_end_date_tbl =>SYSTEM.pa_date_tbl_type(),

8020: p_txn_currency_code =>p_budget_lines_tbl(kk).txn_currency_code,
8021: p_line_start_date =>NULL,
8022: p_line_end_date =>NULL,
8023: p_prd_mask_st_date_tbl =>SYSTEM.pa_date_tbl_type(),
8024: p_prd_mask_end_date_tbl =>SYSTEM.pa_date_tbl_type(),
8025: p_st_index_in_prd_mask =>NULL,
8026: p_end_index_in_prd_mask =>NULL,
8027: p_etc_start_date =>p_etc_start_date,
8028: p_etc_quantity =>p_etc_quantity_tbl(kk),

Line 8129: p_sp_fixed_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

8125: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8126: p_spread_curve_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8127: p_mfc_cost_type_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8128: p_etc_method_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8129: p_sp_fixed_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8130: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8131: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),
8132: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8133: p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type(),

Line 8134: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

8130: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8131: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),
8132: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8133: p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type(),
8134: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8135: p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8136: p_total_qty_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8137: p_total_raw_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8138: p_total_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

Line 8135: p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

8131: p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),
8132: p_rbs_elem_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8133: p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type(),
8134: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8135: p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8136: p_total_qty_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8137: p_total_raw_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8138: p_total_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8139: p_total_revenue_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

Line 8143: p_line_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

8139: p_total_revenue_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8140: p_raw_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8141: p_burdened_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8142: p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8143: p_line_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8144: p_line_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8145: p_proj_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8146: p_proj_cost_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8147: p_proj_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

Line 8144: p_line_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

8140: p_raw_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8141: p_burdened_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8142: p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8143: p_line_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8144: p_line_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8145: p_proj_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8146: p_proj_cost_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8147: p_proj_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8148: p_proj_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

Line 8148: p_proj_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

8144: p_line_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8145: p_proj_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8146: p_proj_cost_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8147: p_proj_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8148: p_proj_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8149: p_proj_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8150: p_proj_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8151: p_proj_rev_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8152: p_proj_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

Line 8152: p_proj_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

8148: p_proj_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8149: p_proj_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8150: p_proj_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8151: p_proj_rev_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8152: p_proj_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8153: p_pfunc_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8154: p_pfunc_cost_rate_date_typ_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8155: p_pfunc_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8156: p_pfunc_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

Line 8156: p_pfunc_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

8152: p_proj_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8153: p_pfunc_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8154: p_pfunc_cost_rate_date_typ_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8155: p_pfunc_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8156: p_pfunc_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8157: p_pfunc_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8158: p_pfunc_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8159: p_pfunc_rev_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8160: p_pfunc_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

Line 8160: p_pfunc_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

8156: p_pfunc_cost_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8157: p_pfunc_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8158: p_pfunc_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8159: p_pfunc_rev_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8160: p_pfunc_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8161: p_change_reason_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8162: p_description_tbl IN SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type(),
8163: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),
8164: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 8190: l_sp_fixed_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8186: l_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8187: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8188: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8189: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8190: l_sp_fixed_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8191: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8192: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8193: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8194: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();

Line 8195: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8191: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8192: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8193: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8194: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8195: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8196: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8197: l_total_qty_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8198: l_total_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8199: l_total_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8196: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8192: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8193: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8194: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8195: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8196: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8197: l_total_qty_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8198: l_total_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8199: l_total_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8200: l_total_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8204: l_line_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8200: l_total_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8201: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8202: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8203: l_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8204: l_line_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8205: l_line_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8206: l_proj_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8207: l_proj_cost_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8208: l_proj_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8205: l_line_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8201: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8202: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8203: l_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8204: l_line_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8205: l_line_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8206: l_proj_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8207: l_proj_cost_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8208: l_proj_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8209: l_proj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8209: l_proj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8205: l_line_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8206: l_proj_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8207: l_proj_cost_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8208: l_proj_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8209: l_proj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8210: l_proj_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8211: l_proj_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8212: l_proj_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8213: l_proj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8213: l_proj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8209: l_proj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8210: l_proj_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8211: l_proj_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8212: l_proj_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8213: l_proj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8214: l_pfunc_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8215: l_pfunc_cost_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8216: l_pfunc_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8217: l_pfunc_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8217: l_pfunc_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8213: l_proj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8214: l_pfunc_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8215: l_pfunc_cost_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8216: l_pfunc_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8217: l_pfunc_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8218: l_pfunc_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8219: l_pfunc_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8220: l_pfunc_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8221: l_pfunc_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8221: l_pfunc_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8217: l_pfunc_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8218: l_pfunc_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8219: l_pfunc_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8220: l_pfunc_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8221: l_pfunc_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8222: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8223: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8224:
8225:

Line 8234: l_df_sp_fixed_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8230: l_df_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8231: l_df_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8232: l_df_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8233: l_df_etc_method_code SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8234: l_df_sp_fixed_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8235: l_df_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8236: l_df_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8237: l_df_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8238: l_df_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();

Line 8239: l_df_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8235: l_df_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8236: l_df_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8237: l_df_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8238: l_df_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8239: l_df_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8240: l_df_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8241: l_df_total_qty_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8242: l_df_total_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8243: l_df_total_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8240: l_df_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8236: l_df_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8237: l_df_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8238: l_df_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8239: l_df_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8240: l_df_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8241: l_df_total_qty_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8242: l_df_total_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8243: l_df_total_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8244: l_df_total_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8248: l_df_line_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8244: l_df_total_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8245: l_df_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8246: l_df_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8247: l_df_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8248: l_df_line_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8249: l_df_line_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8250: l_df_pj_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8251: l_df_pj_cost_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8252: l_df_pj_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8249: l_df_line_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8245: l_df_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8246: l_df_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8247: l_df_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8248: l_df_line_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8249: l_df_line_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8250: l_df_pj_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8251: l_df_pj_cost_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8252: l_df_pj_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8253: l_df_pj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8253: l_df_pj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8249: l_df_line_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8250: l_df_pj_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8251: l_df_pj_cost_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8252: l_df_pj_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8253: l_df_pj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8254: l_df_pj_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8255: l_df_pj_rev_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8256: l_df_pj_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8257: l_df_pj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8257: l_df_pj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8253: l_df_pj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8254: l_df_pj_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8255: l_df_pj_rev_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8256: l_df_pj_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8257: l_df_pj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8258: l_df_pf_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8259: l_df_pf_cost_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8260: l_df_pf_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8261: l_df_pf_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8261: l_df_pf_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8257: l_df_pj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8258: l_df_pf_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8259: l_df_pf_cost_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8260: l_df_pf_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8261: l_df_pf_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8262: l_df_pf_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8263: l_df_pf_rev_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8264: l_df_pf_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8265: l_df_pf_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8265: l_df_pf_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8261: l_df_pf_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8262: l_df_pf_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8263: l_df_pf_rev_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8264: l_df_pf_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8265: l_df_pf_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8266: l_df_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8267: l_df_description_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8268:
8269: l_total_rec_passed INTEGER := 0;

Line 8280: l_new_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8276: l_new_elem_ver_id pa_proj_element_versions.element_version_id%TYPE;
8277: l_new_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8278: l_new_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8279: l_new_cbs_elemet_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();-- cbs enhancement changes bug#16445106
8280: l_new_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8281: l_new_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8282:
8283: -- variables used to insert into pa_fp_rollup_tmp
8284: -- with delete flag = Y

Line 8281: l_new_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8277: l_new_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8278: l_new_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8279: l_new_cbs_elemet_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();-- cbs enhancement changes bug#16445106
8280: l_new_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8281: l_new_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8282:
8283: -- variables used to insert into pa_fp_rollup_tmp
8284: -- with delete flag = Y
8285: l_bl_del_flag_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8286: l_bl_del_flag_st_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8282:
8283: -- variables used to insert into pa_fp_rollup_tmp
8284: -- with delete flag = Y
8285: l_bl_del_flag_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8286: l_bl_del_flag_st_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8287: l_bl_del_flag_en_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8288: l_bl_del_flag_txn_curr_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8289: l_bl_del_flag_txn_rc_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8290: l_bl_del_flag_txn_bc_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8287: l_bl_del_flag_en_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8283: -- variables used to insert into pa_fp_rollup_tmp
8284: -- with delete flag = Y
8285: l_bl_del_flag_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8286: l_bl_del_flag_st_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8287: l_bl_del_flag_en_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8288: l_bl_del_flag_txn_curr_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8289: l_bl_del_flag_txn_rc_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8290: l_bl_del_flag_txn_bc_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8291: l_bl_del_flag_txn_rev_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8296: l_bl_del_flag_pf_cr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8292: l_bl_del_flag_pf_curr_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8293: l_bl_del_flag_pf_cr_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8294: l_bl_del_flag_pf_cr_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8295: l_bl_del_flag_pf_cexc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8296: l_bl_del_flag_pf_cr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8297: l_bl_del_flag_pf_rr_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8298: l_bl_del_flag_pf_rr_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8299: l_bl_del_flag_pf_rexc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8300: l_bl_del_flag_pf_rr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8300: l_bl_del_flag_pf_rr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8296: l_bl_del_flag_pf_cr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8297: l_bl_del_flag_pf_rr_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8298: l_bl_del_flag_pf_rr_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8299: l_bl_del_flag_pf_rexc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8300: l_bl_del_flag_pf_rr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8301: l_bl_del_flag_pj_curr_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8302: l_bl_del_flag_pj_cr_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8303: l_bl_del_flag_pj_cr_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8304: l_bl_del_flag_pj_cexc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8305: l_bl_del_flag_pj_cr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8301: l_bl_del_flag_pj_curr_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8302: l_bl_del_flag_pj_cr_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8303: l_bl_del_flag_pj_cr_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8304: l_bl_del_flag_pj_cexc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8305: l_bl_del_flag_pj_cr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8306: l_bl_del_flag_pj_rr_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8307: l_bl_del_flag_pj_rr_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8308: l_bl_del_flag_pj_rexc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8309: l_bl_del_flag_pj_rr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8309: l_bl_del_flag_pj_rr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8305: l_bl_del_flag_pj_cr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8306: l_bl_del_flag_pj_rr_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8307: l_bl_del_flag_pj_rr_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8308: l_bl_del_flag_pj_rexc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8309: l_bl_del_flag_pj_rr_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8310: l_bl_del_flag_bl_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8311: l_bl_del_flag_per_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8312: l_bl_del_flag_pj_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8313: l_bl_del_flag_pj_burd_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8334: l_pji_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8330:
8331: -- variables used to call update_reporting_lines
8332: l_pji_res_ass_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8333: l_pji_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8334: l_pji_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8335: l_pji_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8336: l_pji_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8337: l_pji_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8338: l_pji_txn_burd_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8335: l_pji_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8331: -- variables used to call update_reporting_lines
8332: l_pji_res_ass_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8333: l_pji_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8334: l_pji_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8335: l_pji_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8336: l_pji_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8337: l_pji_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8338: l_pji_txn_burd_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8339: l_pji_txn_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8370: l_debug_st_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8366: l_g_miss_date CONSTANT DATE := FND_API.G_MISS_DATE;
8367:
8368: l_debug_st_dt DATE;
8369: l_debug_en_dt DATE;
8370: l_debug_st_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8371: l_debug_en_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8372:
8373: l_debug_quantity NUMBER;
8374: l_debug_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8371: l_debug_en_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8367:
8368: l_debug_st_dt DATE;
8369: l_debug_en_dt DATE;
8370: l_debug_st_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8371: l_debug_en_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8372:
8373: l_debug_quantity NUMBER;
8374: l_debug_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8375: l_debug_raw_cost NUMBER;

Line 8397: l_upd_pj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8393: l_upd_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8394: l_upd_pj_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8395: l_upd_pj_cost_exc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8396: l_upd_pj_cost_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8397: l_upd_pj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8398: l_upd_pj_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8399: l_upd_pj_rev_exc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8400: l_upd_pj_rev_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8401: l_upd_pj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8401: l_upd_pj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8397: l_upd_pj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8398: l_upd_pj_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8399: l_upd_pj_rev_exc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8400: l_upd_pj_rev_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8401: l_upd_pj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8402: l_upd_pf_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8403: l_upd_pf_cost_exc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8404: l_upd_pf_cost_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8405: l_upd_pf_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8405: l_upd_pf_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8401: l_upd_pj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8402: l_upd_pf_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8403: l_upd_pf_cost_exc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8404: l_upd_pf_cost_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8405: l_upd_pf_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8406: l_upd_pf_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8407: l_upd_pf_rev_exc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8408: l_upd_pf_rev_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8409: l_upd_pf_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8409: l_upd_pf_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

8405: l_upd_pf_cost_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8406: l_upd_pf_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8407: l_upd_pf_rev_exc_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8408: l_upd_pf_rev_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8409: l_upd_pf_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8410: --Bug 4424457
8411: l_bl_count_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8412: l_bls_proccessed_flag VARCHAR2(1);
8413: l_error_msg_code VARCHAR2(2000);

Line 9194: l_line_start_date_tbl := SYSTEM.pa_date_tbl_type();

9190: END IF;
9191: IF p_context = 'WEBADI_PERIODIC' THEN
9192: l_calc_calling_context := PA_FP_CONSTANTS_PKG.G_CALC_API_BUDGET_LINE;
9193: ELSIF p_context = 'WEBADI_NON_PERIODIC' THEN
9194: l_line_start_date_tbl := SYSTEM.pa_date_tbl_type();
9195: l_line_end_date_tbl := SYSTEM.pa_date_tbl_type();
9196: l_calc_calling_context := PA_FP_CONSTANTS_PKG.G_CALC_API_RESOURCE_CONTEXT;
9197: END IF;
9198:

Line 9195: l_line_end_date_tbl := SYSTEM.pa_date_tbl_type();

9191: IF p_context = 'WEBADI_PERIODIC' THEN
9192: l_calc_calling_context := PA_FP_CONSTANTS_PKG.G_CALC_API_BUDGET_LINE;
9193: ELSIF p_context = 'WEBADI_NON_PERIODIC' THEN
9194: l_line_start_date_tbl := SYSTEM.pa_date_tbl_type();
9195: l_line_end_date_tbl := SYSTEM.pa_date_tbl_type();
9196: l_calc_calling_context := PA_FP_CONSTANTS_PKG.G_CALC_API_RESOURCE_CONTEXT;
9197: END IF;
9198:
9199: IF l_debug_mode = 'Y' THEN

Line 10315: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

10311: l_org_id pa_projects_all.org_id%TYPE;
10312: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
10313:
10314: -- variable to held the start_date and end_date of individual periods
10315: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10316: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10317:
10318: l_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
10319: l_temp_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;

Line 10316: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

10312: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
10313:
10314: -- variable to held the start_date and end_date of individual periods
10315: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10316: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10317:
10318: l_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
10319: l_temp_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
10320: l_bl_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 10323: l_bl_plan_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

10319: l_temp_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
10320: l_bl_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10321: l_bl_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10322: l_bl_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10323: l_bl_plan_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10324: l_bl_plan_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10325: l_bl_uom_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
10326: l_mfc_cost_type_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
10327: l_spread_curve_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 10324: l_bl_plan_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

10320: l_bl_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10321: l_bl_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10322: l_bl_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10323: l_bl_plan_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10324: l_bl_plan_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10325: l_bl_uom_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
10326: l_mfc_cost_type_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
10327: l_spread_curve_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
10328: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 10328: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

10324: l_bl_plan_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10325: l_bl_uom_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
10326: l_mfc_cost_type_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
10327: l_spread_curve_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
10328: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10329: l_sp_fixed_date_tbl_1 SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10330: l_etc_method_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
10331: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10332: l_spread_curve_id_tbl_1 SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 10329: l_sp_fixed_date_tbl_1 SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

10325: l_bl_uom_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
10326: l_mfc_cost_type_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
10327: l_spread_curve_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
10328: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10329: l_sp_fixed_date_tbl_1 SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10330: l_etc_method_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
10331: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10332: l_spread_curve_id_tbl_1 SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10333:

Line 10359: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;

10355: l_ra_id_tbl SYSTEM.pa_num_tbl_type;
10356: l_task_id_tbl SYSTEM.pa_num_tbl_type;
10357: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
10358: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
10359: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
10360: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
10361: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
10362: l_total_raw_cost_tbl SYSTEM.pa_num_tbl_type;
10363: l_total_burdened_cost_tbl SYSTEM.pa_num_tbl_type;

Line 10360: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;

10356: l_task_id_tbl SYSTEM.pa_num_tbl_type;
10357: l_rlm_id_tbl SYSTEM.pa_num_tbl_type;
10358: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
10359: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type;
10360: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type;
10361: l_total_qty_tbl SYSTEM.pa_num_tbl_type;
10362: l_total_raw_cost_tbl SYSTEM.pa_num_tbl_type;
10363: l_total_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
10364: l_total_revenue_tbl SYSTEM.pa_num_tbl_type;

Line 10368: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;

10364: l_total_revenue_tbl SYSTEM.pa_num_tbl_type;
10365: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
10366: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
10367: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
10368: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
10369: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
10370: l_proj_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10371: l_proj_cost_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10372: l_proj_cost_rate_tbl SYSTEM.pa_num_tbl_type;

Line 10369: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;

10365: l_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type;
10366: l_burdened_cost_rate_tbl SYSTEM.pa_num_tbl_type;
10367: l_bill_rate_tbl SYSTEM.pa_num_tbl_type;
10368: l_line_start_date_tbl SYSTEM.pa_date_tbl_type;
10369: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
10370: l_proj_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10371: l_proj_cost_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10372: l_proj_cost_rate_tbl SYSTEM.pa_num_tbl_type;
10373: l_proj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type;

Line 10373: l_proj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type;

10369: l_line_end_date_tbl SYSTEM.pa_date_tbl_type;
10370: l_proj_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10371: l_proj_cost_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10372: l_proj_cost_rate_tbl SYSTEM.pa_num_tbl_type;
10373: l_proj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type;
10374: l_proj_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10375: l_proj_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10376: l_proj_rev_rate_tbl SYSTEM.pa_num_tbl_type;
10377: l_proj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type;

Line 10377: l_proj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type;

10373: l_proj_cost_rate_date_tbl SYSTEM.pa_date_tbl_type;
10374: l_proj_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10375: l_proj_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10376: l_proj_rev_rate_tbl SYSTEM.pa_num_tbl_type;
10377: l_proj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type;
10378: l_pfunc_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10379: l_pfunc_cost_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type;
10380: l_pfunc_cost_rate_tbl SYSTEM.pa_num_tbl_type;
10381: l_pfunc_cost_rate_date_tbl SYSTEM.pa_date_tbl_type;

Line 10381: l_pfunc_cost_rate_date_tbl SYSTEM.pa_date_tbl_type;

10377: l_proj_rev_rate_date_tbl SYSTEM.pa_date_tbl_type;
10378: l_pfunc_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10379: l_pfunc_cost_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type;
10380: l_pfunc_cost_rate_tbl SYSTEM.pa_num_tbl_type;
10381: l_pfunc_cost_rate_date_tbl SYSTEM.pa_date_tbl_type;
10382: l_pfunc_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10383: l_pfunc_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10384: l_pfunc_rev_rate_tbl SYSTEM.pa_num_tbl_type;
10385: l_pfunc_rev_rate_date_tbl SYSTEM.pa_date_tbl_type;

Line 10385: l_pfunc_rev_rate_date_tbl SYSTEM.pa_date_tbl_type;

10381: l_pfunc_cost_rate_date_tbl SYSTEM.pa_date_tbl_type;
10382: l_pfunc_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10383: l_pfunc_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10384: l_pfunc_rev_rate_tbl SYSTEM.pa_num_tbl_type;
10385: l_pfunc_rev_rate_date_tbl SYSTEM.pa_date_tbl_type;
10386: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
10387: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type;
10388: l_etc_quantity_tbl SYSTEM.pa_num_tbl_type;
10389: l_etc_raw_cost_tbl SYSTEM.pa_num_tbl_type;