1 PACKAGE IGS_AD_GEN_010 AUTHID CURRENT_USER AS
2 /* $Header: IGSAD10S.pls 115.7 2003/12/03 20:48:58 knag ship $ */
3
4 Function Admp_Get_Tac_Api(
5 p_person_id IN NUMBER )
6 RETURN VARCHAR2;
7
8 Function Admp_Get_Tac_Ceprc(
9 p_adm_cal_type IN VARCHAR2 ,
10 p_adm_ci_sequence_number IN NUMBER ,
11 p_acad_cal_type IN VARCHAR2 ,
12 p_reference_cd IN VARCHAR2 ,
13 p_admission_cat IN OUT NOCOPY VARCHAR2 ,
14 p_course_cd OUT NOCOPY VARCHAR2 ,
15 p_version_number OUT NOCOPY NUMBER ,
16 p_cal_type OUT NOCOPY VARCHAR2 ,
17 p_location_cd OUT NOCOPY VARCHAR2 ,
18 p_attendance_mode OUT NOCOPY VARCHAR2 ,
19 p_attendance_type OUT NOCOPY VARCHAR2 ,
20 p_unit_set_cd OUT NOCOPY VARCHAR2 ,
21 p_us_version_number OUT NOCOPY NUMBER ,
22 p_coo_id OUT NOCOPY NUMBER ,
23 p_ref_cd_type OUT NOCOPY VARCHAR2 ,
24 p_message_name OUT NOCOPY VARCHAR2 )
25 RETURN BOOLEAN;
26
27 Function Admp_Get_Tac_Return(
28 p_tac_person_id IN VARCHAR2 ,
29 p_surname IN VARCHAR2 ,
30 p_given_name1 IN VARCHAR2 ,
31 p_given_name2 IN VARCHAR2 ,
32 p_tac_course_cd IN OUT NOCOPY VARCHAR2 ,
33 p_acad_cal_type IN VARCHAR2 ,
34 p_acad_ci_sequence_number IN NUMBER ,
35 p_offer_response OUT NOCOPY VARCHAR2 ,
36 p_enrol_status OUT NOCOPY VARCHAR2 ,
37 p_attendance_type OUT NOCOPY VARCHAR2 ,
38 p_attendance_mode OUT NOCOPY VARCHAR2 ,
39 p_message_name OUT NOCOPY VARCHAR2 )
40 RETURN BOOLEAN;
41
42 Function Admp_Get_Unit_Det(
43 p_person_id IN NUMBER ,
44 p_admission_appl_number IN NUMBER ,
45 p_nominated_course_cd IN VARCHAR2 ,
46 p_acai_sequence_number IN NUMBER ,
47 p_record_number IN NUMBER )
48 RETURN VARCHAR2;
49
50 Function Admp_Ins_Aal(
51 p_person_id IN NUMBER ,
52 p_admission_appl_number IN NUMBER ,
53 p_correspondence_type IN VARCHAR2 ,
54 p_admission_cat IN VARCHAR2 ,
55 p_s_admission_process_type IN VARCHAR2 ,
56 p_message_name OUT NOCOPY VARCHAR2 )
57 RETURN BOOLEAN;
58
59 Function Admp_Ins_Aal_Commit(
60 p_person_id IN NUMBER ,
61 p_admission_appl_number IN NUMBER ,
62 p_correspondence_type IN VARCHAR2 ,
63 p_admission_cat IN VARCHAR2 ,
64 p_s_admission_process_type IN VARCHAR2 ,
65 p_message_name OUT NOCOPY VARCHAR2 )
66 RETURN BOOLEAN;
67
68 Procedure Admp_Ins_Aa_Hist(
69 p_person_id IN IGS_AD_APPL_ALL.person_id%TYPE ,
70 p_admission_appl_number IN NUMBER ,
71 p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
72 p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
73 p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
74 p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
75 p_new_acad_ci_sequence_number IN NUMBER ,
76 p_old_acad_ci_sequence_number IN NUMBER ,
77 p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
78 p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
79 p_new_adm_ci_sequence_number IN NUMBER ,
80 p_old_adm_ci_sequence_number IN NUMBER ,
81 p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
82 p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
83 p_new_s_admission_process_type IN VARCHAR2 ,
84 p_old_s_admission_process_type IN VARCHAR2 ,
85 p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
86 p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
87 p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
88 p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
89 p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
90 p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
91 p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
92 p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
93 p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
94 p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE );
95
96 Procedure Admp_Ins_Acaiu_Hist(
97 p_person_id IN NUMBER ,
98 p_admission_appl_number IN NUMBER ,
99 p_nominated_course_cd IN VARCHAR2 ,
100 p_acai_sequence_number IN NUMBER ,
101 p_unit_cd IN VARCHAR2 ,
102 p_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
103 p_new_uv_version_number IN NUMBER ,
104 p_old_uv_version_number IN NUMBER ,
105 p_new_cal_type IN VARCHAR2 ,
106 p_old_cal_type IN VARCHAR2 ,
107 p_new_ci_sequence_number IN NUMBER ,
108 p_old_ci_sequence_number IN NUMBER ,
109 p_new_location_cd IN VARCHAR2 ,
110 p_old_location_cd IN VARCHAR2 ,
111 p_new_unit_class IN VARCHAR2 ,
112 p_old_unit_class IN VARCHAR2 ,
113 p_new_unit_mode IN VARCHAR2 ,
114 p_old_unit_mode IN VARCHAR2 ,
115 p_new_adm_unit_outcome_status IN VARCHAR2 ,
116 p_old_adm_unit_outcome_status IN VARCHAR2 ,
117 p_new_ass_tracking_id IN NUMBER ,
118 p_old_ass_tracking_id IN NUMBER ,
119 p_new_rule_waived_dt IN DATE ,
120 p_old_rule_waived_dt IN DATE ,
121 p_new_rule_waived_person_id IN NUMBER ,
122 p_old_rule_waived_person_id IN NUMBER ,
123 p_new_sup_unit_cd IN VARCHAR2 ,
124 p_old_sup_unit_cd IN VARCHAR2 ,
125 p_new_sup_uv_version_number IN NUMBER ,
126 p_old_sup_uv_version_number IN NUMBER ,
127 p_new_update_who IN VARCHAR2 ,
128 p_old_update_who IN VARCHAR2 ,
129 p_new_update_on IN DATE ,
130 p_old_update_on IN DATE );
131
132 END IGS_AD_GEN_010;