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_UTILS dependencies on PA_PROJ_PERIOD_PROFILES

Line 474: return pa_proj_period_profiles.period_name1%TYPE is

470: ==============================================================================*/
471:
472: FUNCTION Get_Period_Profile_Start_Date
473: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)
474: return pa_proj_period_profiles.period_name1%TYPE is
475: l_start_date pa_proj_period_profiles.period_name1%TYPE;
476: BEGIN
477: l_start_date := null;
478: if p_period_profile_id is not null then

Line 475: l_start_date pa_proj_period_profiles.period_name1%TYPE;

471:
472: FUNCTION Get_Period_Profile_Start_Date
473: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)
474: return pa_proj_period_profiles.period_name1%TYPE is
475: l_start_date pa_proj_period_profiles.period_name1%TYPE;
476: BEGIN
477: l_start_date := null;
478: if p_period_profile_id is not null then
479: select period_name1

Line 481: from pa_proj_period_profiles

477: l_start_date := null;
478: if p_period_profile_id is not null then
479: select period_name1
480: into l_start_date
481: from pa_proj_period_profiles
482: where period_profile_id = p_period_profile_id;
483: end if; -- p_period_profile_id is not null
484: return l_start_date;
485: EXCEPTION

Line 498: return pa_proj_period_profiles.profile_end_period_name%TYPE is

494: Use: for Create Plan Version page VO query
495: ==============================================================================*/
496: FUNCTION Get_Period_Profile_End_Date
497: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)
498: return pa_proj_period_profiles.profile_end_period_name%TYPE is
499: l_end_date pa_proj_period_profiles.profile_end_period_name%TYPE;
500: BEGIN
501: l_end_date := null;
502: if p_period_profile_id is not null then

Line 499: l_end_date pa_proj_period_profiles.profile_end_period_name%TYPE;

495: ==============================================================================*/
496: FUNCTION Get_Period_Profile_End_Date
497: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)
498: return pa_proj_period_profiles.profile_end_period_name%TYPE is
499: l_end_date pa_proj_period_profiles.profile_end_period_name%TYPE;
500: BEGIN
501: l_end_date := null;
502: if p_period_profile_id is not null then
503: select profile_end_period_name

Line 505: from pa_proj_period_profiles

501: l_end_date := null;
502: if p_period_profile_id is not null then
503: select profile_end_period_name
504: into l_end_date
505: from pa_proj_period_profiles
506: where period_profile_id = p_period_profile_id;
507: end if; -- p_period_profile_id is not null
508: return l_end_date;
509: EXCEPTION

Line 844: -- 4. pa_proj_period_profiles

840: -- to the project id given as input parameter from
841: -- 1. pa_fp_txn_currencies
842: -- 2. pa_proj_fp_options
843: -- 3. pa_fp_elements
844: -- 4. pa_proj_period_profiles
845: --==========================================================================
846:
847: procedure Delete_Fp_Options(
848: p_project_id IN PA_FP_TXN_CURRENCIES.PROJECT_ID%TYPE

Line 865: -- delete from pa_proj_period_profiles table

861: as this table is getting obsoleted */
862: -- delete from pa_fp_elements table
863: /* delete from pa_fp_elements where project_id=p_project_id; */
864:
865: -- delete from pa_proj_period_profiles table
866: delete from pa_proj_period_profiles where project_id=p_project_id;
867:
868: /* Bug 3683382 this delete is not required functionally as records can not
869: exist for a project level option in this table

Line 866: delete from pa_proj_period_profiles where project_id=p_project_id;

862: -- delete from pa_fp_elements table
863: /* delete from pa_fp_elements where project_id=p_project_id; */
864:
865: -- delete from pa_proj_period_profiles table
866: delete from pa_proj_period_profiles where project_id=p_project_id;
867:
868: /* Bug 3683382 this delete is not required functionally as records can not
869: exist for a project level option in this table
870: -- delete from pa_resource_assignments table

Line 5484: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */

5480: PROCEDURE Get_Period_Details
5481: ( p_period_name IN pa_periods.period_name%TYPE
5482: /* Changes for FPM. Tracking Bug - 3354518
5483: Modifying the datatype of parameter p_plan_period_type below to varchar2 */
5484: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */
5485: ,p_plan_period_type IN VARCHAR2
5486: ,x_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
5487: ,x_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
5488: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5628: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */

5624: and x_shifted_period_start_date and x_shifted_period_end_date as date*/
5625:
5626: PROCEDURE Get_Shifted_Period (
5627: p_period_name IN pa_periods.period_name%TYPE
5628: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */
5629: ,p_plan_period_type IN VARCHAR2
5630: ,p_number_of_periods IN NUMBER
5631: ,x_shifted_period OUT NOCOPY pa_periods.period_name%TYPE --File.Sql.39 bug 4440895
5632: /* ,x_shifted_period_start_date OUT pa_proj_period_profiles.period1_start_date%TYPE

Line 5632: /* ,x_shifted_period_start_date OUT pa_proj_period_profiles.period1_start_date%TYPE

5628: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */
5629: ,p_plan_period_type IN VARCHAR2
5630: ,p_number_of_periods IN NUMBER
5631: ,x_shifted_period OUT NOCOPY pa_periods.period_name%TYPE --File.Sql.39 bug 4440895
5632: /* ,x_shifted_period_start_date OUT pa_proj_period_profiles.period1_start_date%TYPE
5633: ,x_shifted_period_end_date OUT pa_proj_period_profiles.period1_end_date%TYPE */
5634: ,x_shifted_period_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
5635: ,x_shifted_period_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
5636: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5633: ,x_shifted_period_end_date OUT pa_proj_period_profiles.period1_end_date%TYPE */

5629: ,p_plan_period_type IN VARCHAR2
5630: ,p_number_of_periods IN NUMBER
5631: ,x_shifted_period OUT NOCOPY pa_periods.period_name%TYPE --File.Sql.39 bug 4440895
5632: /* ,x_shifted_period_start_date OUT pa_proj_period_profiles.period1_start_date%TYPE
5633: ,x_shifted_period_end_date OUT pa_proj_period_profiles.period1_end_date%TYPE */
5634: ,x_shifted_period_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
5635: ,x_shifted_period_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
5636: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5637: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895