1 PACKAGE IGS_ST_GEN_002 AUTHID CURRENT_USER AS
2 /* $Header: IGSST02S.pls 115.7 2002/11/29 04:10:05 nsidana ship $ */
3
4 /*
5 || Created By : [email protected]
6 || Created On : 28-AUG-2000
7 || Purpose :
8 || Known limitations, enhancements or remarks :
9 || Change History :
10 || Who When What
11 || pkpatel 05-MAR-2002 Bug NO: 2224621
12 || Modified P_GOVT_PRIOR_UG_INST from NUMBER to VARCHAR2 in STAP_GET_PERSON_DATA. Since its source
13 || IGS_OR_INSTITUTION.GOVT_INSTITUTION_CD is modified from NUMBER to VARCHAR2.
14 || (reverse chronological order - newest change first)
15 */
16
17 Function Stap_Get_Course_Lvl(
18 p_course_cd IN VARCHAR2 ,
19 p_version_number IN NUMBER ,
20 p_govt_course_type IN NUMBER )
21 RETURN NUMBER;
22 PRAGMA RESTRICT_REFERENCES(STAP_GET_COURSE_LVL,WNDS);
23
24 Procedure Stap_Get_Crs_Study(
25 p_course_cd IGS_PS_VER_ALL.course_cd%TYPE ,
26 p_version_number IGS_PS_VER_ALL.version_number%TYPE ,
27 p_reference_cd OUT NOCOPY IGS_PS_REF_CD.reference_cd%TYPE ,
28 p_description OUT NOCOPY IGS_PS_VER_ALL.title%TYPE );
29
30 Function Stap_Get_Govt_Ou_Cd(
31 p_org_unit_cd IN VARCHAR2 )
32 RETURN VARCHAR2;
33
34 Function Stap_Get_Govt_Sem(
35 p_submission_yr IN NUMBER ,
36 p_submission_number IN NUMBER ,
37 p_load_cal_type IN VARCHAR2 ,
38 p_load_ci_sequence_number IN NUMBER ,
39 p_teach_cal_type IN VARCHAR2 )
40 RETURN NUMBER;
41 PRAGMA RESTRICT_REFERENCES(STAP_GET_GOVT_SEM,WNDS);
42
43 Function Stap_Get_New_Hgh_Edu(
44 p_person_id IN NUMBER ,
45 p_course_cd IN VARCHAR2 ,
46 p_commencing_student_ind IN VARCHAR2 DEFAULT 'N')
47 RETURN NUMBER;
48
49 Procedure Stap_Get_Pcc_Pe_Dtl(
50 p_person_id IN NUMBER ,
51 p_effective_dt IN DATE ,
52 p_birth_dt OUT NOCOPY DATE ,
53 p_sex OUT NOCOPY VARCHAR2 ,
54 p_govt_aborig_torres_cd OUT NOCOPY NUMBER ,
55 p_govt_citizenship_cd OUT NOCOPY NUMBER ,
56 p_govt_birth_country_cd OUT NOCOPY VARCHAR2 ,
57 p_yr_arrival OUT NOCOPY VARCHAR2 ,
58 p_govt_home_language_cd OUT NOCOPY NUMBER );
59
60 Procedure Stap_Get_Person_Data(
61 p_person_id IN NUMBER ,
62 p_course_cd IN VARCHAR2 ,
63 p_crv_version_number IN NUMBER ,
64 p_effective_dt IN DATE ,
65 p_commencing_student_ind IN VARCHAR2 DEFAULT 'N',
66 p_logged_ind IN OUT NOCOPY BOOLEAN ,
67 p_s_log_type IN VARCHAR2 ,
68 p_creation_dt IN DATE ,
69 p_birth_dt OUT NOCOPY DATE ,
70 p_sex OUT NOCOPY VARCHAR2 ,
71 p_aborig_torres_cd OUT NOCOPY VARCHAR2 ,
72 p_govt_aborig_torres_cd OUT NOCOPY NUMBER ,
73 p_citizenship_cd OUT NOCOPY VARCHAR2 ,
74 p_govt_citizenship_cd OUT NOCOPY NUMBER ,
75 p_perm_resident_cd OUT NOCOPY VARCHAR2 ,
76 p_govt_perm_resident_cd OUT NOCOPY NUMBER ,
77 p_home_location_cd OUT NOCOPY VARCHAR2 ,
78 p_govt_home_location_cd OUT NOCOPY VARCHAR2 ,
79 p_term_location_cd OUT NOCOPY VARCHAR2 ,
80 p_govt_term_location_cd OUT NOCOPY VARCHAR2 ,
81 p_birth_country_cd OUT NOCOPY VARCHAR2 ,
82 p_govt_birth_country_cd OUT NOCOPY VARCHAR2 ,
83 p_yr_arrival OUT NOCOPY VARCHAR2 ,
84 p_home_language_cd OUT NOCOPY VARCHAR2 ,
85 p_govt_home_language_cd OUT NOCOPY NUMBER ,
86 p_prior_ug_inst OUT NOCOPY VARCHAR2 ,
87 p_govt_prior_ug_inst OUT NOCOPY VARCHAR2 ,
88 p_prior_other_qual OUT NOCOPY VARCHAR2 ,
89 p_prior_post_grad OUT NOCOPY VARCHAR2 ,
90 p_prior_degree OUT NOCOPY VARCHAR2 ,
91 p_prior_subdeg_notafe OUT NOCOPY VARCHAR2 ,
92 p_prior_subdeg_tafe OUT NOCOPY VARCHAR2 ,
93 p_prior_seced_tafe OUT NOCOPY VARCHAR2 ,
94 p_prior_seced_school OUT NOCOPY VARCHAR2 ,
95 p_prior_tafe_award OUT NOCOPY VARCHAR2 ,
96 p_govt_disability OUT NOCOPY VARCHAR2 );
97
98
99 END IGS_ST_GEN_002;