eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_GET_SCAEH dependencies on IGS_AU_GEN_003

Line 112: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL1');

108: gr_scaeh.r_scah.course_cd := p_scah_rec.course_cd;
109: gr_scaeh.r_scah.hist_start_dt := p_scah_rec.hist_start_dt;
110: gr_scaeh.r_scah.hist_end_dt := p_scah_rec.hist_end_dt;
111: gr_scaeh.r_scah.hist_who := p_scah_rec.hist_who;
112: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL1');
113: gr_scaeh.r_scah.version_number :=
114: NVL(p_scah_rec.version_number,
115: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('VERSION_NUMBER',
116: p_scah_rec.person_id,

Line 115: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('VERSION_NUMBER',

111: gr_scaeh.r_scah.hist_who := p_scah_rec.hist_who;
112: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL1');
113: gr_scaeh.r_scah.version_number :=
114: NVL(p_scah_rec.version_number,
115: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('VERSION_NUMBER',
116: p_scah_rec.person_id,
117: p_scah_rec.course_cd,
118: p_scah_rec.hist_end_dt)),
119: p_sca_rec.version_number));

Line 120: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL1');

116: p_scah_rec.person_id,
117: p_scah_rec.course_cd,
118: p_scah_rec.hist_end_dt)),
119: p_sca_rec.version_number));
120: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL1');
121: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL2');
122: gr_scaeh.r_scah.cal_type:=
123: NVL(p_scah_rec.cal_type,
124: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('CAL_TYPE',

Line 121: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL2');

117: p_scah_rec.course_cd,
118: p_scah_rec.hist_end_dt)),
119: p_sca_rec.version_number));
120: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL1');
121: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL2');
122: gr_scaeh.r_scah.cal_type:=
123: NVL(p_scah_rec.cal_type,
124: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('CAL_TYPE',
125: p_scah_rec.person_id,

Line 124: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('CAL_TYPE',

120: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL1');
121: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL2');
122: gr_scaeh.r_scah.cal_type:=
123: NVL(p_scah_rec.cal_type,
124: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('CAL_TYPE',
125: p_scah_rec.person_id,
126: p_scah_rec.course_cd,
127: p_scah_rec.hist_end_dt),
128: p_scah_rec.cal_type));

Line 129: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL2');

125: p_scah_rec.person_id,
126: p_scah_rec.course_cd,
127: p_scah_rec.hist_end_dt),
128: p_scah_rec.cal_type));
129: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL2');
130: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL3');
131: gr_scaeh.r_scah.location_cd :=
132: NVL(p_scah_rec.location_cd,
133: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LOCATION_CD',

Line 130: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL3');

126: p_scah_rec.course_cd,
127: p_scah_rec.hist_end_dt),
128: p_scah_rec.cal_type));
129: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL2');
130: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL3');
131: gr_scaeh.r_scah.location_cd :=
132: NVL(p_scah_rec.location_cd,
133: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LOCATION_CD',
134: p_scah_rec.person_id,

Line 133: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LOCATION_CD',

129: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL2');
130: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL3');
131: gr_scaeh.r_scah.location_cd :=
132: NVL(p_scah_rec.location_cd,
133: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LOCATION_CD',
134: p_scah_rec.person_id,
135: p_scah_rec.course_cd,
136: p_scah_rec.hist_end_dt),
137: p_sca_rec.location_cd));

Line 138: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL3');

134: p_scah_rec.person_id,
135: p_scah_rec.course_cd,
136: p_scah_rec.hist_end_dt),
137: p_sca_rec.location_cd));
138: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL3');
139: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL4');
140: gr_scaeh.r_scah.attendance_mode :=
141: NVL(p_scah_rec.attendance_mode,
142: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ATTENDANCE_MODE',

Line 139: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL4');

135: p_scah_rec.course_cd,
136: p_scah_rec.hist_end_dt),
137: p_sca_rec.location_cd));
138: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL3');
139: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL4');
140: gr_scaeh.r_scah.attendance_mode :=
141: NVL(p_scah_rec.attendance_mode,
142: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ATTENDANCE_MODE',
143: p_scah_rec.person_id,

Line 142: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ATTENDANCE_MODE',

138: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL3');
139: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL4');
140: gr_scaeh.r_scah.attendance_mode :=
141: NVL(p_scah_rec.attendance_mode,
142: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ATTENDANCE_MODE',
143: p_scah_rec.person_id,
144: p_scah_rec.course_cd,
145: p_scah_rec.hist_end_dt),
146: p_sca_rec.ATTENDANCE_MODE));

Line 147: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL4');

143: p_scah_rec.person_id,
144: p_scah_rec.course_cd,
145: p_scah_rec.hist_end_dt),
146: p_sca_rec.ATTENDANCE_MODE));
147: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL4');
148: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL5');
149: gr_scaeh.r_scah.attendance_type :=
150: NVL(p_scah_rec.attendance_type,
151: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ATTENDANCE_TYPE',

Line 148: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL5');

144: p_scah_rec.course_cd,
145: p_scah_rec.hist_end_dt),
146: p_sca_rec.ATTENDANCE_MODE));
147: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL4');
148: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL5');
149: gr_scaeh.r_scah.attendance_type :=
150: NVL(p_scah_rec.attendance_type,
151: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ATTENDANCE_TYPE',
152: p_scah_rec.person_id,

Line 151: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ATTENDANCE_TYPE',

147: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL4');
148: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL5');
149: gr_scaeh.r_scah.attendance_type :=
150: NVL(p_scah_rec.attendance_type,
151: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ATTENDANCE_TYPE',
152: p_scah_rec.person_id,
153: p_scah_rec.course_cd,
154: p_scah_rec.hist_end_dt),
155: p_sca_rec.attendance_mode));

Line 156: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL5');

152: p_scah_rec.person_id,
153: p_scah_rec.course_cd,
154: p_scah_rec.hist_end_dt),
155: p_sca_rec.attendance_mode));
156: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL5');
157: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL6');
158: gr_scaeh.r_scah.student_confirmed_ind :=
159: NVL(p_scah_rec.student_confirmed_ind,
160: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('STUDENT_CONFIRMED_IND',

Line 157: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL6');

153: p_scah_rec.course_cd,
154: p_scah_rec.hist_end_dt),
155: p_sca_rec.attendance_mode));
156: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL5');
157: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL6');
158: gr_scaeh.r_scah.student_confirmed_ind :=
159: NVL(p_scah_rec.student_confirmed_ind,
160: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('STUDENT_CONFIRMED_IND',
161: p_scah_rec.person_id,

Line 160: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('STUDENT_CONFIRMED_IND',

156: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL5');
157: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL6');
158: gr_scaeh.r_scah.student_confirmed_ind :=
159: NVL(p_scah_rec.student_confirmed_ind,
160: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('STUDENT_CONFIRMED_IND',
161: p_scah_rec.person_id,
162: p_scah_rec.course_cd,
163: p_scah_rec.hist_end_dt),
164: p_sca_rec.student_confirmed_ind));

Line 165: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL6');

161: p_scah_rec.person_id,
162: p_scah_rec.course_cd,
163: p_scah_rec.hist_end_dt),
164: p_sca_rec.student_confirmed_ind));
165: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL6');
166: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL7');
167: gr_scaeh.r_scah.commencement_dt :=
168: NVL(p_scah_rec.commencement_dt,
169: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COMMENCEMENT_DT',

Line 166: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL7');

162: p_scah_rec.course_cd,
163: p_scah_rec.hist_end_dt),
164: p_sca_rec.student_confirmed_ind));
165: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL6');
166: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL7');
167: gr_scaeh.r_scah.commencement_dt :=
168: NVL(p_scah_rec.commencement_dt,
169: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COMMENCEMENT_DT',
170: p_scah_rec.person_id,

Line 169: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COMMENCEMENT_DT',

165: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL6');
166: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL7');
167: gr_scaeh.r_scah.commencement_dt :=
168: NVL(p_scah_rec.commencement_dt,
169: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COMMENCEMENT_DT',
170: p_scah_rec.person_id,
171: p_scah_rec.course_cd,
172: p_scah_rec.hist_end_dt)),
173: p_sca_rec.commencement_dt));

Line 174: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL7');

170: p_scah_rec.person_id,
171: p_scah_rec.course_cd,
172: p_scah_rec.hist_end_dt)),
173: p_sca_rec.commencement_dt));
174: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL7');
175: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL8');
176: gr_scaeh.r_scah.course_attempt_status :=
177: NVL(p_scah_rec.course_attempt_status,
178: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_ATTEMPT_STATUS',

Line 175: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL8');

171: p_scah_rec.course_cd,
172: p_scah_rec.hist_end_dt)),
173: p_sca_rec.commencement_dt));
174: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL7');
175: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL8');
176: gr_scaeh.r_scah.course_attempt_status :=
177: NVL(p_scah_rec.course_attempt_status,
178: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_ATTEMPT_STATUS',
179: p_scah_rec.person_id,

Line 178: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_ATTEMPT_STATUS',

174: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL7');
175: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL8');
176: gr_scaeh.r_scah.course_attempt_status :=
177: NVL(p_scah_rec.course_attempt_status,
178: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_ATTEMPT_STATUS',
179: p_scah_rec.person_id,
180: p_scah_rec.course_cd,
181: p_scah_rec.hist_end_dt),
182: p_sca_rec.course_attempt_status));

Line 183: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL8');

179: p_scah_rec.person_id,
180: p_scah_rec.course_cd,
181: p_scah_rec.hist_end_dt),
182: p_sca_rec.course_attempt_status));
183: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL8');
184: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL9');
185: gr_scaeh.r_scah.progression_status :=
186: NVL(p_scah_rec.progression_status,
187: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PROGRESSION_STATUS',

Line 184: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL9');

180: p_scah_rec.course_cd,
181: p_scah_rec.hist_end_dt),
182: p_sca_rec.course_attempt_status));
183: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL8');
184: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL9');
185: gr_scaeh.r_scah.progression_status :=
186: NVL(p_scah_rec.progression_status,
187: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PROGRESSION_STATUS',
188: p_scah_rec.person_id,

Line 187: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PROGRESSION_STATUS',

183: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL8');
184: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL9');
185: gr_scaeh.r_scah.progression_status :=
186: NVL(p_scah_rec.progression_status,
187: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PROGRESSION_STATUS',
188: p_scah_rec.person_id,
189: p_scah_rec.course_cd,
190: p_scah_rec.hist_end_dt),
191: p_sca_rec.progression_status));

Line 192: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL9');

188: p_scah_rec.person_id,
189: p_scah_rec.course_cd,
190: p_scah_rec.hist_end_dt),
191: p_sca_rec.progression_status));
192: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL9');
193: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL10');
194: gr_scaeh.r_scah.derived_att_type :=
195: NVL(p_scah_rec.derived_att_type,
196: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_ATT_TYPE',

Line 193: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL10');

189: p_scah_rec.course_cd,
190: p_scah_rec.hist_end_dt),
191: p_sca_rec.progression_status));
192: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL9');
193: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL10');
194: gr_scaeh.r_scah.derived_att_type :=
195: NVL(p_scah_rec.derived_att_type,
196: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_ATT_TYPE',
197: p_scah_rec.person_id,

Line 196: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_ATT_TYPE',

192: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL9');
193: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL10');
194: gr_scaeh.r_scah.derived_att_type :=
195: NVL(p_scah_rec.derived_att_type,
196: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_ATT_TYPE',
197: p_scah_rec.person_id,
198: p_scah_rec.course_cd,
199: p_scah_rec.hist_end_dt),
200: p_sca_rec.derived_att_type));

Line 201: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL10');

197: p_scah_rec.person_id,
198: p_scah_rec.course_cd,
199: p_scah_rec.hist_end_dt),
200: p_sca_rec.derived_att_type));
201: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL10');
202: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL11');
203: gr_scaeh.r_scah.derived_att_mode :=
204: NVL(p_scah_rec.derived_att_mode,
205: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_ATT_MODE',

Line 202: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL11');

198: p_scah_rec.course_cd,
199: p_scah_rec.hist_end_dt),
200: p_sca_rec.derived_att_type));
201: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL10');
202: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL11');
203: gr_scaeh.r_scah.derived_att_mode :=
204: NVL(p_scah_rec.derived_att_mode,
205: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_ATT_MODE',
206: p_scah_rec.person_id,

Line 205: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_ATT_MODE',

201: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL10');
202: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL11');
203: gr_scaeh.r_scah.derived_att_mode :=
204: NVL(p_scah_rec.derived_att_mode,
205: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_ATT_MODE',
206: p_scah_rec.person_id,
207: p_scah_rec.course_cd,
208: p_scah_rec.hist_end_dt),
209: p_sca_rec.derived_att_mode));

Line 210: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL11');

206: p_scah_rec.person_id,
207: p_scah_rec.course_cd,
208: p_scah_rec.hist_end_dt),
209: p_sca_rec.derived_att_mode));
210: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL11');
211: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL12');
212: gr_scaeh.r_scah.provisional_ind :=
213: NVL(p_scah_rec.provisional_ind,
214: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PROVISIONAL_IND',

Line 211: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL12');

207: p_scah_rec.course_cd,
208: p_scah_rec.hist_end_dt),
209: p_sca_rec.derived_att_mode));
210: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL11');
211: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL12');
212: gr_scaeh.r_scah.provisional_ind :=
213: NVL(p_scah_rec.provisional_ind,
214: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PROVISIONAL_IND',
215: p_scah_rec.person_id,

Line 214: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PROVISIONAL_IND',

210: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL11');
211: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL12');
212: gr_scaeh.r_scah.provisional_ind :=
213: NVL(p_scah_rec.provisional_ind,
214: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PROVISIONAL_IND',
215: p_scah_rec.person_id,
216: p_scah_rec.course_cd,
217: p_scah_rec.hist_end_dt),
218: p_sca_rec.provisional_ind));

Line 219: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL12');

215: p_scah_rec.person_id,
216: p_scah_rec.course_cd,
217: p_scah_rec.hist_end_dt),
218: p_sca_rec.provisional_ind));
219: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL12');
220: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL13');
221: gr_scaeh.r_scah.discontinued_dt :=
222: NVL(p_scah_rec.discontinued_dt,
223: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUED_DT',

Line 220: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL13');

216: p_scah_rec.course_cd,
217: p_scah_rec.hist_end_dt),
218: p_sca_rec.provisional_ind));
219: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL12');
220: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL13');
221: gr_scaeh.r_scah.discontinued_dt :=
222: NVL(p_scah_rec.discontinued_dt,
223: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUED_DT',
224: p_scah_rec.person_id,

Line 223: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUED_DT',

219: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL12');
220: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL13');
221: gr_scaeh.r_scah.discontinued_dt :=
222: NVL(p_scah_rec.discontinued_dt,
223: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUED_DT',
224: p_scah_rec.person_id,
225: p_scah_rec.course_cd,
226: p_scah_rec.hist_end_dt)),
227: p_sca_rec.discontinued_dt));

Line 228: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL13');

224: p_scah_rec.person_id,
225: p_scah_rec.course_cd,
226: p_scah_rec.hist_end_dt)),
227: p_sca_rec.discontinued_dt));
228: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL13');
229: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL14');
230: gr_scaeh.r_scah.discontinuation_reason_cd :=
231: NVL(p_scah_rec.discontinuation_reason_cd,
232: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUATION_REASON_CD',

Line 229: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL14');

225: p_scah_rec.course_cd,
226: p_scah_rec.hist_end_dt)),
227: p_sca_rec.discontinued_dt));
228: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL13');
229: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL14');
230: gr_scaeh.r_scah.discontinuation_reason_cd :=
231: NVL(p_scah_rec.discontinuation_reason_cd,
232: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUATION_REASON_CD',
233: p_scah_rec.person_id,

Line 232: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUATION_REASON_CD',

228: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL13');
229: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL14');
230: gr_scaeh.r_scah.discontinuation_reason_cd :=
231: NVL(p_scah_rec.discontinuation_reason_cd,
232: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUATION_REASON_CD',
233: p_scah_rec.person_id,
234: p_scah_rec.course_cd,
235: p_scah_rec.hist_end_dt),
236: p_sca_rec.discontinuation_reason_cd));

Line 237: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL14');

233: p_scah_rec.person_id,
234: p_scah_rec.course_cd,
235: p_scah_rec.hist_end_dt),
236: p_sca_rec.discontinuation_reason_cd));
237: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL14');
238: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL15');
239: gr_scaeh.r_scah.lapsed_dt :=
240: NVL(p_scah_rec.lapsed_dt,
241: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAPSED_DT',

Line 238: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL15');

234: p_scah_rec.course_cd,
235: p_scah_rec.hist_end_dt),
236: p_sca_rec.discontinuation_reason_cd));
237: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL14');
238: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL15');
239: gr_scaeh.r_scah.lapsed_dt :=
240: NVL(p_scah_rec.lapsed_dt,
241: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAPSED_DT',
242: p_scah_rec.person_id,

Line 241: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAPSED_DT',

237: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL14');
238: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL15');
239: gr_scaeh.r_scah.lapsed_dt :=
240: NVL(p_scah_rec.lapsed_dt,
241: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAPSED_DT',
242: p_scah_rec.person_id,
243: p_scah_rec.course_cd,
244: p_scah_rec.hist_end_dt)),
245: p_sca_rec.lapsed_dt));

Line 246: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL15');

242: p_scah_rec.person_id,
243: p_scah_rec.course_cd,
244: p_scah_rec.hist_end_dt)),
245: p_sca_rec.lapsed_dt));
246: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL15');
247: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL16');
248: gr_scaeh.r_scah.funding_source :=
249: NVL(p_scah_rec.funding_source,
250: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('FUNDING_SOURCE',

Line 247: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL16');

243: p_scah_rec.course_cd,
244: p_scah_rec.hist_end_dt)),
245: p_sca_rec.lapsed_dt));
246: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL15');
247: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL16');
248: gr_scaeh.r_scah.funding_source :=
249: NVL(p_scah_rec.funding_source,
250: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('FUNDING_SOURCE',
251: p_scah_rec.person_id,

Line 250: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('FUNDING_SOURCE',

246: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL15');
247: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL16');
248: gr_scaeh.r_scah.funding_source :=
249: NVL(p_scah_rec.funding_source,
250: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('FUNDING_SOURCE',
251: p_scah_rec.person_id,
252: p_scah_rec.course_cd,
253: p_scah_rec.hist_end_dt),
254: p_sca_rec.funding_source));

Line 255: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL16');

251: p_scah_rec.person_id,
252: p_scah_rec.course_cd,
253: p_scah_rec.hist_end_dt),
254: p_sca_rec.funding_source));
255: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL16');
256: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL17');
257: gr_scaeh.r_scah.exam_location_cd :=
258: NVL(p_scah_rec.exam_location_cd,
259: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('EXAM_LOCATION_CD',

Line 256: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL17');

252: p_scah_rec.course_cd,
253: p_scah_rec.hist_end_dt),
254: p_sca_rec.funding_source));
255: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL16');
256: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL17');
257: gr_scaeh.r_scah.exam_location_cd :=
258: NVL(p_scah_rec.exam_location_cd,
259: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('EXAM_LOCATION_CD',
260: p_scah_rec.person_id,

Line 259: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('EXAM_LOCATION_CD',

255: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL16');
256: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL17');
257: gr_scaeh.r_scah.exam_location_cd :=
258: NVL(p_scah_rec.exam_location_cd,
259: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('EXAM_LOCATION_CD',
260: p_scah_rec.person_id,
261: p_scah_rec.course_cd,
262: p_scah_rec.hist_end_dt),
263: p_sca_rec.exam_location_cd));

Line 264: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL17');

260: p_scah_rec.person_id,
261: p_scah_rec.course_cd,
262: p_scah_rec.hist_end_dt),
263: p_sca_rec.exam_location_cd));
264: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL17');
265: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL18');
266: gr_scaeh.r_scah.derived_completion_yr :=
267: NVL(p_scah_rec.derived_completion_yr,
268: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_COMPLETION_YR',

Line 265: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL18');

261: p_scah_rec.course_cd,
262: p_scah_rec.hist_end_dt),
263: p_sca_rec.exam_location_cd));
264: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL17');
265: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL18');
266: gr_scaeh.r_scah.derived_completion_yr :=
267: NVL(p_scah_rec.derived_completion_yr,
268: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_COMPLETION_YR',
269: p_scah_rec.person_id,

Line 268: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_COMPLETION_YR',

264: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL17');
265: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL18');
266: gr_scaeh.r_scah.derived_completion_yr :=
267: NVL(p_scah_rec.derived_completion_yr,
268: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_COMPLETION_YR',
269: p_scah_rec.person_id,
270: p_scah_rec.course_cd,
271: p_scah_rec.hist_end_dt)),
272: p_sca_rec.derived_completion_yr));

Line 273: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL18');

269: p_scah_rec.person_id,
270: p_scah_rec.course_cd,
271: p_scah_rec.hist_end_dt)),
272: p_sca_rec.derived_completion_yr));
273: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL18');
274: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL19');
275: gr_scaeh.r_scah.derived_completion_perd :=
276: NVL(p_scah_rec.derived_completion_perd,
277: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_COMPLETION_PERD',

Line 274: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL19');

270: p_scah_rec.course_cd,
271: p_scah_rec.hist_end_dt)),
272: p_sca_rec.derived_completion_yr));
273: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL18');
274: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL19');
275: gr_scaeh.r_scah.derived_completion_perd :=
276: NVL(p_scah_rec.derived_completion_perd,
277: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_COMPLETION_PERD',
278: p_scah_rec.person_id,

Line 277: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_COMPLETION_PERD',

273: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL18');
274: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL19');
275: gr_scaeh.r_scah.derived_completion_perd :=
276: NVL(p_scah_rec.derived_completion_perd,
277: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_COMPLETION_PERD',
278: p_scah_rec.person_id,
279: p_scah_rec.course_cd,
280: p_scah_rec.hist_end_dt),
281: p_sca_rec.derived_completion_perd));

Line 282: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL19');

278: p_scah_rec.person_id,
279: p_scah_rec.course_cd,
280: p_scah_rec.hist_end_dt),
281: p_sca_rec.derived_completion_perd));
282: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL19');
283: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL20');
284: gr_scaeh.r_scah.nominated_completion_yr :=
285: NVL(p_scah_rec.nominated_completion_yr,
286: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('NOMINATED_COMPLETION_YR',

Line 283: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL20');

279: p_scah_rec.course_cd,
280: p_scah_rec.hist_end_dt),
281: p_sca_rec.derived_completion_perd));
282: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL19');
283: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL20');
284: gr_scaeh.r_scah.nominated_completion_yr :=
285: NVL(p_scah_rec.nominated_completion_yr,
286: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('NOMINATED_COMPLETION_YR',
287: p_scah_rec.person_id,

Line 286: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('NOMINATED_COMPLETION_YR',

282: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL19');
283: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL20');
284: gr_scaeh.r_scah.nominated_completion_yr :=
285: NVL(p_scah_rec.nominated_completion_yr,
286: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('NOMINATED_COMPLETION_YR',
287: p_scah_rec.person_id,
288: p_scah_rec.course_cd,
289: p_scah_rec.hist_end_dt)),
290: p_sca_rec.nominated_completion_yr));

Line 291: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL20');

287: p_scah_rec.person_id,
288: p_scah_rec.course_cd,
289: p_scah_rec.hist_end_dt)),
290: p_sca_rec.nominated_completion_yr));
291: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL20');
292: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL21');
293: gr_scaeh.r_scah.nominated_completion_perd :=
294: NVL(p_scah_rec.nominated_completion_perd,
295: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('NOMINATED_COMPLETION_PERD',

Line 292: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL21');

288: p_scah_rec.course_cd,
289: p_scah_rec.hist_end_dt)),
290: p_sca_rec.nominated_completion_yr));
291: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL20');
292: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL21');
293: gr_scaeh.r_scah.nominated_completion_perd :=
294: NVL(p_scah_rec.nominated_completion_perd,
295: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('NOMINATED_COMPLETION_PERD',
296: p_scah_rec.person_id,

Line 295: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('NOMINATED_COMPLETION_PERD',

291: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL20');
292: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL21');
293: gr_scaeh.r_scah.nominated_completion_perd :=
294: NVL(p_scah_rec.nominated_completion_perd,
295: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('NOMINATED_COMPLETION_PERD',
296: p_scah_rec.person_id,
297: p_scah_rec.course_cd,
298: p_scah_rec.hist_end_dt),
299: p_sca_rec.nominated_completion_perd));

Line 300: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL21');

296: p_scah_rec.person_id,
297: p_scah_rec.course_cd,
298: p_scah_rec.hist_end_dt),
299: p_sca_rec.nominated_completion_perd));
300: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL21');
301: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL22');
302: gr_scaeh.r_scah.rule_check_ind :=
303: NVL(p_scah_rec.rule_check_ind,
304: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('RULE_CHECK_IND',

Line 301: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL22');

297: p_scah_rec.course_cd,
298: p_scah_rec.hist_end_dt),
299: p_sca_rec.nominated_completion_perd));
300: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL21');
301: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL22');
302: gr_scaeh.r_scah.rule_check_ind :=
303: NVL(p_scah_rec.rule_check_ind,
304: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('RULE_CHECK_IND',
305: p_scah_rec.person_id,

Line 304: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('RULE_CHECK_IND',

300: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL21');
301: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL22');
302: gr_scaeh.r_scah.rule_check_ind :=
303: NVL(p_scah_rec.rule_check_ind,
304: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('RULE_CHECK_IND',
305: p_scah_rec.person_id,
306: p_scah_rec.course_cd,
307: p_scah_rec.hist_end_dt),
308: p_sca_rec.rule_check_ind));

Line 309: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL22');

305: p_scah_rec.person_id,
306: p_scah_rec.course_cd,
307: p_scah_rec.hist_end_dt),
308: p_sca_rec.rule_check_ind));
309: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL22');
310: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL23');
311: gr_scaeh.r_scah.waive_option_check_ind :=
312: NVL(p_scah_rec.waive_option_check_ind,
313: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('WAIVE_OPTION_CHECK_IND',

Line 310: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL23');

306: p_scah_rec.course_cd,
307: p_scah_rec.hist_end_dt),
308: p_sca_rec.rule_check_ind));
309: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL22');
310: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL23');
311: gr_scaeh.r_scah.waive_option_check_ind :=
312: NVL(p_scah_rec.waive_option_check_ind,
313: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('WAIVE_OPTION_CHECK_IND',
314: p_scah_rec.person_id,

Line 313: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('WAIVE_OPTION_CHECK_IND',

309: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL22');
310: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL23');
311: gr_scaeh.r_scah.waive_option_check_ind :=
312: NVL(p_scah_rec.waive_option_check_ind,
313: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('WAIVE_OPTION_CHECK_IND',
314: p_scah_rec.person_id,
315: p_scah_rec.course_cd,
316: p_scah_rec.hist_end_dt),
317: p_sca_rec.waive_option_check_ind));

Line 318: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL23');

314: p_scah_rec.person_id,
315: p_scah_rec.course_cd,
316: p_scah_rec.hist_end_dt),
317: p_sca_rec.waive_option_check_ind));
318: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL23');
319: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL24');
320: gr_scaeh.r_scah.last_rule_check_dt :=
321: NVL(p_scah_rec.last_rule_check_dt,
322: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAST_RUL_CHECK_DT',

Line 319: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL24');

315: p_scah_rec.course_cd,
316: p_scah_rec.hist_end_dt),
317: p_sca_rec.waive_option_check_ind));
318: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL23');
319: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL24');
320: gr_scaeh.r_scah.last_rule_check_dt :=
321: NVL(p_scah_rec.last_rule_check_dt,
322: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAST_RUL_CHECK_DT',
323: p_scah_rec.person_id,

Line 322: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAST_RUL_CHECK_DT',

318: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL23');
319: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL24');
320: gr_scaeh.r_scah.last_rule_check_dt :=
321: NVL(p_scah_rec.last_rule_check_dt,
322: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAST_RUL_CHECK_DT',
323: p_scah_rec.person_id,
324: p_scah_rec.course_cd,
325: p_scah_rec.hist_end_dt)),
326: p_sca_rec.last_rule_check_dt));

Line 327: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL24');

323: p_scah_rec.person_id,
324: p_scah_rec.course_cd,
325: p_scah_rec.hist_end_dt)),
326: p_sca_rec.last_rule_check_dt));
327: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL24');
328: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL25');
329: gr_scaeh.r_scah.publish_outcomes_ind :=
330: NVL(p_scah_rec.publish_outcomes_ind,
331: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PUBLISH_OUTCOMES_IND',

Line 328: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL25');

324: p_scah_rec.course_cd,
325: p_scah_rec.hist_end_dt)),
326: p_sca_rec.last_rule_check_dt));
327: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL24');
328: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL25');
329: gr_scaeh.r_scah.publish_outcomes_ind :=
330: NVL(p_scah_rec.publish_outcomes_ind,
331: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PUBLISH_OUTCOMES_IND',
332: p_scah_rec.person_id,

Line 331: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PUBLISH_OUTCOMES_IND',

327: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL24');
328: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL25');
329: gr_scaeh.r_scah.publish_outcomes_ind :=
330: NVL(p_scah_rec.publish_outcomes_ind,
331: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PUBLISH_OUTCOMES_IND',
332: p_scah_rec.person_id,
333: p_scah_rec.course_cd,
334: p_scah_rec.hist_end_dt),
335: p_sca_rec.publish_outcomes_ind));

Line 336: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL25');

332: p_scah_rec.person_id,
333: p_scah_rec.course_cd,
334: p_scah_rec.hist_end_dt),
335: p_sca_rec.publish_outcomes_ind));
336: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL25');
337: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL26');
338: gr_scaeh.r_scah.course_rqrmnt_complete_ind :=
339: NVL(p_scah_rec.course_rqrmnt_complete_ind,
340: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNT_COMPLETE_IND',

Line 337: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL26');

333: p_scah_rec.course_cd,
334: p_scah_rec.hist_end_dt),
335: p_sca_rec.publish_outcomes_ind));
336: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL25');
337: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL26');
338: gr_scaeh.r_scah.course_rqrmnt_complete_ind :=
339: NVL(p_scah_rec.course_rqrmnt_complete_ind,
340: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNT_COMPLETE_IND',
341: p_scah_rec.person_id,

Line 340: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNT_COMPLETE_IND',

336: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL25');
337: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL26');
338: gr_scaeh.r_scah.course_rqrmnt_complete_ind :=
339: NVL(p_scah_rec.course_rqrmnt_complete_ind,
340: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNT_COMPLETE_IND',
341: p_scah_rec.person_id,
342: p_scah_rec.course_cd,
343: p_scah_rec.hist_end_dt),
344: p_sca_rec.course_rqrmnt_complete_ind));

Line 345: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL26');

341: p_scah_rec.person_id,
342: p_scah_rec.course_cd,
343: p_scah_rec.hist_end_dt),
344: p_sca_rec.course_rqrmnt_complete_ind));
345: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL26');
346: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL27');
347: gr_scaeh.r_scah.course_rqrmnts_complete_dt :=
348: NVL(p_scah_rec.course_rqrmnts_complete_dt,
349: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNTS_COMPLETE_DT',

Line 346: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL27');

342: p_scah_rec.course_cd,
343: p_scah_rec.hist_end_dt),
344: p_sca_rec.course_rqrmnt_complete_ind));
345: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL26');
346: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL27');
347: gr_scaeh.r_scah.course_rqrmnts_complete_dt :=
348: NVL(p_scah_rec.course_rqrmnts_complete_dt,
349: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNTS_COMPLETE_DT',
350: p_scah_rec.person_id,

Line 349: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNTS_COMPLETE_DT',

345: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL26');
346: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL27');
347: gr_scaeh.r_scah.course_rqrmnts_complete_dt :=
348: NVL(p_scah_rec.course_rqrmnts_complete_dt,
349: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNTS_COMPLETE_DT',
350: p_scah_rec.person_id,
351: p_scah_rec.course_cd,
352: p_scah_rec.hist_end_dt)),
353: p_sca_rec.course_rqrmnts_complete_dt));

Line 354: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL27');

350: p_scah_rec.person_id,
351: p_scah_rec.course_cd,
352: p_scah_rec.hist_end_dt)),
353: p_sca_rec.course_rqrmnts_complete_dt));
354: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL27');
355: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL28');
356: gr_scaeh.r_scah.s_completed_source_type :=
357: NVL(p_scah_rec.s_completed_source_type,
358: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('S_COMPLETED_SOURCE_TYPE',

Line 355: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL28');

351: p_scah_rec.course_cd,
352: p_scah_rec.hist_end_dt)),
353: p_sca_rec.course_rqrmnts_complete_dt));
354: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL27');
355: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL28');
356: gr_scaeh.r_scah.s_completed_source_type :=
357: NVL(p_scah_rec.s_completed_source_type,
358: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('S_COMPLETED_SOURCE_TYPE',
359: p_scah_rec.person_id,

Line 358: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('S_COMPLETED_SOURCE_TYPE',

354: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL27');
355: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL28');
356: gr_scaeh.r_scah.s_completed_source_type :=
357: NVL(p_scah_rec.s_completed_source_type,
358: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('S_COMPLETED_SOURCE_TYPE',
359: p_scah_rec.person_id,
360: p_scah_rec.course_cd,
361: p_scah_rec.hist_end_dt),
362: p_sca_rec.s_completed_source_type));

Line 363: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL28');

359: p_scah_rec.person_id,
360: p_scah_rec.course_cd,
361: p_scah_rec.hist_end_dt),
362: p_sca_rec.s_completed_source_type));
363: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL28');
364: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL29');
365: gr_scaeh.r_scah.override_time_limitation :=
366: NVL(p_scah_rec.override_time_limitation,
367: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('OVERRIDE_TIME_LIMITATION',

Line 364: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL29');

360: p_scah_rec.course_cd,
361: p_scah_rec.hist_end_dt),
362: p_sca_rec.s_completed_source_type));
363: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL28');
364: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL29');
365: gr_scaeh.r_scah.override_time_limitation :=
366: NVL(p_scah_rec.override_time_limitation,
367: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('OVERRIDE_TIME_LIMITATION',
368: p_scah_rec.person_id,

Line 367: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('OVERRIDE_TIME_LIMITATION',

363: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL28');
364: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL29');
365: gr_scaeh.r_scah.override_time_limitation :=
366: NVL(p_scah_rec.override_time_limitation,
367: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('OVERRIDE_TIME_LIMITATION',
368: p_scah_rec.person_id,
369: p_scah_rec.course_cd,
370: p_scah_rec.hist_end_dt)),
371: p_sca_rec.override_time_limitation));

Line 372: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL29');

368: p_scah_rec.person_id,
369: p_scah_rec.course_cd,
370: p_scah_rec.hist_end_dt)),
371: p_sca_rec.override_time_limitation));
372: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL29');
373: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL30');
374: gr_scaeh.r_scah.advanced_standing_ind :=
375: NVL(p_scah_rec.advanced_standing_ind,
376: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADVANCED_STANDING_IND',

Line 373: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL30');

369: p_scah_rec.course_cd,
370: p_scah_rec.hist_end_dt)),
371: p_sca_rec.override_time_limitation));
372: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL29');
373: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL30');
374: gr_scaeh.r_scah.advanced_standing_ind :=
375: NVL(p_scah_rec.advanced_standing_ind,
376: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADVANCED_STANDING_IND',
377: p_scah_rec.person_id,

Line 376: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADVANCED_STANDING_IND',

372: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL29');
373: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL30');
374: gr_scaeh.r_scah.advanced_standing_ind :=
375: NVL(p_scah_rec.advanced_standing_ind,
376: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADVANCED_STANDING_IND',
377: p_scah_rec.person_id,
378: p_scah_rec.course_cd,
379: p_scah_rec.hist_end_dt),
380: p_sca_rec.advanced_standing_ind));

Line 381: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL30');

377: p_scah_rec.person_id,
378: p_scah_rec.course_cd,
379: p_scah_rec.hist_end_dt),
380: p_sca_rec.advanced_standing_ind));
381: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL30');
382: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL31');
383: gr_scaeh.r_scah.fee_cat :=
384: NVL(p_scah_rec.fee_cat,
385: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('FEE_CAT',

Line 382: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL31');

378: p_scah_rec.course_cd,
379: p_scah_rec.hist_end_dt),
380: p_sca_rec.advanced_standing_ind));
381: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL30');
382: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL31');
383: gr_scaeh.r_scah.fee_cat :=
384: NVL(p_scah_rec.fee_cat,
385: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('FEE_CAT',
386: p_scah_rec.person_id,

Line 385: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('FEE_CAT',

381: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL30');
382: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL31');
383: gr_scaeh.r_scah.fee_cat :=
384: NVL(p_scah_rec.fee_cat,
385: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('FEE_CAT',
386: p_scah_rec.person_id,
387: p_scah_rec.course_cd,
388: p_scah_rec.hist_end_dt),
389: p_sca_rec.fee_cat));

Line 390: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL31');

386: p_scah_rec.person_id,
387: p_scah_rec.course_cd,
388: p_scah_rec.hist_end_dt),
389: p_sca_rec.fee_cat));
390: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL31');
391: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL32');
392: gr_scaeh.r_scah.correspondence_cat:=
393: NVL(p_scah_rec.correspondence_cat,
394: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('CORRESPONDENCE_CAT',

Line 391: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL32');

387: p_scah_rec.course_cd,
388: p_scah_rec.hist_end_dt),
389: p_sca_rec.fee_cat));
390: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL31');
391: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL32');
392: gr_scaeh.r_scah.correspondence_cat:=
393: NVL(p_scah_rec.correspondence_cat,
394: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('CORRESPONDENCE_CAT',
395: p_scah_rec.person_id,

Line 394: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('CORRESPONDENCE_CAT',

390: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL31');
391: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL32');
392: gr_scaeh.r_scah.correspondence_cat:=
393: NVL(p_scah_rec.correspondence_cat,
394: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('CORRESPONDENCE_CAT',
395: p_scah_rec.person_id,
396: p_scah_rec.course_cd,
397: p_scah_rec.hist_end_dt),
398: p_sca_rec.correspondence_cat));

Line 399: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL33');

395: p_scah_rec.person_id,
396: p_scah_rec.course_cd,
397: p_scah_rec.hist_end_dt),
398: p_sca_rec.correspondence_cat));
399: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL33');
400: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL34');
401: --gr_scaeh.r_scah.cc_description :=
402: gr_scaeh.r_scah.self_help_group_ind :=
403: NVL(p_scah_rec.self_help_group_ind,

Line 400: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL34');

396: p_scah_rec.course_cd,
397: p_scah_rec.hist_end_dt),
398: p_sca_rec.correspondence_cat));
399: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL33');
400: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL34');
401: --gr_scaeh.r_scah.cc_description :=
402: gr_scaeh.r_scah.self_help_group_ind :=
403: NVL(p_scah_rec.self_help_group_ind,
404: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('SELF_HELP_GROUP_IND',

Line 404: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('SELF_HELP_GROUP_IND',

400: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL34');
401: --gr_scaeh.r_scah.cc_description :=
402: gr_scaeh.r_scah.self_help_group_ind :=
403: NVL(p_scah_rec.self_help_group_ind,
404: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('SELF_HELP_GROUP_IND',
405: p_scah_rec.person_id,
406: p_scah_rec.course_cd,
407: p_scah_rec.hist_end_dt),
408: p_sca_rec.self_help_group_ind));

Line 409: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL34');

405: p_scah_rec.person_id,
406: p_scah_rec.course_cd,
407: p_scah_rec.hist_end_dt),
408: p_sca_rec.self_help_group_ind));
409: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL34');
410: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL35');
411: gr_scaeh.r_scah.adm_admission_appl_number :=
412: NVL(p_scah_rec.adm_admission_appl_number,
413: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_ADMISSION_APPL_NUMBER',

Line 410: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL35');

406: p_scah_rec.course_cd,
407: p_scah_rec.hist_end_dt),
408: p_sca_rec.self_help_group_ind));
409: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL34');
410: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL35');
411: gr_scaeh.r_scah.adm_admission_appl_number :=
412: NVL(p_scah_rec.adm_admission_appl_number,
413: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_ADMISSION_APPL_NUMBER',
414: p_scah_rec.person_id,

Line 413: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_ADMISSION_APPL_NUMBER',

409: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL34');
410: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL35');
411: gr_scaeh.r_scah.adm_admission_appl_number :=
412: NVL(p_scah_rec.adm_admission_appl_number,
413: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_ADMISSION_APPL_NUMBER',
414: p_scah_rec.person_id,
415: p_scah_rec.course_cd,
416: p_scah_rec.hist_end_dt)),
417: p_sca_rec.adm_admission_appl_number));

Line 418: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL35');

414: p_scah_rec.person_id,
415: p_scah_rec.course_cd,
416: p_scah_rec.hist_end_dt)),
417: p_sca_rec.adm_admission_appl_number));
418: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL35');
419: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL36');
420: gr_scaeh.r_scah.adm_nominated_course_cd :=
421: NVL(p_scah_rec.adm_nominated_course_cd,
422: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_NOMINATED_COURSE_CD',

Line 419: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL36');

415: p_scah_rec.course_cd,
416: p_scah_rec.hist_end_dt)),
417: p_sca_rec.adm_admission_appl_number));
418: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL35');
419: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL36');
420: gr_scaeh.r_scah.adm_nominated_course_cd :=
421: NVL(p_scah_rec.adm_nominated_course_cd,
422: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_NOMINATED_COURSE_CD',
423: p_scah_rec.person_id,

Line 422: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_NOMINATED_COURSE_CD',

418: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL35');
419: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL36');
420: gr_scaeh.r_scah.adm_nominated_course_cd :=
421: NVL(p_scah_rec.adm_nominated_course_cd,
422: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_NOMINATED_COURSE_CD',
423: p_scah_rec.person_id,
424: p_scah_rec.course_cd,
425: p_scah_rec.hist_end_dt),
426: p_sca_rec.adm_nominated_course_cd));

Line 427: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL36');

423: p_scah_rec.person_id,
424: p_scah_rec.course_cd,
425: p_scah_rec.hist_end_dt),
426: p_sca_rec.adm_nominated_course_cd));
427: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL36');
428: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL37');
429: gr_scaeh.r_scah.adm_sequence_number :=
430: NVL(p_scah_rec.adm_sequence_number,
431: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_SEQUENCE_NUMBER',

Line 428: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL37');

424: p_scah_rec.course_cd,
425: p_scah_rec.hist_end_dt),
426: p_sca_rec.adm_nominated_course_cd));
427: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL36');
428: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL37');
429: gr_scaeh.r_scah.adm_sequence_number :=
430: NVL(p_scah_rec.adm_sequence_number,
431: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_SEQUENCE_NUMBER',
432: p_scah_rec.person_id,

Line 431: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_SEQUENCE_NUMBER',

427: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL36');
428: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL37');
429: gr_scaeh.r_scah.adm_sequence_number :=
430: NVL(p_scah_rec.adm_sequence_number,
431: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_SEQUENCE_NUMBER',
432: p_scah_rec.person_id,
433: p_scah_rec.course_cd,
434: p_scah_rec.hist_end_dt)),
435: p_sca_rec.adm_sequence_number));

Line 436: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL37');

432: p_scah_rec.person_id,
433: p_scah_rec.course_cd,
434: p_scah_rec.hist_end_dt)),
435: p_sca_rec.adm_sequence_number));
436: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL37');
437: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL38');
438: gr_scaeh.r_scah.LAST_UPDATED_BY := p_scah_rec.LAST_UPDATED_BY;
439: gr_scaeh.r_scah.LAST_UPDATE_DATE := p_scah_rec.LAST_UPDATE_DATE;
440: p_data_found := TRUE;

Line 437: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL38');

433: p_scah_rec.course_cd,
434: p_scah_rec.hist_end_dt)),
435: p_sca_rec.adm_sequence_number));
436: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL37');
437: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL38');
438: gr_scaeh.r_scah.LAST_UPDATED_BY := p_scah_rec.LAST_UPDATED_BY;
439: gr_scaeh.r_scah.LAST_UPDATE_DATE := p_scah_rec.LAST_UPDATE_DATE;
440: p_data_found := TRUE;
441: p_scaeh_dtl := gr_scaeh.r_scah;

Line 723: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL');

719: FETCH c_scah INTO r_scah;
720: IF (c_scah%FOUND) THEN
721: v_scah_found := TRUE;
722: IF r_scah.course_attempt_status IS NULL THEN
723: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL');
724: r_scah.course_attempt_status :=
725: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_ATTEMPT_STATUS',
726: r_scah.person_id,
727: r_scah.course_cd,

Line 725: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_ATTEMPT_STATUS',

721: v_scah_found := TRUE;
722: IF r_scah.course_attempt_status IS NULL THEN
723: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('before IGS_AU_GEN_003.AUDP_GET_SCAH_COL');
724: r_scah.course_attempt_status :=
725: NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_ATTEMPT_STATUS',
726: r_scah.person_id,
727: r_scah.course_cd,
728: r_scah.hist_end_dt),
729: r_sca.course_attempt_status);

Line 730: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL');

726: r_scah.person_id,
727: r_scah.course_cd,
728: r_scah.hist_end_dt),
729: r_sca.course_attempt_status);
730: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('after IGS_AU_GEN_003.AUDP_GET_SCAH_COL');
731: END IF;
732: ELSE
733: v_scah_found := FALSE;
734: END IF;