[Home] [Help]
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
26:
74: (reverse chronological order - newest change first)
75: ***************************************************************/
76: p_course_cd igs_ps_ver_hist_all.course_cd%TYPE ,
77: p_version_number igs_ps_ver_hist_all.version_number%TYPE ,
78: p_column_name user_tab_columns.column_name%TYPE ,
79: p_hist_date igs_ps_ver_hist_all.hist_start_dt%TYPE )
80: RETURN VARCHAR2 AS
81:
82: BEGIN -- audp_get_cvh_col
233: END audp_get_cvh_col;
234:
235:
236: FUNCTION audp_get_dh_col(
237: p_column_name user_tab_columns.column_name%TYPE ,
238: p_dscplne_grp_cd igs_ps_dscp_hist_all.discipline_group_cd%TYPE ,
239: p_hist_end_dt igs_ps_dscp_hist_all.hist_end_dt%TYPE )
240: RETURN VARCHAR2 AS
241:
284: END;
285: END audp_get_dh_col;
286:
287: FUNCTION audp_get_fcflh_col(
288: p_column_name IN user_tab_columns.column_name%TYPE ,
289: p_fee_cat IN igs_fi_f_cat_f_lbl_h_all.fee_cat%TYPE ,
290: p_fee_cal_type IN VARCHAR2 ,
291: p_fee_ci_sequence_number IN NUMBER ,
292: p_fee_type IN igs_fi_f_cat_f_lbl_h_all.fee_type%TYPE ,
349: END;
350: END audp_get_fcflh_col;
351:
352: FUNCTION audp_get_fosh_col(
353: p_column_name user_tab_columns.column_name%TYPE ,
354: p_field_of_study igs_ps_fld_stdy_hist_all.field_of_study%TYPE ,
355: p_hist_end_dt igs_ps_fld_stdy_hist_all.hist_end_dt%TYPE )
356: RETURN VARCHAR2 AS
357:
390: END audp_get_fosh_col;
391:
392: FUNCTION audp_get_fsh_col(
393: p_funding_source igs_fi_fund_src_hist_all.funding_source%TYPE ,
394: p_column_name user_tab_columns.column_name%TYPE ,
395: p_hist_end_dt igs_fi_fund_src_hist_all.hist_end_dt%TYPE )
396: RETURN VARCHAR2 AS
397:
398: BEGIN -- audp_get_fsh_col
431: FUNCTION audp_get_fsrh_col(
432: p_course_cd igs_fi_fd_src_rstn_h_all.course_cd%TYPE ,
433: p_version_number igs_fi_fd_src_rstn_h_all.version_number%TYPE ,
434: p_funding_source igs_fi_fd_src_rstn_h_all.funding_source%TYPE ,
435: p_column_name user_tab_columns.column_name%TYPE ,
436: p_hist_date igs_fi_fd_src_rstn_h_all.hist_start_dt%TYPE )
437: RETURN VARCHAR2 AS
438:
439: BEGIN -- audp_get_fsrh_col
464: END;
465: END audp_get_fsrh_col;
466:
467: FUNCTION audp_get_ftcih_col(
468: p_column_name IN user_tab_columns.column_name%TYPE ,
469: p_fee_type IN igs_fi_fee_type_ci_h_all.fee_type%TYPE ,
470: p_fee_cal_type IN igs_fi_fee_type_ci_h_all.fee_cal_type%TYPE ,
471: p_fee_ci_sequence_number IN NUMBER ,
472: p_hist_end_dt IN igs_fi_fee_type_ci_h_all.hist_end_dt%TYPE )