DBA Data[Home] [Help]

APPS.IGS_AU_GEN_002 dependencies on IGS_PS_UNIT_LVL_HIST_ALL

Line 4: p_unit_cd IGS_PS_UNIT_LVL_HIST_ALL.unit_cd%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,

Line 5: p_course_type IGS_PS_UNIT_LVL_HIST_ALL.course_type%TYPE DEFAULT NULL,

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,

Line 6: p_version_number IGS_PS_UNIT_LVL_HIST_ALL.version_number%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

Line 8: p_hist_date IGS_PS_UNIT_LVL_HIST_ALL.hist_start_dt%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;

Line 9: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_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;
13: PRAGMA RESTRICT_REFERENCES(Audp_Get_Culh_Col, WNDS);

Line 10: p_course_version_number IGS_PS_UNIT_LVL_HIST_ALL.course_version_number%TYPE

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: