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_PROJECTS_ALL

Line 234: -- 11/16/02 dlai: bug fix 2668857 - when joining pa_projects_all with

230:
231:
232: /* ------------------------------------------------------------------------ */
233:
234: -- 11/16/02 dlai: bug fix 2668857 - when joining pa_projects_all with
235: -- pa_project_types_all, need to join based on org_id as well
236:
237: -- 12-FEB-04 jwhite - Bug 3440026
238: -- Commented obsolete call to

Line 319: l_auto_baseline_project pa_projects_all.baseline_funding_flag%TYPE;

315: l_base_line_ver_exists VARCHAR2(1);
316: l_curr_work_ver_id pa_budget_versions.budget_version_id%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();

Line 458: pa_projects_all pr,

454: l_fin_plan_type_id,
455: l_fin_plan_class_code,
456: l_auto_baseline_project
457: from pa_project_types_all pt,
458: pa_projects_all pr,
459: pa_budget_versions bv,
460: pa_proj_fp_options opt,
461: pa_fin_plan_types_b pavl
462: where bv.budget_version_id = p_budget_version_id and

Line 900: from pa_projects_all

896: if (l_time_phased_type_code = 'N') and (l_entry_level_code = 'P') then -- Project Level
897: select start_date,completion_date
898: into v_project_start_date,
899: v_project_completion_date
900: from pa_projects_all
901: where project_id = p_project_id;
902:
903: if (v_project_start_date is null ) or (v_project_completion_date is null) then
904: PA_UTILS.Add_Message(p_app_short_name => 'PA',

Line 925: from pa_projects_all

921:
922: select start_date,completion_date
923: into v_project_start_date,
924: v_project_completion_date
925: from pa_projects_all
926: where project_id = p_project_id;
927:
928: for bl_rec in (select start_date,
929: completion_date ,

Line 1328: -- 11/16/02 dlai: bug fix 2668857 - when joining pa_projects_all with

1324: END Baseline_FinPlan;
1325: /* ------------------------------------------------------------------------ */
1326:
1327: -- HISTORY
1328: -- 11/16/02 dlai: bug fix 2668857 - when joining pa_projects_all with
1329: -- pa_project_types_all, need to join based on org_id as well
1330: PROCEDURE Submit_Current_Working_FinPlan
1331: (p_project_id IN pa_budget_versions.project_id%TYPE,
1332: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 1473: pa_projects_all pr,

1469: l_pm_product_code,
1470: /* l_created_by, Commented for bug 6176649 */
1471: l_fin_plan_type_id
1472: from pa_project_types_all pt,
1473: pa_projects_all pr,
1474: pa_budget_versions bv,
1475: -- pa_budget_entry_methods be,
1476: pa_proj_fp_options opt,
1477: pa_fin_plan_types_b pavl

Line 1810: l_project_id pa_projects_all.project_id%TYPE;

1806: OR
1807: pt.approved_rev_plan_type_flag = 'Y');
1808:
1809: l_approved_budget_plan_type varchar2(1) := 'N';
1810: l_project_id pa_projects_all.project_id%TYPE;
1811: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1812: l_version_type pa_budget_versions.version_type%TYPE;
1813: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1814: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;

Line 2998: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;

2994: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;
2995: l_calling_context VARCHAR2(30);
2996:
2997: /* #2727304 */
2998: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
2999: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3000:
3001: BEGIN
3002:

Line 2999: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

2995: l_calling_context VARCHAR2(30);
2996:
2997: /* #2727304 */
2998: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
2999: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3000:
3001: BEGIN
3002:
3003: x_msg_count := 0;

Line 3132: FROM pa_projects_all

3128: SELECT project_currency_code
3129: ,projfunc_currency_code
3130: INTO l_proj_currency_code
3131: ,l_projfunc_currency_code
3132: FROM pa_projects_all
3133: WHERE project_id = (SELECT project_id
3134: FROM pa_budget_versions
3135: WHERE budget_version_id = p_fin_plan_version_id);
3136:

Line 3946: (p_project_id IN pa_projects_all.project_id%TYPE

3942: Parameters:
3943: IN 1) p_project_id - project id.
3944: =======================================================================*/
3945: PROCEDURE Delete_wp_option
3946: (p_project_id IN pa_projects_all.project_id%TYPE
3947: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3948: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3949: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3950: IS

Line 3966: cursor c_struct_ver(c_project_id pa_projects_all.project_id%TYPE) IS

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
3968: FROM pa_budget_versions
3969: WHERE project_id = c_project_id
3970: AND nvl(wp_version_flag,'N') = 'Y';