1 PACKAGE igf_ap_batch_aw_map_pkg AS
2 /* $Header: IGFAI22S.pls 120.1 2005/07/12 08:23:23 appldev ship $ */
3
4 /*=======================================================================+
5 | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|
6 | All rights reserved. |
7 +=======================================================================+
8 | |
9 | DESCRIPTION |
10 | PL/SQL spec for package: IGF_AP_BATCH_AW_MAP_PKG
11 | |
12 | NOTES |
13 | |
14 | This package has a flag on the end of some of the procedures called |
15 | X_MODE. Pass either 'R' for runtime, or 'I' for Install-time. |
16 | This will control how the who columns are filled in; If you are |
17 | running in runtime mode, they are taken from the profiles, whereas in |
18 | install-time mode they get defaulted with special values to indicate |
19 | that they were inserted by datamerge. |
20 | |
21 | The ADD_ROW routine will see whether a row exists by selecting |
22 | based on the primary key, and updates the row if it exists, |
23 | or inserts the row if it doesn't already exist. |
24 | |
25 | This module is called by AutoInstall (afplss.drv) on install and |
26 | upgrade. The WHENEVER SQLERROR and EXIT (at bottom) are required. |
27 | |
28 | HISTORY |
29 | |
30 | bannamal 29-Sep-2004 3416863 cod xml changes for pell and |
31 | direct loan. added two new columns |
32 | cdcruz 02-Jun-2003 #2858504 Legacy Part 1 FA118.1 |
33 | Added new col award_year_status_code per the
34 | TD |
35 | masehgal 17-Oct-2002 # 2613546 FA 105_108 Multiple Award Years |
36 | Added unique check on system award year |
37 | Added new column : |
38 | sys_award_year |
39 | brajendr 04-Jul-2002 Bug # 2436484 - FACR009 Calendar Relations |
40 | Following columns are obsoleted. Signature |
41 | of PKG is retained and all the references |
42 | are removed |
43 | ci_sequence_number_acad |
44 | ci_cal_type_acad |
45 | ci_cal_type_adm |
46 | ci_sequence_number_adm |
47 | |
48 *=======================================================================*/
49
50 PROCEDURE insert_row (
51 x_rowid IN OUT NOCOPY VARCHAR2,
52 x_batch_year IN NUMBER,
53 x_ci_sequence_number IN NUMBER,
54 x_ci_cal_type IN VARCHAR2,
55 x_ci_sequence_number_acad IN NUMBER DEFAULT NULL,
56 x_ci_cal_type_acad IN VARCHAR2 DEFAULT NULL,
57 x_ci_cal_type_adm IN VARCHAR2 DEFAULT NULL,
58 x_ci_sequence_number_adm IN NUMBER DEFAULT NULL,
59 x_bam_id IN OUT NOCOPY NUMBER,
60 x_css_academic_year IN NUMBER,
61 x_efc_frml IN VARCHAR2,
62 x_num_days_divisor IN NUMBER,
63 x_roundoff_fact IN VARCHAR2,
64 x_efc_dob IN DATE,
65 x_dl_code IN VARCHAR2 DEFAULT NULL,
66 x_ffel_code IN VARCHAR2 DEFAULT NULL,
67 x_pell_code IN VARCHAR2 DEFAULT NULL,
68 x_isir_code IN VARCHAR2 DEFAULT NULL,
69 x_profile_code IN VARCHAR2 DEFAULT NULL,
70 x_tolerance_limit IN NUMBER DEFAULT NULL,
71 x_sys_award_year IN VARCHAR2 DEFAULT NULL,
72 x_award_year_status_code IN VARCHAR2 DEFAULT NULL,
73 x_pell_participant_code IN VARCHAR2 DEFAULT NULL,
74 x_dl_participant_code IN VARCHAR2 DEFAULT NULL,
75 x_mode IN VARCHAR2 DEFAULT 'R',
76 x_publish_in_ss_flag IN VARCHAR2 DEFAULT NULL
77 );
78
79 PROCEDURE lock_row (
80 x_rowid IN VARCHAR2,
81 x_batch_year IN NUMBER,
82 x_ci_sequence_number IN NUMBER,
83 x_ci_cal_type IN VARCHAR2,
84 x_ci_sequence_number_acad IN NUMBER DEFAULT NULL,
85 x_ci_cal_type_acad IN VARCHAR2 DEFAULT NULL,
86 x_ci_cal_type_adm IN VARCHAR2 DEFAULT NULL,
87 x_ci_sequence_number_adm IN NUMBER DEFAULT NULL,
88 x_bam_id IN NUMBER,
89 x_css_academic_year IN NUMBER,
90 x_efc_frml IN VARCHAR2,
91 x_num_days_divisor IN NUMBER,
92 x_roundoff_fact IN VARCHAR2,
93 x_efc_dob IN DATE,
94 x_dl_code IN VARCHAR2 DEFAULT NULL,
95 x_ffel_code IN VARCHAR2 DEFAULT NULL,
96 x_pell_code IN VARCHAR2 DEFAULT NULL,
97 x_isir_code IN VARCHAR2 DEFAULT NULL,
98 x_profile_code IN VARCHAR2 DEFAULT NULL,
99 x_tolerance_limit IN NUMBER DEFAULT NULL,
100 x_sys_award_year IN VARCHAR2 DEFAULT NULL,
101 x_award_year_status_code IN VARCHAR2 DEFAULT NULL,
102 x_pell_participant_code IN VARCHAR2 DEFAULT NULL,
103 x_dl_participant_code IN VARCHAR2 DEFAULT NULL,
104 x_publish_in_ss_flag IN VARCHAR2 DEFAULT NULL
105 );
106
107 PROCEDURE update_row (
108 x_rowid IN VARCHAR2,
109 x_batch_year IN NUMBER,
110 x_ci_sequence_number IN NUMBER,
111 x_ci_cal_type IN VARCHAR2,
112 x_ci_sequence_number_acad IN NUMBER DEFAULT NULL,
113 x_ci_cal_type_acad IN VARCHAR2 DEFAULT NULL,
114 x_ci_cal_type_adm IN VARCHAR2 DEFAULT NULL,
115 x_ci_sequence_number_adm IN NUMBER DEFAULT NULL,
116 x_bam_id IN NUMBER,
117 x_css_academic_year IN NUMBER,
118 x_efc_frml IN VARCHAR2,
119 x_num_days_divisor IN NUMBER,
120 x_roundoff_fact IN VARCHAR2,
121 x_efc_dob IN DATE,
122 x_dl_code IN VARCHAR2 DEFAULT NULL,
123 x_ffel_code IN VARCHAR2 DEFAULT NULL,
124 x_pell_code IN VARCHAR2 DEFAULT NULL,
125 x_isir_code IN VARCHAR2 DEFAULT NULL,
126 x_profile_code IN VARCHAR2 DEFAULT NULL,
127 x_tolerance_limit IN NUMBER DEFAULT NULL,
128 x_sys_award_year IN VARCHAR2 DEFAULT NULL,
129 x_award_year_status_code IN VARCHAR2 DEFAULT NULL,
130 x_pell_participant_code IN VARCHAR2 DEFAULT NULL,
131 x_dl_participant_code IN VARCHAR2 DEFAULT NULL,
132 x_mode IN VARCHAR2 DEFAULT 'R',
133 x_publish_in_ss_flag IN VARCHAR2 DEFAULT NULL
134 );
135
136 PROCEDURE add_row (
137 x_rowid IN OUT NOCOPY VARCHAR2,
138 x_batch_year IN NUMBER,
139 x_ci_sequence_number IN NUMBER,
140 x_ci_cal_type IN VARCHAR2,
141 x_ci_sequence_number_acad IN NUMBER DEFAULT NULL,
142 x_ci_cal_type_acad IN VARCHAR2 DEFAULT NULL,
143 x_ci_cal_type_adm IN VARCHAR2 DEFAULT NULL,
144 x_ci_sequence_number_adm IN NUMBER DEFAULT NULL,
145 x_bam_id IN OUT NOCOPY NUMBER,
146 x_css_academic_year IN NUMBER,
147 x_efc_frml IN VARCHAR2,
148 x_num_days_divisor IN NUMBER,
149 x_roundoff_fact IN VARCHAR2,
150 x_efc_dob IN DATE,
151 x_dl_code IN VARCHAR2 DEFAULT NULL,
152 x_ffel_code IN VARCHAR2 DEFAULT NULL,
153 x_pell_code IN VARCHAR2 DEFAULT NULL,
154 x_isir_code IN VARCHAR2 DEFAULT NULL,
155 x_profile_code IN VARCHAR2 DEFAULT NULL,
156 x_tolerance_limit IN NUMBER DEFAULT NULL,
157 x_sys_award_year IN VARCHAR2 DEFAULT NULL,
158 x_award_year_status_code IN VARCHAR2 DEFAULT NULL,
159 x_pell_participant_code IN VARCHAR2 DEFAULT NULL,
160 x_dl_participant_code IN VARCHAR2 DEFAULT NULL,
161 x_mode IN VARCHAR2 DEFAULT 'R',
162 x_publish_in_ss_flag IN VARCHAR2 DEFAULT NULL
163 );
164
165 PROCEDURE delete_row (
166 x_rowid IN VARCHAR2
167 );
168
169 FUNCTION get_pk_for_validation (
170 x_bam_id IN NUMBER
171 ) RETURN BOOLEAN;
172
173 FUNCTION get_uk2_for_validation (
174 x_ci_cal_type IN VARCHAR2,
175 x_ci_sequence_number IN NUMBER
176 ) RETURN BOOLEAN;
177
178 FUNCTION get_uk6_for_validation (
179 x_sys_award_year IN VARCHAR2
180 ) RETURN BOOLEAN;
181
182
183 PROCEDURE get_fk_igs_ca_inst (
184 x_cal_type IN VARCHAR2,
185 x_sequence_number IN NUMBER
186 );
187
188 PROCEDURE before_dml (
189 p_action IN VARCHAR2,
190 x_rowid IN VARCHAR2 DEFAULT NULL,
191 x_batch_year IN NUMBER DEFAULT NULL,
192 x_ci_sequence_number IN NUMBER DEFAULT NULL,
193 x_ci_cal_type IN VARCHAR2 DEFAULT NULL,
194 x_ci_sequence_number_acad IN NUMBER DEFAULT NULL,
195 x_ci_cal_type_acad IN VARCHAR2 DEFAULT NULL,
196 x_ci_cal_type_adm IN VARCHAR2 DEFAULT NULL,
197 x_ci_sequence_number_adm IN NUMBER DEFAULT NULL,
198 x_bam_id IN NUMBER DEFAULT NULL,
199 x_css_academic_year IN NUMBER DEFAULT NULL,
200 x_efc_frml IN VARCHAR2 DEFAULT NULL,
201 x_num_days_divisor IN NUMBER DEFAULT NULL,
202 x_roundoff_fact IN VARCHAR2 DEFAULT NULL,
203 x_efc_dob IN DATE DEFAULT NULL,
204 x_dl_code IN VARCHAR2 DEFAULT NULL,
205 x_ffel_code IN VARCHAR2 DEFAULT NULL,
206 x_pell_code IN VARCHAR2 DEFAULT NULL,
207 x_isir_code IN VARCHAR2 DEFAULT NULL,
208 x_profile_code IN VARCHAR2 DEFAULT NULL,
209 x_tolerance_limit IN NUMBER DEFAULT NULL,
210 x_sys_award_year IN VARCHAR2 DEFAULT NULL,
211 x_award_year_status_code IN VARCHAR2 DEFAULT NULL,
212 x_pell_participant_code IN VARCHAR2 DEFAULT NULL,
213 x_dl_participant_code IN VARCHAR2 DEFAULT NULL,
214 x_creation_date IN DATE DEFAULT NULL,
215 x_created_by IN NUMBER DEFAULT NULL,
216 x_last_update_date IN DATE DEFAULT NULL,
217 x_last_updated_by IN NUMBER DEFAULT NULL,
218 x_last_update_login IN NUMBER DEFAULT NULL,
219 x_publish_in_ss_flag IN VARCHAR2 DEFAULT NULL
220 );
221
222 END igf_ap_batch_aw_map_pkg;