1 PACKAGE IGS_ST_GEN_003 AUTHID CURRENT_USER AS
2 /* $Header: IGSST03S.pls 115.8 2003/05/13 09:01:13 kkillams ship $ */
3 /*
4 || Created By : [email protected]
5 || Created On : 28-AUG-2000
6 || Purpose :
7 || Known limitations, enhancements or remarks :
8 || Change History :
9 || Who When What
10 || pkpatel 05-MAR-2002 Bug NO: 2224621
11 || Modified P_GOVT_EXEMPTION_INST_CD from NUMBER to VARCHAR2 in STAP_GET_SCA_DATA. Since its source
12 || IGS_OR_INSTITUTION.GOVT_INSTITUTION_CD is modified from NUMBER to VARCHAR2.
13 || (reverse chronological order - newest change first)
14 || kkillams 11-MAY-2003 Added new parameter p_uoo_id to the Stap_Get_Rptbl_Govt and Stap_Get_Rptbl_Sbmsn functions
15 ||
16 || w.r.t. bug number 2829262
17 || (reverse chronological order - newest change first)
18 */
19
20
21 Function Stap_Get_Prsn_Dsblty(
22 p_person_id IN NUMBER )
23 RETURN VARCHAR2;
24
25 Procedure Stap_Get_Prsn_Names(
26 p_person_id IN NUMBER ,
27 p_given_name OUT NOCOPY VARCHAR2 ,
28 p_other_names OUT NOCOPY VARCHAR2 );
29
30 Function Stap_Get_Rptbl_Benc(
31 p_person_id IN NUMBER ,
32 p_course_cd IN VARCHAR2 ,
33 p_crv_version_number IN NUMBER ,
34 p_govt_reportable_ind IN VARCHAR2 DEFAULT 'N',
35 p_enrolled_dt IN DATE ,
36 p_submission_cutoff_dt IN DATE )
37 RETURN VARCHAR2;
38
39 FUNCTION Stap_Get_Rptbl_Govt(
40 p_person_id IN NUMBER ,
41 p_course_cd IN VARCHAR2 ,
42 p_crv_version_number IN NUMBER ,
43 p_unit_cd IN VARCHAR2 ,
44 p_uv_version_number IN NUMBER ,
45 p_teach_cal_type IN VARCHAR2 ,
46 p_teach_ci_sequence_number IN NUMBER ,
47 p_tr_org_unit_cd IN VARCHAR2 ,
48 p_tr_ou_start_dt IN DATE ,
49 p_eftsu IN NUMBER ,
50 p_effective_dt IN DATE ,
51 p_exclusion_level OUT NOCOPY VARCHAR2,
52 p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
53 RETURN VARCHAR2;
54
55 FUNCTION Stap_Get_Rptbl_Sbmsn(
56 p_submission_yr IN NUMBER ,
57 p_submission_number IN NUMBER ,
58 p_person_id IN NUMBER ,
59 p_course_cd IN VARCHAR2 ,
60 p_crv_version_number IN NUMBER ,
61 p_unit_cd IN VARCHAR2 ,
62 p_uv_version_number IN NUMBER ,
63 p_teach_cal_type IN VARCHAR2 ,
64 p_teach_ci_sequence_number IN NUMBER ,
65 p_tr_org_unit_cd IN VARCHAR2 ,
66 p_tr_ou_start_dt IN DATE ,
67 p_eftsu IN NUMBER ,
68 p_enrolled_dt IN DATE ,
69 p_discontinued_dt IN DATE ,
70 p_govt_semester IN NUMBER ,
71 p_teach_census_dt IN DATE ,
72 p_load_cal_type IN VARCHAR2 ,
73 p_load_ci_sequence_number IN NUMBER,
74 p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
75 RETURN VARCHAR2;
76
77 Procedure Stap_Get_Sca_Data(
78 p_submission_yr NUMBER ,
79 p_submission_number IN NUMBER ,
80 p_person_id IN NUMBER ,
81 p_course_cd IN VARCHAR2 ,
82 p_effective_dt IN DATE ,
83 p_crv_version_number IN NUMBER ,
84 p_commencing_student_ind IN VARCHAR2 DEFAULT 'N',
85 p_load_cal_type IN VARCHAR2 ,
86 p_load_ci_sequence_number IN NUMBER ,
87 p_logged_ind IN OUT NOCOPY BOOLEAN ,
88 p_s_log_type IN VARCHAR2 ,
89 p_creation_dt IN DATE ,
90 p_govt_semester IN NUMBER ,
91 p_award_course_ind IN VARCHAR2 DEFAULT 'N',
92 p_govt_citizenship_cd IN VARCHAR2 ,
93 p_prior_seced_tafe IN VARCHAR2 ,
94 p_prior_seced_school IN VARCHAR2 ,
95 p_sca_commencement_dt OUT NOCOPY DATE ,
96 p_prior_studies_exemption OUT NOCOPY NUMBER ,
97 p_exemption_institution_cd OUT NOCOPY VARCHAR2 ,
98 p_govt_exemption_inst_cd OUT NOCOPY VARCHAR2 ,
99 p_tertiary_entrance_score OUT NOCOPY NUMBER ,
100 p_basis_for_admission_type OUT NOCOPY VARCHAR2 ,
101 p_govt_basis_for_adm_type OUT NOCOPY VARCHAR2 ,
102 p_hecs_amount_pd OUT NOCOPY NUMBER ,
103 p_hecs_payment_option OUT NOCOPY VARCHAR2 ,
104 p_govt_hecs_payment_option OUT NOCOPY VARCHAR2 ,
105 p_tuition_fee OUT NOCOPY NUMBER ,
106 p_hecs_fee OUT NOCOPY NUMBER ,
107 p_differential_hecs_ind OUT NOCOPY VARCHAR2 );
108
109 Function Stap_Get_Sch_Leaver(
110 p_person_id IN NUMBER ,
111 p_course_cd IN VARCHAR2 ,
112 p_commencing_student_ind IN VARCHAR2 DEFAULT 'N',
113 p_collection_yr IN NUMBER )
114 RETURN NUMBER;
115
116 Function Stap_Get_Spclstn(
117 p_course_cd IN VARCHAR2 ,
118 p_version_number IN NUMBER )
119 RETURN VARCHAR2;
120
121
122 END IGS_ST_GEN_003;