[Home] [Help]
1: PACKAGE IGS_AU_GEN_002 AS
2: /* $Header: IGSAU02S.pls 120.0 2005/06/02 00:23:11 appldev noship $ */
3: Function Audp_Get_Culh_Col(
4: p_unit_cd IGS_PS_UNIT_LVL_HIST_ALL.unit_cd%TYPE ,
5: p_course_type IGS_PS_UNIT_LVL_HIST_ALL.course_type%TYPE DEFAULT NULL,
6: p_version_number IGS_PS_UNIT_LVL_HIST_ALL.version_number%TYPE ,
7: p_column_name user_tab_columns.column_name%TYPE ,
8: p_hist_date IGS_PS_UNIT_LVL_HIST_ALL.hist_start_dt%TYPE,
1: PACKAGE IGS_AU_GEN_002 AS
2: /* $Header: IGSAU02S.pls 120.0 2005/06/02 00:23:11 appldev noship $ */
3: Function Audp_Get_Culh_Col(
4: p_unit_cd IGS_PS_UNIT_LVL_HIST_ALL.unit_cd%TYPE ,
5: p_course_type IGS_PS_UNIT_LVL_HIST_ALL.course_type%TYPE DEFAULT NULL,
6: p_version_number IGS_PS_UNIT_LVL_HIST_ALL.version_number%TYPE ,
7: p_column_name user_tab_columns.column_name%TYPE ,
8: p_hist_date IGS_PS_UNIT_LVL_HIST_ALL.hist_start_dt%TYPE,
9: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,
2: /* $Header: IGSAU02S.pls 120.0 2005/06/02 00:23:11 appldev noship $ */
3: Function Audp_Get_Culh_Col(
4: p_unit_cd IGS_PS_UNIT_LVL_HIST_ALL.unit_cd%TYPE ,
5: p_course_type IGS_PS_UNIT_LVL_HIST_ALL.course_type%TYPE DEFAULT NULL,
6: p_version_number IGS_PS_UNIT_LVL_HIST_ALL.version_number%TYPE ,
7: p_column_name user_tab_columns.column_name%TYPE ,
8: p_hist_date IGS_PS_UNIT_LVL_HIST_ALL.hist_start_dt%TYPE,
9: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,
10: p_course_version_number IGS_PS_UNIT_LVL_HIST_ALL.course_version_number%TYPE
4: p_unit_cd IGS_PS_UNIT_LVL_HIST_ALL.unit_cd%TYPE ,
5: p_course_type IGS_PS_UNIT_LVL_HIST_ALL.course_type%TYPE DEFAULT NULL,
6: p_version_number IGS_PS_UNIT_LVL_HIST_ALL.version_number%TYPE ,
7: p_column_name user_tab_columns.column_name%TYPE ,
8: p_hist_date IGS_PS_UNIT_LVL_HIST_ALL.hist_start_dt%TYPE,
9: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,
10: p_course_version_number IGS_PS_UNIT_LVL_HIST_ALL.course_version_number%TYPE
11: )
12: RETURN VARCHAR2;
5: p_course_type IGS_PS_UNIT_LVL_HIST_ALL.course_type%TYPE DEFAULT NULL,
6: p_version_number IGS_PS_UNIT_LVL_HIST_ALL.version_number%TYPE ,
7: p_column_name user_tab_columns.column_name%TYPE ,
8: p_hist_date IGS_PS_UNIT_LVL_HIST_ALL.hist_start_dt%TYPE,
9: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,
10: p_course_version_number IGS_PS_UNIT_LVL_HIST_ALL.course_version_number%TYPE
11: )
12: RETURN VARCHAR2;
13: PRAGMA RESTRICT_REFERENCES(Audp_Get_Culh_Col, WNDS);
6: p_version_number IGS_PS_UNIT_LVL_HIST_ALL.version_number%TYPE ,
7: p_column_name user_tab_columns.column_name%TYPE ,
8: p_hist_date IGS_PS_UNIT_LVL_HIST_ALL.hist_start_dt%TYPE,
9: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,
10: p_course_version_number IGS_PS_UNIT_LVL_HIST_ALL.course_version_number%TYPE
11: )
12: RETURN VARCHAR2;
13: PRAGMA RESTRICT_REFERENCES(Audp_Get_Culh_Col, WNDS);
14: