APPS.IGS_AU_GEN_002 dependencies on IGS_PS_UNIT_LVL_HIST

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:

Line 39: FROM igs_ps_unit_lvl_hist culh

35: CURSOR c_culh IS
36: SELECT decode (p_column_name,
37: 'UNIT_LEVEL', culh.unit_level,
38: 'WAM_WEIGHTING', TO_CHAR(culh.wam_weighting))
39: FROM igs_ps_unit_lvl_hist culh
40: WHERE culh.unit_cd = p_unit_cd AND
41: culh.version_number = p_version_number AND
42: culh.course_cd = p_course_cd AND
43: culh.course_version_number = p_course_version_number AND