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.

[Home] [Help]

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 842: -- 4. pa_proj_period_profiles

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

Line 863: -- delete from pa_proj_period_profiles table

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

Line 864: delete from pa_proj_period_profiles where project_id=p_project_id;

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

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

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

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

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

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

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

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

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