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 3003: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;

2999: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;
3000: l_calling_context VARCHAR2(30);
3001:
3002: /* #2727304 */
3003: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
3004: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3005:
3006: BEGIN
3007:

Line 3004: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

3000: l_calling_context VARCHAR2(30);
3001:
3002: /* #2727304 */
3003: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
3004: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3005:
3006: BEGIN
3007:
3008: x_msg_count := 0;

Line 3138: FROM pa_projects_all

3134: SELECT project_currency_code
3135: ,projfunc_currency_code
3136: INTO l_proj_currency_code
3137: ,l_projfunc_currency_code
3138: FROM pa_projects_all
3139: WHERE project_id = (SELECT project_id
3140: FROM pa_budget_versions
3141: WHERE budget_version_id = p_fin_plan_version_id);
3142:

Line 3985: (p_project_id IN pa_projects_all.project_id%TYPE

3981: Parameters:
3982: IN 1) p_project_id - project id.
3983: =======================================================================*/
3984: PROCEDURE Delete_wp_option
3985: (p_project_id IN pa_projects_all.project_id%TYPE
3986: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3987: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3988: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3989: IS

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

4001: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4002: l_sv_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4003: l_sv_id_count NUMBER;
4004:
4005: cursor c_struct_ver(c_project_id pa_projects_all.project_id%TYPE) IS
4006: SELECT project_structure_version_id
4007: FROM pa_budget_versions
4008: WHERE project_id = c_project_id
4009: AND nvl(wp_version_flag,'N') = 'Y';