1 PACKAGE igs_au_gen_003 AUTHID CURRENT_USER AS
2 /* $Header: IGSAU03S.pls 115.10 2003/05/23 06:51:02 knaraset ship $ */
3 -- WHO WHEN WHAT
4 -- pradhakr 02/07/2001 Added a function enrp_get_sph_col in this package.
5 -- Changes in the function Audp_Get_scah_col,
6 -- Audp_Get_Suah_Col.
7 -- smaddali 02/07/2001 adding a new function audp_get_enrs_stat in the
8 -- enrollment processes build of nov 2001
9 -- knaraset 29-Apr-03 added p_uoo_id as parameter,also removed the other parameters unit_cd,cal_type and sequence_number
10 -- in functions Audp_Get_Suah_Col and ENRP_RET_WAIVE_PERSON_ID ,
11 -- as part of MUS build bug 2829262
12
13 Function Audp_Get_Enrs_Stat(
14 p_stat_column IN VARCHAR2 ,
15 p_uoo_id IN NUMBER
16 )
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 ,
26 p_ceremony_number IN NUMBER ,
27 p_award_course_cd IN VARCHAR2 ,
28 p_award_crs_version_number IN NUMBER ,
29 p_award_cd IN VARCHAR2 ,
30 p_hist_date IN DATE )
31 RETURN VARCHAR2;
32 PRAGMA RESTRICT_REFERENCES(Audp_Get_Gach_Col, WNDS);
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
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);
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;
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;
63 PRAGMA RESTRICT_REFERENCES(Audp_Get_Scah_Col, WNDS);
64
65 FUNCTION Enrp_Get_Sph_col (
66 p_column_name IN VARCHAR2,
67 p_spl_perm_request_h_id IN NUMBER,
68 p_hist_end_dt IN DATE )
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 )
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 ,
87 p_ci_sequence_number IN NUMBER ,
88 p_outcome_dt IN DATE ,
89 p_hist_end_dt IN DATE,
90 p_uoo_id IN NUMBER)
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 ,
100 p_hist_end_dt IN DATE )
101 RETURN VARCHAR2;
102 PRAGMA RESTRICT_REFERENCES(Audp_Get_Susah_Col, WNDS);
103
104 FUNCTION ENRP_RET_WAIVE_PERSON_ID(
105 P_H_RULE_WAIVED_PERSON_ID IN NUMBER,
106 P_person_id IN NUMBER,
107 P_course_cd IN VARCHAR2,
108 P_hist_end_dt IN DATE,
109 p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)
110 RETURN NUMBER;
111
112 END igs_au_gen_003;