2987: PROCEDURE calc_rate_amount(
2988:
2989: p_calling_mode IN VARCHAR2 , /* possible values 'ASSIGNMENT','ROLE','UNASSIGNED' */
2990: /* for Org forecasting */
2991: p_rate_calc_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp ,
2992: p_asgn_start_date IN DATE ,
2993: p_item_id IN NUMBER ,
2994: p_project_id IN NUMBER ,
2995: p_quantity_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
2991: p_rate_calc_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp ,
2992: p_asgn_start_date IN DATE ,
2993: p_item_id IN NUMBER ,
2994: p_project_id IN NUMBER ,
2995: p_quantity_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
2996: p_forecast_job_id IN NUMBER DEFAULT NULL,
2997: p_forecast_job_group_id IN NUMBER DEFAULT NULL,
2998: p_person_id IN NUMBER DEFAULT NULL,
2999: p_expenditure_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
2995: p_quantity_tab IN PA_PLSQL_DATATYPES.NumTabTyp,
2996: p_forecast_job_id IN NUMBER DEFAULT NULL,
2997: p_forecast_job_group_id IN NUMBER DEFAULT NULL,
2998: p_person_id IN NUMBER DEFAULT NULL,
2999: p_expenditure_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
3000: p_expenditure_type IN VARCHAR2 DEFAULT NULL,
3001: p_expenditure_orgz_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp ,
3002: p_project_org_id IN NUMBER DEFAULT NULL,
3003: p_labor_cost_multi_name IN VARCHAR2 DEFAULT NULL,
2997: p_forecast_job_group_id IN NUMBER DEFAULT NULL,
2998: p_person_id IN NUMBER DEFAULT NULL,
2999: p_expenditure_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
3000: p_expenditure_type IN VARCHAR2 DEFAULT NULL,
3001: p_expenditure_orgz_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp ,
3002: p_project_org_id IN NUMBER DEFAULT NULL,
3003: p_labor_cost_multi_name IN VARCHAR2 DEFAULT NULL,
3004: p_proj_cost_job_group_id IN NUMBER DEFAULT NULL,
3005: p_job_cost_rate_schedule_id IN NUMBER DEFAULT NULL,
3011: p_job_bill_rate_schedule_id IN NUMBER DEFAULT NULL,
3012: p_distribution_rule IN VARCHAR2 DEFAULT NULL,
3013: p_amount_calc_mode IN VARCHAR2 DEFAULT 'ALL', /* Possible values 'ALL','COST','REVENUE' */
3014: /* Added fro Org Forecasting*/
3015: P_system_linkage IN PA_PLSQL_DATATYPES.Char30TabTyp,/* Added */
3016: /* for Org Forecasting */
3017: p_assign_precedes_task IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
3018: p_labor_schdl_discnt IN NUMBER DEFAULT NULL, /* Added for Org Forecasting */
3019: p_labor_bill_rate_org_id IN NUMBER DEFAULT NULL, /* Added for Org Forecasting */
3019: p_labor_bill_rate_org_id IN NUMBER DEFAULT NULL, /* Added for Org Forecasting */
3020: p_labor_std_bill_rate_schdl IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
3021: p_labor_schedule_fixed_date IN DATE DEFAULT NULL, /* Added for Org Forecasting */
3022: p_labor_sch_type IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
3023: p_forecast_item_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp, /* Added para for bug 2212852 */
3024: p_forecasting_type IN VARCHAR2 DEFAULT 'PROJECT_FORECASTING',/*Added par for bug2212852*/
3025: p_projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
3026: p_projfunc_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3027: p_projfunc_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3022: p_labor_sch_type IN VARCHAR2 DEFAULT NULL, /* Added for Org Forecasting */
3023: p_forecast_item_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp, /* Added para for bug 2212852 */
3024: p_forecasting_type IN VARCHAR2 DEFAULT 'PROJECT_FORECASTING',/*Added par for bug2212852*/
3025: p_projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
3026: p_projfunc_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3027: p_projfunc_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3028: p_projfunc_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3029: p_projfunc_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for Org Forecasting */
3030: p_projfunc_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3023: p_forecast_item_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp, /* Added para for bug 2212852 */
3024: p_forecasting_type IN VARCHAR2 DEFAULT 'PROJECT_FORECASTING',/*Added par for bug2212852*/
3025: p_projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
3026: p_projfunc_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3027: p_projfunc_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3028: p_projfunc_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3029: p_projfunc_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for Org Forecasting */
3030: p_projfunc_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3031: p_projfunc_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3024: p_forecasting_type IN VARCHAR2 DEFAULT 'PROJECT_FORECASTING',/*Added par for bug2212852*/
3025: p_projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
3026: p_projfunc_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3027: p_projfunc_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3028: p_projfunc_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3029: p_projfunc_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for Org Forecasting */
3030: p_projfunc_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3031: p_projfunc_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3032: x_projfunc_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3025: p_projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
3026: p_projfunc_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3027: p_projfunc_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3028: p_projfunc_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3029: p_projfunc_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for Org Forecasting */
3030: p_projfunc_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3031: p_projfunc_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3032: x_projfunc_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3033: x_projfunc_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3026: p_projfunc_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3027: p_projfunc_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3028: p_projfunc_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3029: p_projfunc_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for Org Forecasting */
3030: p_projfunc_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3031: p_projfunc_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3032: x_projfunc_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3033: x_projfunc_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3034: x_projfunc_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3027: p_projfunc_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3028: p_projfunc_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3029: p_projfunc_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for Org Forecasting */
3030: p_projfunc_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3031: p_projfunc_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3032: x_projfunc_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3033: x_projfunc_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3034: x_projfunc_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3035: x_projfunc_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3028: p_projfunc_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3029: p_projfunc_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for Org Forecasting */
3030: p_projfunc_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3031: p_projfunc_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3032: x_projfunc_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3033: x_projfunc_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3034: x_projfunc_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3035: x_projfunc_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3036: x_projfunc_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3029: p_projfunc_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for Org Forecasting */
3030: p_projfunc_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3031: p_projfunc_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3032: x_projfunc_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3033: x_projfunc_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3034: x_projfunc_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3035: x_projfunc_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3036: x_projfunc_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3037: x_projfunc_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3030: p_projfunc_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for Org Forecasting */
3031: p_projfunc_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3032: x_projfunc_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3033: x_projfunc_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3034: x_projfunc_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3035: x_projfunc_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3036: x_projfunc_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3037: x_projfunc_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3038: x_projfunc_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3031: p_projfunc_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for Org Forecasting */
3032: x_projfunc_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3033: x_projfunc_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3034: x_projfunc_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3035: x_projfunc_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3036: x_projfunc_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3037: x_projfunc_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3038: x_projfunc_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3039: x_projfunc_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3032: x_projfunc_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3033: x_projfunc_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3034: x_projfunc_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3035: x_projfunc_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3036: x_projfunc_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3037: x_projfunc_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3038: x_projfunc_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3039: x_projfunc_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3040: x_projfunc_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3033: x_projfunc_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3034: x_projfunc_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3035: x_projfunc_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3036: x_projfunc_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3037: x_projfunc_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3038: x_projfunc_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3039: x_projfunc_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3040: x_projfunc_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3041: x_projfunc_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3034: x_projfunc_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3035: x_projfunc_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3036: x_projfunc_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3037: x_projfunc_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3038: x_projfunc_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3039: x_projfunc_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3040: x_projfunc_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3041: x_projfunc_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3042: x_projfunc_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3035: x_projfunc_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3036: x_projfunc_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3037: x_projfunc_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3038: x_projfunc_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3039: x_projfunc_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3040: x_projfunc_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3041: x_projfunc_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3042: x_projfunc_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3043: x_projfunc_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3036: x_projfunc_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3037: x_projfunc_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3038: x_projfunc_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3039: x_projfunc_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3040: x_projfunc_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3041: x_projfunc_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3042: x_projfunc_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3043: x_projfunc_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3044: p_project_currency_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
3037: x_projfunc_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3038: x_projfunc_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3039: x_projfunc_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3040: x_projfunc_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3041: x_projfunc_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3042: x_projfunc_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3043: x_projfunc_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3044: p_project_currency_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
3045: p_project_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3038: x_projfunc_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3039: x_projfunc_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3040: x_projfunc_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3041: x_projfunc_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3042: x_projfunc_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3043: x_projfunc_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3044: p_project_currency_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
3045: p_project_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3046: p_project_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3039: x_projfunc_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3040: x_projfunc_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3041: x_projfunc_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3042: x_projfunc_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3043: x_projfunc_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3044: p_project_currency_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
3045: p_project_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3046: p_project_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3047: p_project_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3041: x_projfunc_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3042: x_projfunc_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3043: x_projfunc_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3044: p_project_currency_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
3045: p_project_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3046: p_project_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3047: p_project_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3048: p_project_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */
3049: p_project_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3042: x_projfunc_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3043: x_projfunc_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3044: p_project_currency_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
3045: p_project_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3046: p_project_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3047: p_project_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3048: p_project_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */
3049: p_project_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3050: p_project_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3043: x_projfunc_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3044: p_project_currency_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
3045: p_project_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3046: p_project_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3047: p_project_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3048: p_project_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */
3049: p_project_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3050: p_project_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3051: x_project_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3044: p_project_currency_code IN VARCHAR2 DEFAULT NULL, /* Added for org Forecasting */
3045: p_project_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3046: p_project_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3047: p_project_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3048: p_project_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */
3049: p_project_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3050: p_project_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3051: x_project_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3052: x_project_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3045: p_project_rev_rt_dt_code_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3046: p_project_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3047: p_project_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3048: p_project_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */
3049: p_project_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3050: p_project_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3051: x_project_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3052: x_project_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3053: x_project_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3046: p_project_rev_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3047: p_project_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3048: p_project_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */
3049: p_project_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3050: p_project_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3051: x_project_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3052: x_project_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3053: x_project_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3054: x_project_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3047: p_project_rev_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3048: p_project_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */
3049: p_project_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3050: p_project_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3051: x_project_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3052: x_project_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3053: x_project_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3054: x_project_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3055: x_project_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3048: p_project_rev_exch_rt_tab IN PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */
3049: p_project_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3050: p_project_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3051: x_project_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3052: x_project_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3053: x_project_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3054: x_project_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3055: x_project_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3056: x_project_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3049: p_project_cst_rt_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */
3050: p_project_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3051: x_project_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3052: x_project_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3053: x_project_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3054: x_project_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3055: x_project_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3056: x_project_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3057: x_project_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3050: p_project_cst_rt_type_tab IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */
3051: x_project_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3052: x_project_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3053: x_project_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3054: x_project_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3055: x_project_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3056: x_project_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3057: x_project_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3058: x_project_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3051: x_project_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3052: x_project_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3053: x_project_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3054: x_project_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3055: x_project_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3056: x_project_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3057: x_project_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3058: x_project_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3059: x_project_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3052: x_project_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3053: x_project_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3054: x_project_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3055: x_project_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3056: x_project_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3057: x_project_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3058: x_project_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3059: x_project_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3060: x_project_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3053: x_project_rev_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3054: x_project_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3055: x_project_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3056: x_project_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3057: x_project_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3058: x_project_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3059: x_project_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3060: x_project_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3061: x_project_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3054: x_project_rev_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3055: x_project_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3056: x_project_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3057: x_project_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3058: x_project_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3059: x_project_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3060: x_project_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3061: x_project_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3062: x_project_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3055: x_project_rev_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3056: x_project_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3057: x_project_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3058: x_project_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3059: x_project_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3060: x_project_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3061: x_project_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3062: x_project_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3063: x_exp_func_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3056: x_project_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3057: x_project_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3058: x_project_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3059: x_project_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3060: x_project_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3061: x_project_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3062: x_project_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3063: x_exp_func_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3064: x_exp_func_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3057: x_project_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3058: x_project_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3059: x_project_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3060: x_project_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3061: x_project_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3062: x_project_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3063: x_exp_func_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3064: x_exp_func_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3065: x_exp_func_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3058: x_project_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3059: x_project_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3060: x_project_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3061: x_project_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3062: x_project_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3063: x_exp_func_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3064: x_exp_func_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3065: x_exp_func_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3066: x_exp_func_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3059: x_project_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3060: x_project_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3061: x_project_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3062: x_project_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3063: x_exp_func_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3064: x_exp_func_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3065: x_exp_func_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3066: x_exp_func_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3067: x_exp_func_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3060: x_project_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3061: x_project_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3062: x_project_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3063: x_exp_func_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3064: x_exp_func_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3065: x_exp_func_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3066: x_exp_func_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3067: x_exp_func_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3068: x_exp_func_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3061: x_project_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3062: x_project_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3063: x_exp_func_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3064: x_exp_func_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3065: x_exp_func_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3066: x_exp_func_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3067: x_exp_func_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3068: x_exp_func_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3069: x_exp_func_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3062: x_project_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3063: x_exp_func_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3064: x_exp_func_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3065: x_exp_func_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3066: x_exp_func_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3067: x_exp_func_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3068: x_exp_func_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3069: x_exp_func_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3070: x_exp_func_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3063: x_exp_func_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3064: x_exp_func_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3065: x_exp_func_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3066: x_exp_func_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3067: x_exp_func_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3068: x_exp_func_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3069: x_exp_func_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3070: x_exp_func_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3071: x_cst_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3064: x_exp_func_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3065: x_exp_func_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3066: x_exp_func_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3067: x_exp_func_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3068: x_exp_func_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3069: x_exp_func_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3070: x_exp_func_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3071: x_cst_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3072: x_txn_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3065: x_exp_func_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3066: x_exp_func_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3067: x_exp_func_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3068: x_exp_func_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3069: x_exp_func_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3070: x_exp_func_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3071: x_cst_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3072: x_txn_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3073: x_txn_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3066: x_exp_func_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3067: x_exp_func_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3068: x_exp_func_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3069: x_exp_func_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3070: x_exp_func_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3071: x_cst_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3072: x_txn_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3073: x_txn_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3074: x_txn_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3067: x_exp_func_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3068: x_exp_func_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3069: x_exp_func_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3070: x_exp_func_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3071: x_cst_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3072: x_txn_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3073: x_txn_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3074: x_txn_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3075: x_txn_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3068: x_exp_func_cst_rt_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3069: x_exp_func_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3070: x_exp_func_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3071: x_cst_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3072: x_txn_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3073: x_txn_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3074: x_txn_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3075: x_txn_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3076: x_rev_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3069: x_exp_func_cst_rt_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3070: x_exp_func_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3071: x_cst_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3072: x_txn_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3073: x_txn_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3074: x_txn_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3075: x_txn_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3076: x_rev_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3077: x_txn_rev_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3070: x_exp_func_cst_exch_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3071: x_cst_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3072: x_txn_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3073: x_txn_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3074: x_txn_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3075: x_txn_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3076: x_rev_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3077: x_txn_rev_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3078: x_txn_rev_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3071: x_cst_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3072: x_txn_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3073: x_txn_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3074: x_txn_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3075: x_txn_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3076: x_rev_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3077: x_txn_rev_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3078: x_txn_rev_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3079: x_error_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3072: x_txn_raw_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp , --File.Sql.39 bug 4440895
3073: x_txn_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3074: x_txn_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3075: x_txn_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3076: x_rev_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3077: x_txn_rev_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3078: x_txn_rev_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3079: x_error_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3080: x_rev_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3073: x_txn_raw_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3074: x_txn_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3075: x_txn_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3076: x_rev_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3077: x_txn_rev_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3078: x_txn_rev_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3079: x_error_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3080: x_rev_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3081: x_cst_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3074: x_txn_burdned_cst_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3075: x_txn_burdned_cst_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
3076: x_rev_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3077: x_txn_rev_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3078: x_txn_rev_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3079: x_error_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3080: x_rev_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3081: x_cst_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3082: x_burdned_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3076: x_rev_txn_curr_code_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char15TabTyp, /* Added for Org Forecasting */ --File.Sql.39 bug 4440895
3077: x_txn_rev_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3078: x_txn_rev_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3079: x_error_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3080: x_rev_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3081: x_cst_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3082: x_burdned_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3083: x_others_rejct_reason_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed for Org Forecasting */ --File.Sql.39 bug 4440895
3084: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3077: x_txn_rev_bill_rt_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3078: x_txn_rev_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3079: x_error_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3080: x_rev_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3081: x_cst_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3082: x_burdned_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3083: x_others_rejct_reason_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed for Org Forecasting */ --File.Sql.39 bug 4440895
3084: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3085: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3078: x_txn_rev_raw_revenue_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, /* Added for org Forecasting */ --File.Sql.39 bug 4440895
3079: x_error_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3080: x_rev_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3081: x_cst_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3082: x_burdned_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3083: x_others_rejct_reason_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed for Org Forecasting */ --File.Sql.39 bug 4440895
3084: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3085: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3086: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3079: x_error_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3080: x_rev_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3081: x_cst_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3082: x_burdned_rejct_reason_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
3083: x_others_rejct_reason_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, /* Changed for Org Forecasting */ --File.Sql.39 bug 4440895
3084: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3085: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3086: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3087: IS
3085: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3086: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3087: IS
3088: l_rate_calc_date DATE;
3089: l_rate_calc_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
3090: l_quantity NUMBER;
3091: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;
3092: l_expenditure_orgz_id pa_project_assignments.expenditure_organization_id%TYPE;
3093: /* MCB2 related changes */