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_BUDGET_PUB dependencies on PA_NUM_TBL_TYPE

Line 274: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

270: -- l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE; --3569883
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;

Line 276: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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:
280: BEGIN

Line 5086: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5082: l_resource_name VARCHAR2(80); --bug 3711693
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;

Line 5088: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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;
5092:

Line 8062: l_resource_assignment_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

8058: l_resource_list_member_id NUMBER;
8059: l_currency_code VARCHAR2(15);
8060: l_start_date DATE;
8061:
8062: l_resource_assignment_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8063: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8064: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
8065: l_line_start_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8066: l_line_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 9386: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

9382: lx_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%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;

Line 9388: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_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;
9392: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;

Line 13050: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

13046: l_record_version_number pa_budget_versions.record_version_number%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;

Line 13052: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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;
13056:

Line 14345: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

14341: l_burden_cst_rate_override_tbl l_burdn_cst_rte_override_tbl_t;
14342: l_bill_rate_override_tbl l_bill_rate_override_tbl_t;
14343:
14344:
14345: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
14346: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
14347: l_bdgt_lines_skip_flag varchar2(1);
14348: l_targ_request_id pa_budget_versions.request_id%TYPE;
14349:

Line 16476: l_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(l_budget_version_id);

16472: END IF;
16473: */
16474:
16475: -- populating the l_budget_version_id_tbl with p_budget_version_id
16476: l_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(l_budget_version_id);
16477:
16478: -- Call PJI delete api first to delete existing summarization data
16479: PJI_FM_XBS_ACCUM_MAINT.PLAN_DELETE (
16480: p_fp_version_ids => l_budget_version_id_tbl,

Line 17240: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

17236: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
17237:
17238: /**PLSQL TABLES**/
17239: l_pm_task_reference_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_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();

Line 17242: l_project_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

17238: /**PLSQL TABLES**/
17239: l_pm_task_reference_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_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();

Line 17245: l_resource_list_member_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();
17249: l_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 17251: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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:
17251: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17252: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();

Line 17252: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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:
17251: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17252: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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:

Line 17253: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

17249: l_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
17250:
17251: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17252: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();

Line 17254: l_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

17250:
17251: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17252: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();

Line 17255: l_fp_version_ids_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

17251: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17252: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();

Line 17324: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

17320: t_resource_name VARCHAR2(39);
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

Line 17326: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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;
17330:

Line 19122: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type;

19118: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%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;

Line 19124: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_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:
19128: l_budget_lines_in_tbl PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE;

Line 19139: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

19135:
19136: l_uom_tbl SYSTEM.pa_varchar2_80_tbl_type;
19137: l_mfc_cost_type_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE;
19138:
19139: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
19140:
19141: l_currency_code varchar2(25);
19142: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE;
19143:

Line 19204: l_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();

19200: l_fin_plan_type_name := p_fin_plan_type_name;
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:

Line 19206: l_spread_curve_id_tbl := SYSTEM.pa_num_tbl_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();
19210: l_planning_end_date_tbl := SYSTEM.pa_date_tbl_type();

Line 19218: l_resource_assignment_id_tbl := SYSTEM.pa_num_tbl_type();

19214:
19215: l_uom_tbl := SYSTEM.pa_varchar2_80_tbl_type();
19216: l_mfc_cost_type_tbl := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
19217:
19218: l_resource_assignment_id_tbl := SYSTEM.pa_num_tbl_type();
19219:
19220:
19221: l_currency_code_tbl := SYSTEM.pa_varchar2_15_tbl_type();
19222: