DBA Data[Home] [Help]

APPS.IGS_AU_GEN_001 dependencies on USER_TAB_COLUMNS

Line 4: p_column_name IN user_tab_columns.column_name%TYPE ,

1: PACKAGE IGS_AU_GEN_001 AUTHID CURRENT_USER AS
2: /* $Header: IGSAU01S.pls 115.4 2003/12/03 20:48:57 knag ship $ */
3: Function Audp_Get_Aah_Col(
4: p_column_name IN user_tab_columns.column_name%TYPE ,
5: p_person_id IN IGS_AD_APPL_HIST_ALL.person_id%TYPE ,
6: p_admission_appl_number IN NUMBER ,
7: p_hist_end_dt IN IGS_AD_APPL_HIST_ALL.hist_end_dt%TYPE )
8: RETURN VARCHAR2;

Line 12: p_column_name IN user_tab_columns.column_name%TYPE ,

8: RETURN VARCHAR2;
9: PRAGMA RESTRICT_REFERENCES(Audp_Get_Aah_Col, WNDS,WNPS);
10:
11: Function Audp_Get_Acah_Col(
12: p_column_name IN user_tab_columns.column_name%TYPE ,
13: p_person_id IN IGS_AD_PS_APPL_HIST_ALL.person_id%TYPE ,
14: p_admission_appl_number IN NUMBER ,
15: p_nominated_course_cd IN VARCHAR2 ,
16: p_hist_end_dt IN IGS_AD_PS_APPL_HIST_ALL.hist_end_dt%TYPE )

Line 21: p_column_name IN user_tab_columns.column_name%TYPE ,

17: RETURN VARCHAR2;
18: PRAGMA RESTRICT_REFERENCES(Audp_Get_Acah_Col, WNDS);
19:
20: Function Audp_Get_Acaih_Col(
21: p_column_name IN user_tab_columns.column_name%TYPE ,
22: p_person_id IN NUMBER ,
23: p_admission_appl_number IN NUMBER ,
24: p_nominated_course_cd IN VARCHAR2 ,
25: p_sequence_number IN NUMBER ,

Line 31: p_column_name IN user_tab_columns.column_name%TYPE ,

27: RETURN VARCHAR2;
28: PRAGMA RESTRICT_REFERENCES(Audp_Get_Acaih_Col, WNDS);
29:
30: Function Audp_Get_Acaiuh_Col(
31: p_column_name IN user_tab_columns.column_name%TYPE ,
32: p_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
33: p_person_id IN NUMBER DEFAULT NULL,
34: p_admission_appl_number IN NUMBER DEFAULT NULL,
35: p_nominated_course_cd IN VARCHAR2 DEFAULT NULL,

Line 46: p_column_name user_tab_columns.column_name%TYPE ,

42: Function Audp_Get_Cfosh_Col(
43: p_course_cd IGS_PS_FLD_STD_HIST_ALL.course_cd%TYPE ,
44: p_version_number IGS_PS_FLD_STD_HIST_ALL.version_number%TYPE ,
45: p_field_of_study IGS_PS_FLD_STD_HIST_ALL.field_of_study%TYPE ,
46: p_column_name user_tab_columns.column_name%TYPE ,
47: p_hist_date IGS_PS_FLD_STD_HIST_ALL.hist_start_dt%TYPE )
48: RETURN VARCHAR2;
49: PRAGMA RESTRICT_REFERENCES(Audp_Get_Cfosh_Col, WNDS);
50:

Line 70: p_column_name user_tab_columns.column_name%TYPE ,

66: RETURN VARCHAR2;
67: PRAGMA RESTRICT_REFERENCES(Audp_Get_Crch_Col, WNDS);
68:
69: Function Audp_Get_Cth_Col(
70: p_column_name user_tab_columns.column_name%TYPE ,
71: p_course_type IGS_PS_TYPE_ALL.course_type%TYPE ,
72: p_hist_end_dt IGS_PS_TYPE_HIST_ALL.hist_end_dt%TYPE )
73: RETURN VARCHAR2;
74: PRAGMA RESTRICT_REFERENCES(Audp_Get_Cth_Col, WNDS);