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

Line 321: l_fc_plan_type_ids_tbl SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

317: l_curr_work_fp_opt_id pa_proj_fp_options.proj_fp_options_id%TYPE;
318: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
319: l_auto_baseline_project pa_projects_all.baseline_funding_flag%TYPE;
320:
321: l_fc_plan_type_ids_tbl SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
322: l_fc_pt_pref_code_tbl SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type();
323: l_primary_cost_fcst_flag_tbl SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
324: l_primary_rev_fcst_flag_tbl SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
325: l_dummy VARCHAR2(1);

Line 328: l_temp_ci_id_tbl SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(); -- Bug 3756079

324: l_primary_rev_fcst_flag_tbl SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
325: l_dummy VARCHAR2(1);
326: l_module_name VARCHAR2(100):='PAFPPVTB.Baseline_FinPlan';
327: l_tmp_incl_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(); -- Bug 3756079
328: l_temp_ci_id_tbl SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(); -- Bug 3756079
329: l_version_type_tbl SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type(); -- Bug 3756079
330: l_cw_creation_date_tbl SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE(); -- Bug 3756079
331: l_bl_creation_date_tbl SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE(); -- Bug 3756079
332:

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

2194: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
2195: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
2196: l_user_id NUMBER :=0;
2197: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
2198: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2199: l_rlm_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2200: BEGIN
2201:
2202: x_msg_count := 0;

Line 2199: l_rlm_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2195: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
2196: l_user_id NUMBER :=0;
2197: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
2198: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2199: l_rlm_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2200: BEGIN
2201:
2202: x_msg_count := 0;
2203: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3963: l_sv_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3959: l_debug_mode VARCHAR2(30);
3960: --End of variables used for debugging
3961:
3962: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3963: l_sv_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3964: l_sv_id_count NUMBER;
3965:
3966: cursor c_struct_ver(c_project_id pa_projects_all.project_id%TYPE) IS
3967: SELECT project_structure_version_id

Line 4172: * Parameters: 1) p_struct_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type

4168: * Procedure Name: DELETE_WP_BUDGET_VERSIONS
4169: * This procedure is added as part of FPM Development. Trackinb Bug - 3354518.
4170: * Purpose: This API deletes the budget_versions for all the
4171: * workplan structure version ids passed.
4172: * Parameters: 1) p_struct_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type
4173: *=======================================================================*/
4174: PROCEDURE Delete_wp_budget_versions
4175: (p_struct_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type
4176: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4175: (p_struct_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type

4171: * workplan structure version ids passed.
4172: * Parameters: 1) p_struct_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type
4173: *=======================================================================*/
4174: PROCEDURE Delete_wp_budget_versions
4175: (p_struct_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type
4176: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4177: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4178: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4179: IS

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

4367: l_err_code NUMBER:=0;
4368: l_debug_level3 CONSTANT NUMBER := 3;
4369: l_debug_level5 CONSTANT NUMBER := 5;
4370:
4371: l_resource_assignment_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4372: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
4373: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
4374: l_line_start_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
4375: l_line_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 4380: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4376: i NUMBER;
4377: l_lines_count NUMBER; -- Bug 3639983
4378: l_module_name VARCHAR2(30) := 'pa.plsql.PA_FIN_PLAN_PVT';
4379: l_project_id pa_budget_versions.project_id%TYPE;
4380: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4381: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
4382: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
4383: l_total_qty_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4384: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 4383: l_total_qty_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4379: l_project_id pa_budget_versions.project_id%TYPE;
4380: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4381: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
4382: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
4383: l_total_qty_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4384: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4385: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4386: l_total_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4387: l_number_null_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3825873

Line 4384: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4380: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4381: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
4382: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
4383: l_total_qty_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4384: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4385: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4386: l_total_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4387: l_number_null_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3825873
4388:

Line 4385: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4381: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
4382: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
4383: l_total_qty_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4384: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4385: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4386: l_total_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4387: l_number_null_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3825873
4388:
4389: -- bug 4221650: added the following

Line 4386: l_total_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4382: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
4383: l_total_qty_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4384: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4385: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4386: l_total_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4387: l_number_null_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3825873
4388:
4389: -- bug 4221650: added the following
4390: l_ver_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 4387: l_number_null_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3825873

4383: l_total_qty_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4384: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4385: l_total_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4386: l_total_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4387: l_number_null_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3825873
4388:
4389: -- bug 4221650: added the following
4390: l_ver_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
4391: