33: 9/11/02 ADDED FUNCTIONS TO RETRIEVE GL/PA START/END PERIOD
34: NAMES FOR CREATE VERSION PAGE
35: ============================================================== */
36: FUNCTION get_gl_current_start_period
37: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
38: return VARCHAR2;
39:
40: FUNCTION get_gl_current_end_period
41: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
37: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
38: return VARCHAR2;
39:
40: FUNCTION get_gl_current_end_period
41: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
42: return VARCHAR2;
43:
44: FUNCTION get_pa_current_start_period
45: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
41: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
42: return VARCHAR2;
43:
44: FUNCTION get_pa_current_start_period
45: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
46: return VARCHAR2;
47:
48: FUNCTION get_pa_current_end_period
49: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
45: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
46: return VARCHAR2;
47:
48: FUNCTION get_pa_current_end_period
49: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
50: return VARCHAR2;
51:
52:
53: procedure set_project_id