DBA Data[Home] [Help]

APPS.PA_BUDGET_PUB dependencies on PA_VARCHAR2_30_TBL_TYPE

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

271: -- l_old_model VARCHAR2(1):=null; --3569883
272:
273: -- added for bug Bug 3986129: FP.M Web ADI Dev changes
274: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
275: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
276: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
277:
278: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
279:

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

5083:
5084: l_budget_lines_in budget_line_in_tbl_type;
5085: l_budget_lines_out_tbl budget_line_out_tbl_type;
5086: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5087: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5088: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5089:
5090: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
5091: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;

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

9383: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9384: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9385: l_using_resource_lists_flag VARCHAR2(1);
9386: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9387: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
9388: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9389: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9390: l_amg_project_number pa_projects_all.segment1%TYPE;
9391: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

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

13047:
13048: l_budget_lines_in budget_line_in_tbl_type;
13049: l_budget_lines_out_tbl budget_line_out_tbl_type;
13050: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13051: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
13052: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13053:
13054: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
13055: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;

Line 17244: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

17240: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17241: l_task_number_tbl SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
17242: l_project_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17243: l_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
17244: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
17245: l_resource_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17246: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
17247: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
17248: l_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 17246: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

17242: l_project_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17243: l_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
17244: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
17245: l_resource_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17246: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
17247: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
17248: l_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
17249: l_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
17250:

Line 17257: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

17253: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17254: l_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17255: l_fp_version_ids_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17256:
17257: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
17258: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
17259: l_attribute2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
17260: l_attribute3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
17261: l_attribute4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

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

17321: cnt number:=0;
17322:
17323: -- added for bug Bug 3986129: FP.M Web ADI Dev changes
17324: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17325: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
17326: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17327:
17328: --Added for bug 4224464
17329: l_budget_amount_code pa_budget_types.budget_amount_code%type;

Line 19123: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

19119: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19120: l_project_number pa_projects_all.segment1%type;
19121:
19122: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type;
19123: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
19124: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type;
19125:
19126: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
19127:

Line 19145: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE ;

19141: l_currency_code varchar2(25);
19142: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE;
19143:
19144: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE ;
19145: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE ;
19146: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE ;
19147: l_attribute2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE ;
19148: l_attribute3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE ;
19149: l_attribute4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE ;

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

19201: l_version_type := p_version_type;
19202:
19203:
19204: l_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
19205: l_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
19206: l_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
19207:
19208:
19209: l_planning_start_date_tbl := SYSTEM.pa_date_tbl_type();

Line 19224: l_attribute_category_tbl := SYSTEM.pa_varchar2_30_tbl_type();

19220:
19221: l_currency_code_tbl := SYSTEM.pa_varchar2_15_tbl_type();
19222:
19223: l_assignment_description_tbl := SYSTEM.pa_varchar2_240_tbl_type();
19224: l_attribute_category_tbl := SYSTEM.pa_varchar2_30_tbl_type();
19225: l_attribute1_tbl := SYSTEM.pa_varchar2_150_tbl_type();
19226: l_attribute2_tbl := SYSTEM.pa_varchar2_150_tbl_type();
19227: l_attribute3_tbl := SYSTEM.pa_varchar2_150_tbl_type();
19228: l_attribute4_tbl := SYSTEM.pa_varchar2_150_tbl_type();