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 5197: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

5193:
5194: l_budget_lines_in budget_line_in_tbl_type;
5195: l_budget_lines_out_tbl budget_line_out_tbl_type;
5196: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5197: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5198: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5199:
5200: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
5201: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;

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

9566: lx_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%type;
9567: lx_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%type;
9568: l_using_resource_lists_flag VARCHAR2(1);
9569: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9570: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
9571: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9572: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9573: l_amg_project_number pa_projects_all.segment1%TYPE;
9574: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

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

13270:
13271: l_budget_lines_in budget_line_in_tbl_type;
13272: l_budget_lines_out_tbl budget_line_out_tbl_type;
13273: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13274: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
13275: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13276:
13277: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
13278: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;

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

17499: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17500: l_task_number_tbl SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
17501: l_project_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17502: l_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
17503: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
17504: l_resource_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17505: l_cbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17506: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
17507: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

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

17502: l_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
17503: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
17504: l_resource_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17505: l_cbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17506: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
17507: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
17508: l_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
17509: l_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
17510:

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

17513: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17514: l_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17515: l_fp_version_ids_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17516:
17517: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
17518: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
17519: l_attribute2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
17520: l_attribute3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
17521: l_attribute4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

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

17581: cnt number:=0;
17582:
17583: -- added for bug Bug 3986129: FP.M Web ADI Dev changes
17584: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17585: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
17586: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17587:
17588: --Added for bug 4224464
17589: l_budget_amount_code pa_budget_types.budget_amount_code%type;

Line 19417: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type;

19413: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19414: l_project_number pa_projects_all.segment1%type;
19415:
19416: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type;
19417: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
19418: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type;
19419:
19420: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
19421:

Line 19439: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE ;

19435: l_currency_code varchar2(25);
19436: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE;
19437:
19438: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE ;
19439: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE ;
19440: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE ;
19441: l_attribute2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE ;
19442: l_attribute3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE ;
19443: l_attribute4_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE ;

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

19535: l_version_type := p_version_type;
19536:
19537:
19538: l_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
19539: l_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
19540: l_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
19541:
19542:
19543: l_planning_start_date_tbl := SYSTEM.pa_date_tbl_type();

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

19554:
19555: l_currency_code_tbl := SYSTEM.pa_varchar2_15_tbl_type();
19556:
19557: l_assignment_description_tbl := SYSTEM.pa_varchar2_240_tbl_type();
19558: l_attribute_category_tbl := SYSTEM.pa_varchar2_30_tbl_type();
19559: l_attribute1_tbl := SYSTEM.pa_varchar2_150_tbl_type();
19560: l_attribute2_tbl := SYSTEM.pa_varchar2_150_tbl_type();
19561: l_attribute3_tbl := SYSTEM.pa_varchar2_150_tbl_type();
19562: l_attribute4_tbl := SYSTEM.pa_varchar2_150_tbl_type();