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

Line 8191: FROM pa_proj_period_profiles pp

8187: l_dummy NUMBER;
8188:
8189: CURSOR current_period_profiles_cur IS
8190: SELECT period_profile_id
8191: FROM pa_proj_period_profiles pp
8192: WHERE pp.project_id = p_source_project_id
8193: AND pp.current_flag = 'Y';
8194:
8195: BEGIN

Line 8317: ,p_source_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE

8313: ================================================================================*/
8314:
8315: PROCEDURE Get_Create_Shifted_PD_Profile
8316: ( p_target_project_id IN pa_projects.project_id%TYPE
8317: ,p_source_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE
8318: ,p_shift_days IN NUMBER
8319: ,x_target_period_profile_id OUT NOCOPY pa_proj_period_profiles.period_profile_id%TYPE --File.Sql.39 bug 4440895
8320: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8321: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 8319: ,x_target_period_profile_id OUT NOCOPY pa_proj_period_profiles.period_profile_id%TYPE --File.Sql.39 bug 4440895

8315: PROCEDURE Get_Create_Shifted_PD_Profile
8316: ( p_target_project_id IN pa_projects.project_id%TYPE
8317: ,p_source_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE
8318: ,p_shift_days IN NUMBER
8319: ,x_target_period_profile_id OUT NOCOPY pa_proj_period_profiles.period_profile_id%TYPE --File.Sql.39 bug 4440895
8320: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8321: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8322: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
8323: AS

Line 8360: CURSOR source_profile_info_cur (c_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE)

8356: l_dummy_flag VARCHAR2(1);
8357: l_dummy1 VARCHAR2(30);
8358: l_dummy2 VARCHAR2(30);
8359:
8360: CURSOR source_profile_info_cur (c_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE)
8361: IS
8362: SELECT number_of_periods
8363: ,plan_period_type
8364: ,period_profile_type

Line 8369: FROM pa_proj_period_profiles

8365: ,period_name1 -- profile_start_period
8366: ,profile_end_period_name
8367: ,period1_start_date -- profile start date
8368: ,current_flag
8369: FROM pa_proj_period_profiles
8370: WHERE period_profile_id = c_period_profile_id ;
8371:
8372: source_profile_info_rec source_profile_info_cur%ROWTYPE;
8373: