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

Line 8164: FROM pa_proj_period_profiles pp

8160: l_dummy NUMBER;
8161:
8162: CURSOR current_period_profiles_cur IS
8163: SELECT period_profile_id
8164: FROM pa_proj_period_profiles pp
8165: WHERE pp.project_id = p_source_project_id
8166: AND pp.current_flag = 'Y';
8167:
8168: BEGIN

Line 8290: ,p_source_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE

8286: ================================================================================*/
8287:
8288: PROCEDURE Get_Create_Shifted_PD_Profile
8289: ( p_target_project_id IN pa_projects.project_id%TYPE
8290: ,p_source_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE
8291: ,p_shift_days IN NUMBER
8292: ,x_target_period_profile_id OUT NOCOPY pa_proj_period_profiles.period_profile_id%TYPE --File.Sql.39 bug 4440895
8293: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8294: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

8288: PROCEDURE Get_Create_Shifted_PD_Profile
8289: ( p_target_project_id IN pa_projects.project_id%TYPE
8290: ,p_source_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE
8291: ,p_shift_days IN NUMBER
8292: ,x_target_period_profile_id OUT NOCOPY pa_proj_period_profiles.period_profile_id%TYPE --File.Sql.39 bug 4440895
8293: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8294: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8295: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
8296: AS

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

8329: l_dummy_flag VARCHAR2(1);
8330: l_dummy1 VARCHAR2(30);
8331: l_dummy2 VARCHAR2(30);
8332:
8333: CURSOR source_profile_info_cur (c_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE)
8334: IS
8335: SELECT number_of_periods
8336: ,plan_period_type
8337: ,period_profile_type

Line 8342: FROM pa_proj_period_profiles

8338: ,period_name1 -- profile_start_period
8339: ,profile_end_period_name
8340: ,period1_start_date -- profile start date
8341: ,current_flag
8342: FROM pa_proj_period_profiles
8343: WHERE period_profile_id = c_period_profile_id ;
8344:
8345: source_profile_info_rec source_profile_info_cur%ROWTYPE;
8346: