APPS.IGS_AU_GEN_002 dependencies on IGS_PS_UNIT_LVL_HIST_ALL

Line 19: p_unit_cd igs_ps_unit_lvl_hist_all.unit_cd%TYPE ,

15: new columns according to the DLD,PSP001-US
16: */
17:
18: FUNCTION audp_get_culh_col(
19: p_unit_cd igs_ps_unit_lvl_hist_all.unit_cd%TYPE ,
20: p_course_type igs_ps_unit_lvl_hist_all.course_type%TYPE DEFAULT NULL,
21: p_version_number igs_ps_unit_lvl_hist_all.version_number%TYPE ,
22: p_column_name user_tab_columns.column_name%TYPE ,
23: p_hist_date igs_ps_unit_lvl_hist_all.hist_start_dt%TYPE,

Line 20: p_course_type igs_ps_unit_lvl_hist_all.course_type%TYPE DEFAULT NULL,

16: */
17:
18: FUNCTION audp_get_culh_col(
19: p_unit_cd igs_ps_unit_lvl_hist_all.unit_cd%TYPE ,
20: p_course_type igs_ps_unit_lvl_hist_all.course_type%TYPE DEFAULT NULL,
21: p_version_number igs_ps_unit_lvl_hist_all.version_number%TYPE ,
22: p_column_name user_tab_columns.column_name%TYPE ,
23: p_hist_date igs_ps_unit_lvl_hist_all.hist_start_dt%TYPE,
24: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,

Line 21: p_version_number igs_ps_unit_lvl_hist_all.version_number%TYPE ,

17:
18: FUNCTION audp_get_culh_col(
19: p_unit_cd igs_ps_unit_lvl_hist_all.unit_cd%TYPE ,
20: p_course_type igs_ps_unit_lvl_hist_all.course_type%TYPE DEFAULT NULL,
21: p_version_number igs_ps_unit_lvl_hist_all.version_number%TYPE ,
22: p_column_name user_tab_columns.column_name%TYPE ,
23: p_hist_date igs_ps_unit_lvl_hist_all.hist_start_dt%TYPE,
24: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,
25: p_course_version_number IGS_PS_UNIT_LVL_HIST_ALL.course_version_number%TYPE

Line 23: p_hist_date igs_ps_unit_lvl_hist_all.hist_start_dt%TYPE,

19: p_unit_cd igs_ps_unit_lvl_hist_all.unit_cd%TYPE ,
20: p_course_type igs_ps_unit_lvl_hist_all.course_type%TYPE DEFAULT NULL,
21: p_version_number igs_ps_unit_lvl_hist_all.version_number%TYPE ,
22: p_column_name user_tab_columns.column_name%TYPE ,
23: p_hist_date igs_ps_unit_lvl_hist_all.hist_start_dt%TYPE,
24: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,
25: p_course_version_number IGS_PS_UNIT_LVL_HIST_ALL.course_version_number%TYPE
26:
27: )

Line 24: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,

20: p_course_type igs_ps_unit_lvl_hist_all.course_type%TYPE DEFAULT NULL,
21: p_version_number igs_ps_unit_lvl_hist_all.version_number%TYPE ,
22: p_column_name user_tab_columns.column_name%TYPE ,
23: p_hist_date igs_ps_unit_lvl_hist_all.hist_start_dt%TYPE,
24: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,
25: p_course_version_number IGS_PS_UNIT_LVL_HIST_ALL.course_version_number%TYPE
26:
27: )
28: RETURN VARCHAR2 AS

Line 25: p_course_version_number IGS_PS_UNIT_LVL_HIST_ALL.course_version_number%TYPE

21: p_version_number igs_ps_unit_lvl_hist_all.version_number%TYPE ,
22: p_column_name user_tab_columns.column_name%TYPE ,
23: p_hist_date igs_ps_unit_lvl_hist_all.hist_start_dt%TYPE,
24: p_course_cd IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,
25: p_course_version_number IGS_PS_UNIT_LVL_HIST_ALL.course_version_number%TYPE
26:
27: )
28: RETURN VARCHAR2 AS
29: