PACKAGE: APPS.IGS_AU_GEN_001

Source

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;
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 )
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 ,
26   p_hist_end_dt IN DATE )
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,
36   p_acai_sequence_number IN NUMBER DEFAULT NULL,
37   p_unit_cd IN IGS_AD_PS_APINTUNTHS_ALL.unit_cd%TYPE DEFAULT NULL,
38   p_hist_end_dt IN DATE )
39 RETURN VARCHAR2;
40 PRAGMA RESTRICT_REFERENCES(Audp_Get_Acaiuh_Col, WNDS);
41 
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 
51 Function Audp_Get_Coh_Col(
52   p_course_cd  IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,
53   p_version_number  IGS_PS_OWN_HIST_ALL.version_number%TYPE ,
54   p_org_unit_cd  IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,
55   p_ou_start_dt  IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,
56   p_hist_date  IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )
57 RETURN NUMBER;
58 PRAGMA RESTRICT_REFERENCES(Audp_Get_Coh_Col, WNDS);
59 
60 Function Audp_Get_Crch_Col(
61   p_course_cd  IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
62   p_version_number  IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
63   p_reference_cd_type  IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
64   p_reference_cd  IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
65   p_hist_date  IGS_PS_REF_CD_HIST_ALL.hist_start_dt%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);
75 
76 END IGS_AU_GEN_001;