DBA Data[Home] [Help]

APPS.IGS_EN_GEN_007 dependencies on USER_TAB_COLUMNS

Line 66: p_column_name IN user_tab_columns.column_name%TYPE ,

62:
63: END enrp_get_student_ind;
64:
65: FUNCTION Enrp_Get_Suah_Col(
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,

Line 85: cp_column_name user_tab_columns.column_name%TYPE,

81: gv_other_detail Varchar2(255);
82: BEGIN
83: DECLARE
84: CURSOR c_suah(
85: cp_column_name user_tab_columns.column_name%TYPE,
86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS