DBA Data[Home] [Help]

APPS.IGS_AU_GEN_003 dependencies on USER_TAB_COLUMNS

Line 21: p_column_name IN user_tab_columns.column_name%TYPE ,

17: RETURN NUMBER;
18: PRAGMA RESTRICT_REFERENCES(Audp_Get_Enrs_Stat, WNDS);
19:
20: Function Audp_Get_Gach_Col(
21: p_column_name IN user_tab_columns.column_name%TYPE ,
22: p_person_id IN NUMBER ,
23: p_create_dt IN DATE ,
24: p_grd_cal_type IN VARCHAR2 ,
25: p_grd_ci_sequence_number IN NUMBER ,

Line 37: p_column_name user_tab_columns.column_name%TYPE ,

33:
34: Function Audp_Get_Grh_Col(
35: p_person_id IGS_GR_GRADUAND_HIST_ALL.person_id%TYPE ,
36: p_create_dt IGS_GR_GRADUAND_HIST_ALL.create_dt%TYPE ,
37: p_column_name user_tab_columns.column_name%TYPE ,
38: p_hist_dt IGS_GR_GRADUAND_HIST_ALL.hist_start_dt%TYPE )
39: RETURN VARCHAR2;
40: PRAGMA RESTRICT_REFERENCES(Audp_Get_Grh_Col, WNDS);
41:

Line 43: p_column_name IN user_tab_columns.column_name%TYPE ,

39: RETURN VARCHAR2;
40: PRAGMA RESTRICT_REFERENCES(Audp_Get_Grh_Col, WNDS);
41:
42: Function Audp_Get_Ih_Col(
43: p_column_name IN user_tab_columns.column_name%TYPE ,
44: p_institution_cd IN IGS_OR_INST_HIST_ALL.institution_cd%TYPE ,
45: p_hist_end_dt IN IGS_OR_INST_HIST_ALL.hist_end_dt%TYPE )
46: RETURN VARCHAR2;
47: PRAGMA RESTRICT_REFERENCES(Audp_Get_Ih_Col, WNDS);

Line 50: p_column_name IN user_tab_columns.column_name%TYPE ,

46: RETURN VARCHAR2;
47: PRAGMA RESTRICT_REFERENCES(Audp_Get_Ih_Col, WNDS);
48:
49: Function Audp_Get_Ouh_Col(
50: p_column_name IN user_tab_columns.column_name%TYPE ,
51: p_org_unit_cd IN IGS_OR_UNIT_HIST_ALL.institution_cd%TYPE ,
52: p_ou_start_dt IN IGS_OR_UNIT_HIST_ALL.ou_start_dt%TYPE ,
53: p_hist_end_dt IN IGS_OR_UNIT_HIST_ALL.hist_end_dt%TYPE )
54: RETURN VARCHAR2;

Line 58: p_column_name IN user_tab_columns.column_name%TYPE ,

54: RETURN VARCHAR2;
55: PRAGMA RESTRICT_REFERENCES(Audp_Get_Ouh_Col, WNDS);
56:
57: Function Audp_Get_Scah_Col(
58: p_column_name IN user_tab_columns.column_name%TYPE ,
59: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
60: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
61: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
62: RETURN VARCHAR2;

Line 73: p_column_name user_tab_columns.column_name%TYPE ,

69: RETURN VARCHAR2;
70: PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sph_col, WNDS);
71:
72: Function Audp_Get_Suah_Col(
73: p_column_name user_tab_columns.column_name%TYPE ,
74: p_person_id IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
75: p_course_cd IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
76: p_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
77: p_uoo_id IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE )

Line 82: p_column_name IN user_tab_columns.column_name%TYPE ,

78: RETURN VARCHAR2;
79: PRAGMA RESTRICT_REFERENCES(Audp_Get_Suah_Col, WNDS);
80:
81: Function Audp_Get_Suaoh_Col(
82: p_column_name IN user_tab_columns.column_name%TYPE ,
83: p_person_id IN NUMBER ,
84: p_course_cd IN VARCHAR2 ,
85: p_unit_cd IN VARCHAR2 ,
86: p_cal_type IN VARCHAR2 ,

Line 95: p_column_name IN user_tab_columns.column_name%TYPE ,

91: RETURN VARCHAR2;
92: PRAGMA RESTRICT_REFERENCES(Audp_Get_Suaoh_Col, WNDS);
93:
94: Function Audp_Get_Susah_Col(
95: p_column_name IN user_tab_columns.column_name%TYPE ,
96: p_person_id IN NUMBER ,
97: p_course_cd IN VARCHAR2 ,
98: p_unit_set_cd IN VARCHAR2 ,
99: p_sequence_number IN NUMBER ,