1 PACKAGE igs_ad_appl_pkg AS
2 /* $Header: IGSAI04S.pls 120.2 2005/08/08 04:29:05 appldev ship $ */
3
4
5 PROCEDURE insert_row (
6 X_ROWID in out NOCOPY VARCHAR2,
7 X_ORG_ID in NUMBER,
8 X_PERSON_ID in NUMBER,
9 X_ADMISSION_APPL_NUMBER in NUMBER,
10 X_APPL_DT in DATE,
11 X_ACAD_CAL_TYPE in VARCHAR2,
12 X_ACAD_CI_SEQUENCE_NUMBER in NUMBER,
13 X_ADM_CAL_TYPE in VARCHAR2,
14 X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
15 X_ADMISSION_CAT in VARCHAR2,
16 X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
17 X_ADM_APPL_STATUS in VARCHAR2,
18 X_ADM_FEE_STATUS in VARCHAR2,
19 X_TAC_APPL_IND in VARCHAR2,
20 x_spcl_grp_1 IN NUMBER DEFAULT NULL,
21 x_spcl_grp_2 IN NUMBER DEFAULT NULL,
22 x_common_app IN VARCHAR2 DEFAULT NULL,
23 x_application_type IN VARCHAR2 DEFAULT NULL,
24 X_MODE IN VARCHAR2 DEFAULT 'R' ,
25 x_choice_number IN VARCHAR2 DEFAULT NULL,
26 x_routeb_pref IN VARCHAR2 DEFAULT NULL,
27 x_alt_appl_id IN VARCHAR2 DEFAULT NULL,
28 x_appl_fee_amt IN NUMBER DEFAULT NULL
29 );
30
31
32 PROCEDURE lock_row (
33 X_ROWID in VARCHAR2,
34 X_PERSON_ID in NUMBER,
35 X_ADMISSION_APPL_NUMBER in NUMBER,
36 X_APPL_DT in DATE,
37 X_ACAD_CAL_TYPE in VARCHAR2,
38 X_ACAD_CI_SEQUENCE_NUMBER in NUMBER,
39 X_ADM_CAL_TYPE in VARCHAR2,
40 X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
41 X_ADMISSION_CAT in VARCHAR2,
42 X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
43 X_ADM_APPL_STATUS in VARCHAR2,
44 X_ADM_FEE_STATUS in VARCHAR2,
45 X_TAC_APPL_IND in VARCHAR2,
46 x_spcl_grp_1 IN NUMBER DEFAULT NULL,
47 x_spcl_grp_2 IN NUMBER DEFAULT NULL,
48 x_common_app IN VARCHAR2 DEFAULT NULL,
49 x_application_type IN VARCHAR2 DEFAULT NULL,
50 x_choice_number IN VARCHAR2 DEFAULT NULL,
51 x_routeb_pref IN VARCHAR2 DEFAULT NULL,
52 x_alt_appl_id IN VARCHAR2 DEFAULT NULL,
53 x_appl_fee_amt IN NUMBER DEFAULT NULL
54 );
55
56
57 PROCEDURE update_row (
58 X_ROWID in VARCHAR2,
59 X_PERSON_ID in NUMBER,
60 X_ADMISSION_APPL_NUMBER in NUMBER,
61 X_APPL_DT in DATE,
62 X_ACAD_CAL_TYPE in VARCHAR2,
63 X_ACAD_CI_SEQUENCE_NUMBER in NUMBER,
64 X_ADM_CAL_TYPE in VARCHAR2,
65 X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
66 X_ADMISSION_CAT in VARCHAR2,
67 X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
68 X_ADM_APPL_STATUS in VARCHAR2,
69 X_ADM_FEE_STATUS in VARCHAR2,
70 X_TAC_APPL_IND in VARCHAR2,
71 x_spcl_grp_1 IN NUMBER DEFAULT NULL,
72 x_spcl_grp_2 IN NUMBER DEFAULT NULL,
73 x_common_app IN VARCHAR2 DEFAULT NULL,
74 x_application_type IN VARCHAR2 DEFAULT NULL,
75 X_MODE in VARCHAR2 default 'R',
76 x_choice_number IN VARCHAR2 DEFAULT NULL,
77 x_routeb_pref IN VARCHAR2 DEFAULT NULL,
78 x_alt_appl_id IN VARCHAR2 DEFAULT NULL,
79 x_appl_fee_amt IN NUMBER DEFAULT NULL
80 );
81
82
83 PROCEDURE add_row (
84 X_ROWID in out NOCOPY VARCHAR2,
85 X_ORG_ID in NUMBER,
86 X_PERSON_ID in NUMBER,
87 X_ADMISSION_APPL_NUMBER in NUMBER,
88 X_APPL_DT in DATE,
89 X_ACAD_CAL_TYPE in VARCHAR2,
90 X_ACAD_CI_SEQUENCE_NUMBER in NUMBER,
91 X_ADM_CAL_TYPE in VARCHAR2,
92 X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
93 X_ADMISSION_CAT in VARCHAR2,
94 X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
95 X_ADM_APPL_STATUS in VARCHAR2,
96 X_ADM_FEE_STATUS in VARCHAR2,
97 X_TAC_APPL_IND in VARCHAR2,
98 x_spcl_grp_1 IN NUMBER DEFAULT NULL,
99 x_spcl_grp_2 IN NUMBER DEFAULT NULL,
100 x_common_app IN VARCHAR2 DEFAULT NULL,
101 x_application_type IN VARCHAR2 DEFAULT NULL,
102 X_MODE IN VARCHAR2 DEFAULT 'R',
103 x_choice_number IN VARCHAR2 DEFAULT NULL,
104 x_routeb_pref IN VARCHAR2 DEFAULT NULL,
105 x_alt_appl_id IN VARCHAR2 DEFAULT NULL,
106 x_appl_fee_amt IN NUMBER DEFAULT NULL
107 );
108
109
110 PROCEDURE delete_row (
111 X_ROWID in VARCHAR2,
112 x_mode IN VARCHAR2 DEFAULT 'R'
113 );
114
115 FUNCTION get_pk_for_validation (
116 x_person_id IN NUMBER,
117 x_admission_appl_number IN NUMBER
118 )
119 RETURN BOOLEAN;
120
121 PROCEDURE get_fk_igs_ad_ss_appl_typ(
122 x_application_type IN VARCHAR2
123 );
124
125 PROCEDURE get_fk_igs_ca_inst_rel (
126 x_sub_cal_type IN VARCHAR2,
127 x_sub_ci_sequence_number IN NUMBER,
128 x_sup_cal_type IN VARCHAR2,
129 x_sup_ci_sequence_number IN NUMBER
130 );
131
132 PROCEDURE get_fk_igs_pe_person (
133 x_person_id IN NUMBER
134 );
135
136 PROCEDURE get_fk_igs_ad_appl_stat (
137 x_adm_appl_status IN VARCHAR2
138 );
139
140 PROCEDURE get_fk_igs_ad_fee_stat (
141 x_adm_fee_status IN VARCHAR2
142 );
143
144 PROCEDURE get_fk_igs_ad_prd_ad_prc_ca (
145 x_adm_cal_type IN VARCHAR2,
146 x_adm_ci_sequence_number IN NUMBER,
147 x_admission_cat IN VARCHAR2,
148 x_s_admission_process_type IN VARCHAR2
149 );
150
151 PROCEDURE get_fk_igs_ad_prcs_cat (
152 x_admission_cat IN VARCHAR2,
153 x_s_admission_process_type IN VARCHAR2
154 );
155
156 PROCEDURE get_fk_igs_ad_code_classes (
157 x_code_id IN NUMBER
158 );
159
160 -- added to take care of check constraints
161 PROCEDURE check_constraints(
162 column_name IN VARCHAR2 DEFAULT NULL,
163 column_value IN VARCHAR2 DEFAULT NULL
164 );
165 PROCEDURE before_dml (
166 p_action IN VARCHAR2,
167 x_rowid IN VARCHAR2 DEFAULT NULL,
168 x_org_id in NUMBER DEFAULT NULL,
169 x_person_id IN NUMBER DEFAULT NULL,
170 x_admission_appl_number IN NUMBER DEFAULT NULL,
171 x_appl_dt IN DATE DEFAULT NULL,
172 x_acad_cal_type IN VARCHAR2 DEFAULT NULL,
173 x_acad_ci_sequence_number IN NUMBER DEFAULT NULL,
174 x_adm_cal_type IN VARCHAR2 DEFAULT NULL,
175 x_adm_ci_sequence_number IN NUMBER DEFAULT NULL,
176 x_admission_cat IN VARCHAR2 DEFAULT NULL,
177 x_s_admission_process_type IN VARCHAR2 DEFAULT NULL,
178 x_adm_appl_status IN VARCHAR2 DEFAULT NULL,
179 x_adm_fee_status IN VARCHAR2 DEFAULT NULL,
180 x_tac_appl_ind IN VARCHAR2 DEFAULT NULL,
181 x_spcl_grp_1 IN NUMBER DEFAULT NULL,
182 x_spcl_grp_2 IN NUMBER DEFAULT NULL,
183 x_common_app IN VARCHAR2 DEFAULT NULL,
184 x_application_type IN VARCHAR2 DEFAULT NULL,
185 x_creation_date IN DATE DEFAULT NULL,
186 x_created_by IN NUMBER DEFAULT NULL,
187 x_last_update_date IN DATE DEFAULT NULL,
188 x_last_updated_by IN NUMBER DEFAULT NULL,
189 x_last_update_login IN NUMBER DEFAULT NULL,
190 x_choice_number IN VARCHAR2 DEFAULT NULL,
191 x_routeb_pref IN VARCHAR2 DEFAULT NULL,
192 x_alt_appl_id IN VARCHAR2 DEFAULT NULL,
193 x_appl_fee_amt IN NUMBER DEFAULT NULL
194 );
195
196
197 end igs_ad_appl_pkg;