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_VARCHAR2_30_TBL_TYPE

Line 1013: p_error_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

1009: PROCEDURE process_errors
1010: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
1011: p_context IN VARCHAR2,
1012: p_periodic_flag IN VARCHAR2,
1013: p_error_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1014: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1015: p_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1016: p_txn_curr_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1017: p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 1016: p_txn_curr_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

1012: p_periodic_flag IN VARCHAR2,
1013: p_error_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1014: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1015: p_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1016: p_txn_curr_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1017: p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1018: p_request_id IN pa_budget_versions.request_id%TYPE,
1019: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1020: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1017: p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

1013: p_error_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1014: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1015: p_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1016: p_txn_curr_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1017: p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1018: p_request_id IN pa_budget_versions.request_id%TYPE,
1019: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1020: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1021: x_msg_count OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895

Line 1286: l_err_val_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

1282: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
1283: l_msg_index_out NUMBER;
1284: l_data VARCHAR2(2000);
1285:
1286: l_err_val_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1287: l_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1288: l_err_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1289: l_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1290:

Line 1289: l_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

1285:
1286: l_err_val_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1287: l_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1288: l_err_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1289: l_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1290:
1291: BEGIN
1292: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1293: x_msg_count := 0;

Line 1687: x_res_class_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_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
1687: x_res_class_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
1688: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895
1689: x_rbs_elem_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1690: x_cbs_elem_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, -- cbs enhancement changes bug#16445106
1691: x_amt_type_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895

Line 1691: x_amt_type_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895

1687: x_res_class_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
1688: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE, --File.Sql.39 bug 4440895
1689: x_rbs_elem_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1690: x_cbs_elem_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, -- cbs enhancement changes bug#16445106
1691: x_amt_type_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
1692: x_first_pd_bf_pm_en_dt OUT NOCOPY DATE, --File.Sql.39 bug 4440895
1693: x_last_pd_af_pm_st_dt OUT NOCOPY DATE, --File.Sql.39 bug 4440895
1694: x_inf_tbl_rec_tbl OUT NOCOPY inf_cur_tbl_typ, --File.Sql.39 bug 4440895
1695: x_num_of_rec_processed OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1805: d_txn_curr_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

1801: d_projfunc_cost_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1802: d_projfunc_rev_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1803: d_project_cost_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1804: d_project_rev_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1805: d_txn_curr_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1806:
1807: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
1808: l_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1809: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

Line 1848: l_err_val_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
1849: l_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1850: l_err_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1851: l_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1852: l_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 1851: l_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

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();
1849: l_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1850: l_err_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1851: l_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1852: l_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1853:
1854: l_fixed_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
1855: l_fixed_spread_curve_name pa_spread_curves_tl.name%TYPE;

Line 1852: l_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

1848: l_err_val_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1849: l_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1850: l_err_rlm_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1851: l_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1852: l_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1853:
1854: l_fixed_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
1855: l_fixed_spread_curve_name pa_spread_curves_tl.name%TYPE;
1856: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;

Line 1971: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

1967: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
1968: l_rbs_elem_id pa_resource_assignments.rbs_element_id%TYPE;
1969:
1970: l_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1971: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1972: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
1973: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1974:
1975: l_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();-- cbs enhancement changes bug#16445106

Line 1981: l_amount_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

1977:
1978: l_min_ra_plan_start_date DATE;
1979: l_max_ra_plan_end_date DATE;
1980:
1981: l_amount_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1982: l_lookup_type pa_lookups.lookup_type%TYPE;
1983: l_amount NUMBER;
1984: --l_temp DATE;
1985:

Line 6802: p_etc_method_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type ,

6798: p_burd_cost_rate_tbl IN SYSTEM.pa_num_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,

Line 6804: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_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
6808: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type ,

Line 6825: x_proj_cost_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_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
6829: x_proj_rev_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895

Line 6826: x_proj_cost_rate_date_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_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
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

Line 6829: x_proj_rev_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_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
6833: x_pfunc_cost_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895

Line 6830: x_proj_rev_rate_date_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
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

Line 6833: x_pfunc_cost_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_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
6837: x_pfunc_rev_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895

Line 6834: x_pfunc_cost_rate_date_typ_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
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

Line 6837: x_pfunc_rev_rate_type_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_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
6841: x_delete_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895

Line 6838: x_pfunc_rev_rate_date_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
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

Line 6844: x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_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
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

Line 6846: x_res_class_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_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
6850: x_description_tbl OUT NOCOPY SYSTEM.pa_varchar2_2000_tbl_type, --File.Sql.39 bug 4440895

Line 6849: x_change_reason_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
6850: x_description_tbl OUT NOCOPY SYSTEM.pa_varchar2_2000_tbl_type, --File.Sql.39 bug 4440895
6851: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6852: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6853: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 7086: x_proj_cost_rate_type_tbl := SYSTEM.pa_varchar2_30_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();
7090: x_proj_rev_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();

Line 7087: x_proj_cost_rate_date_type_tbl := SYSTEM.pa_varchar2_30_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();
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();

Line 7090: x_proj_rev_rate_type_tbl := SYSTEM.pa_varchar2_30_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();
7094: x_pfunc_cost_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();

Line 7091: x_proj_rev_rate_date_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();
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();

Line 7094: x_pfunc_cost_rate_type_tbl := SYSTEM.pa_varchar2_30_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();
7098: x_pfunc_rev_rate_type_tbl := SYSTEM.pa_varchar2_30_tbl_type();

Line 7095: x_pfunc_cost_rate_date_typ_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();
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();

Line 7098: x_pfunc_rev_rate_type_tbl := SYSTEM.pa_varchar2_30_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();
7102: x_delete_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();

Line 7099: x_pfunc_rev_rate_date_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();
7102: x_delete_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7103: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();

Line 7105: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_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();
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();

Line 7107: x_res_class_code_tbl := SYSTEM.pa_varchar2_30_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();
7111: x_description_tbl := SYSTEM.pa_varchar2_2000_tbl_type();

Line 7110: x_change_reason_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();
7111: x_description_tbl := SYSTEM.pa_varchar2_2000_tbl_type();
7112:
7113: --DEBUG_NS('p_context :: ' || p_context);
7114:

Line 8128: p_etc_method_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),

8124: p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),-- cbs enhancement changes bug#16445106
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(),

Line 8130: p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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(),
8134: p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),

Line 8145: p_proj_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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(),
8149: p_proj_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),

Line 8146: p_proj_cost_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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(),
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(),

Line 8149: p_proj_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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(),
8153: p_pfunc_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),

Line 8150: p_proj_rev_rate_date_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(),
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(),

Line 8153: p_pfunc_cost_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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(),
8157: p_pfunc_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),

Line 8154: p_pfunc_cost_rate_date_typ_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(),
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(),

Line 8157: p_pfunc_rev_rate_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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(),
8161: p_change_reason_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),

Line 8158: p_pfunc_rev_rate_date_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(),
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(),

Line 8161: p_change_reason_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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
8165: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 8189: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8185: l_cbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();-- cbs enhancement changes bug#16445106
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();

Line 8191: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8195: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8206: l_proj_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8210: l_proj_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8207: l_proj_cost_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
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();

Line 8210: l_proj_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8214: l_pfunc_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8211: l_proj_rev_rate_date_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();
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();

Line 8214: l_pfunc_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8218: l_pfunc_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8215: l_pfunc_cost_rate_date_typ_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();
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();

Line 8218: l_pfunc_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8222: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8219: l_pfunc_rev_rate_date_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();
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();

Line 8222: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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:
8226: -- variables to copy the records with delete_flag = Y

Line 8233: l_df_etc_method_code SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8229: l_df_cbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();-- cbs enhancement changes bug#16445106
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();

Line 8235: l_df_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8239: l_df_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 8250: l_df_pj_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8254: l_df_pj_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8251: l_df_pj_cost_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
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();

Line 8254: l_df_pj_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8258: l_df_pf_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8255: l_df_pj_rev_rate_date_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();
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();

Line 8258: l_df_pf_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8262: l_df_pf_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8259: l_df_pf_cost_rate_date_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();
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();

Line 8262: l_df_pf_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8266: l_df_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8263: l_df_pf_rev_rate_date_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();
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();

Line 8266: l_df_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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;
8270: l_curr_ra_id_seq NUMBER;

Line 8293: l_bl_del_flag_pf_cr_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
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();

Line 8294: l_bl_del_flag_pf_cr_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
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();

Line 8297: l_bl_del_flag_pf_rr_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8301: l_bl_del_flag_pj_curr_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();

Line 8298: l_bl_del_flag_pf_rr_dt_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();
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();

Line 8302: l_bl_del_flag_pj_cr_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();
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();

Line 8303: l_bl_del_flag_pj_cr_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();
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();

Line 8306: l_bl_del_flag_pj_rr_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8310: l_bl_del_flag_bl_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8307: l_bl_del_flag_pj_rr_dt_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();
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();

Line 8311: l_bl_del_flag_per_name_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();
8314: l_bl_del_flag_pj_rev_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8315: l_bl_del_flag_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8319: l_bl_del_flag_c_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8315: l_bl_del_flag_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8316: l_bl_del_flag_burd_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8317: l_bl_del_flag_rev_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8318: l_bl_del_flag_qty_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8319: l_bl_del_flag_c_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8320: l_bl_del_flag_b_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8321: l_bl_del_flag_r_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8322: l_bl_del_flag_o_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8323: l_bl_del_fg_pc_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8320: l_bl_del_flag_b_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8316: l_bl_del_flag_burd_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8317: l_bl_del_flag_rev_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8318: l_bl_del_flag_qty_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8319: l_bl_del_flag_c_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8320: l_bl_del_flag_b_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8321: l_bl_del_flag_r_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8322: l_bl_del_flag_o_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8323: l_bl_del_fg_pc_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8324: l_bl_del_fg_pf_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8321: l_bl_del_flag_r_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8317: l_bl_del_flag_rev_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8318: l_bl_del_flag_qty_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8319: l_bl_del_flag_c_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8320: l_bl_del_flag_b_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8321: l_bl_del_flag_r_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8322: l_bl_del_flag_o_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8323: l_bl_del_fg_pc_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8324: l_bl_del_fg_pf_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8325:

Line 8322: l_bl_del_flag_o_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8318: l_bl_del_flag_qty_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8319: l_bl_del_flag_c_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8320: l_bl_del_flag_b_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8321: l_bl_del_flag_r_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8322: l_bl_del_flag_o_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8323: l_bl_del_fg_pc_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8324: l_bl_del_fg_pf_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8325:
8326:

Line 8323: l_bl_del_fg_pc_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8319: l_bl_del_flag_c_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8320: l_bl_del_flag_b_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8321: l_bl_del_flag_r_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8322: l_bl_del_flag_o_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8323: l_bl_del_fg_pc_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8324: l_bl_del_fg_pf_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8325:
8326:
8327: -- for budget line context to spread the amounts

Line 8324: l_bl_del_fg_pf_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8320: l_bl_del_flag_b_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8321: l_bl_del_flag_r_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8322: l_bl_del_flag_o_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8323: l_bl_del_fg_pc_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8324: l_bl_del_fg_pf_cnv_rej_cd_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8325:
8326:
8327: -- for budget line context to spread the amounts
8328: l_new_ra_id pa_resource_assignments.resource_assignment_id%TYPE;

Line 8333: l_pji_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8329: l_calc_calling_context VARCHAR2(30);
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();

Line 8346: l_pji_cost_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8342: l_pji_project_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8343: l_pji_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8344: l_pji_burd_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8345: l_pji_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8346: l_pji_cost_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8347: l_pji_revenue_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8348: l_pji_burden_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8349: l_pji_other_rej_code SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8350: l_pji_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8347: l_pji_revenue_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8343: l_pji_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8344: l_pji_burd_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8345: l_pji_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8346: l_pji_cost_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8347: l_pji_revenue_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8348: l_pji_burden_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8349: l_pji_other_rej_code SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8350: l_pji_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8351: l_pji_pf_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8348: l_pji_burden_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8344: l_pji_burd_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8345: l_pji_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8346: l_pji_cost_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8347: l_pji_revenue_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8348: l_pji_burden_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8349: l_pji_other_rej_code SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8350: l_pji_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8351: l_pji_pf_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8352: l_pji_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8349: l_pji_other_rej_code SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8345: l_pji_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8346: l_pji_cost_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8347: l_pji_revenue_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8348: l_pji_burden_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8349: l_pji_other_rej_code SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8350: l_pji_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8351: l_pji_pf_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8352: l_pji_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8353:

Line 8350: l_pji_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8346: l_pji_cost_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8347: l_pji_revenue_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8348: l_pji_burden_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8349: l_pji_other_rej_code SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8350: l_pji_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8351: l_pji_pf_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8352: l_pji_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8353:
8354: --This table will hold the distinct NEW resource assignments passed to this API for processing (excluding delete flag = Y recs)

Line 8351: l_pji_pf_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8347: l_pji_revenue_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8348: l_pji_burden_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8349: l_pji_other_rej_code SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8350: l_pji_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8351: l_pji_pf_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8352: l_pji_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8353:
8354: --This table will hold the distinct NEW resource assignments passed to this API for processing (excluding delete flag = Y recs)
8355: --Index will be in the following format : 'T' || || 'R' ||

Line 8394: l_upd_pj_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8390: l_upd_txn_init_burd_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8391: l_upd_txn_init_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8392: l_upd_budget_line_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();

Line 8396: l_upd_pj_cost_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8392: l_upd_budget_line_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();

Line 8398: l_upd_pj_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8402: l_upd_pf_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8400: l_upd_pj_rev_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
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();

Line 8402: l_upd_pf_cost_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8406: l_upd_pf_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8404: l_upd_pf_cost_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
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();

Line 8406: l_upd_pf_rev_rate_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
8410: --Bug 4424457

Line 8408: l_upd_pf_rev_rate_dt_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();
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);

Line 8415: l_chg_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

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);
8414: l_dest_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8415: l_chg_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8416: l_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8417:
8418: --bug 5962744
8419: l_extra_bl_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 8420: l_ex_chg_rsn_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

8416: l_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8417:
8418: --bug 5962744
8419: l_extra_bl_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8420: l_ex_chg_rsn_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8421: l_ex_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8422: l_ra_exists VARCHAR2(1);
8423: l_extra_bls_exists VARCHAR2(1);
8424: j INTEGER;

Line 10348: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

10344: l_error_indicator_flag VARCHAR2(1);
10345:
10346: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10347: l_mfc_cost_type_id_tbl_1 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10348: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
10349: l_etc_method_code_tbl_1 SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
10350:
10351: is_periodic_setup VARCHAR2(1) := 'N';
10352: l_prep_pbl_calling_context VARCHAR2(30);

Line 10349: l_etc_method_code_tbl_1 SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

10345:
10346: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10347: l_mfc_cost_type_id_tbl_1 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10348: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
10349: l_etc_method_code_tbl_1 SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
10350:
10351: is_periodic_setup VARCHAR2(1) := 'N';
10352: l_prep_pbl_calling_context VARCHAR2(30);
10353: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

Line 10370: l_proj_cost_rate_type_tbl SYSTEM.pa_varchar2_30_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;
10374: l_proj_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;

Line 10371: l_proj_cost_rate_date_type_tbl SYSTEM.pa_varchar2_30_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;
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;

Line 10374: l_proj_rev_rate_type_tbl SYSTEM.pa_varchar2_30_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;
10378: l_pfunc_cost_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;

Line 10375: l_proj_rev_rate_date_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;
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;

Line 10378: l_pfunc_cost_rate_type_tbl SYSTEM.pa_varchar2_30_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;
10382: l_pfunc_rev_rate_type_tbl SYSTEM.pa_varchar2_30_tbl_type;

Line 10379: l_pfunc_cost_rate_date_typ_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;
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;

Line 10382: l_pfunc_rev_rate_type_tbl SYSTEM.pa_varchar2_30_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;
10386: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

Line 10383: l_pfunc_rev_rate_date_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;
10386: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
10387: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type;

Line 10386: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_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;
10390: l_etc_burdened_cost_tbl SYSTEM.pa_num_tbl_type;

Line 10392: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

10388: l_etc_quantity_tbl SYSTEM.pa_num_tbl_type;
10389: l_etc_raw_cost_tbl SYSTEM.pa_num_tbl_type;
10390: l_etc_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
10391: l_etc_revenue_tbl SYSTEM.pa_num_tbl_type;
10392: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
10393: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10394: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10395: l_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type; -- cbs enhancement changes bug#16445106
10396: l_amt_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 10396: l_amt_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

10392: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
10393: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10394: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10395: l_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type; -- cbs enhancement changes bug#16445106
10396: l_amt_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
10397: l_prc_ra_id_tbl SYSTEM.pa_num_tbl_type;
10398: l_prc_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
10399: l_prc_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
10400: l_prc_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;

Line 10398: l_prc_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

10394: l_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10395: l_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type; -- cbs enhancement changes bug#16445106
10396: l_amt_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
10397: l_prc_ra_id_tbl SYSTEM.pa_num_tbl_type;
10398: l_prc_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
10399: l_prc_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
10400: l_prc_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10401: l_prc_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type;-- cbs enhancement changes bug#16445106
10402: