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_SUAEH dependencies on IGS_AU_GEN_003

Line 5: -- knaraset 29-Apr-03 Modified calls to IGS_AU_GEN_003.AUDP_GET_SUAH_COL to add uoo_id, as part of MUS build bug 2829262

1: PACKAGE BODY IGS_FI_GET_SUAEH AS
2: /* $Header: IGSFI07B.pls 115.9 2003/05/23 06:53:57 knaraset ship $ */
3: -- Routine to save SUA effective history data in a PL/SQL TABLE.
4: -- Who When What
5: -- knaraset 29-Apr-03 Modified calls to IGS_AU_GEN_003.AUDP_GET_SUAH_COL to add uoo_id, as part of MUS build bug 2829262
6: --
7:
8: PROCEDURE FINP_GET_SUAEH(
9: p_person_id IN NUMBER ,

Line 161: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('LOCATION_CD',

157: v_suah_rec.hist_end_dt := p_suah_rec.hist_end_dt;
158: v_suah_rec.hist_who := p_suah_rec.hist_who;
159: v_suah_rec.location_cd :=
160: NVL(p_suah_rec.location_cd,
161: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('LOCATION_CD',
162: p_suah_rec.person_id,
163: p_suah_rec.course_cd,
164: p_suah_rec.hist_end_dt,
165: p_suah_rec.uoo_id),

Line 169: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('UNIT_CLASS',

165: p_suah_rec.uoo_id),
166: p_sua_rec.location_cd));
167: v_suah_rec.unit_class :=
168: NVL(p_suah_rec.unit_class ,
169: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('UNIT_CLASS',
170: p_suah_rec.person_id,
171: p_suah_rec.course_cd,
172: p_suah_rec.hist_end_dt,
173: p_suah_rec.uoo_id),

Line 177: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ENROLLED_DT',

173: p_suah_rec.uoo_id),
174: p_sua_rec.unit_class ));
175: v_suah_rec.enrolled_dt :=
176: NVL(p_suah_rec.enrolled_dt,
177: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ENROLLED_DT',
178: p_suah_rec.person_id,
179: p_suah_rec.course_cd,
180: p_suah_rec.hist_end_dt,
181: p_suah_rec.uoo_id)),

Line 185: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('UNIT_ATTEMPT_STATUS',

181: p_suah_rec.uoo_id)),
182: p_sua_rec.enrolled_dt));
183: v_suah_rec.unit_attempt_status :=
184: NVL(p_suah_rec.unit_attempt_status,
185: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('UNIT_ATTEMPT_STATUS',
186: p_suah_rec.person_id,
187: p_suah_rec.course_cd,
188: p_suah_rec.hist_end_dt,
189: p_suah_rec.uoo_id),

Line 193: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ADMINISTRATIVE_UNIT_STATUS',

189: p_suah_rec.uoo_id),
190: p_sua_rec.unit_attempt_status));
191: v_suah_rec.administrative_unit_status :=
192: NVL(p_suah_rec.administrative_unit_status,
193: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ADMINISTRATIVE_UNIT_STATUS',
194: p_suah_rec.person_id,
195: p_suah_rec.course_cd,
196: p_suah_rec.hist_end_dt,
197: p_suah_rec.uoo_id),

Line 201: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('DISCONTINUED_DT',

197: p_suah_rec.uoo_id),
198: p_sua_rec.administrative_unit_status));
199: v_suah_rec.discontinued_dt :=
200: NVL(p_suah_rec.discontinued_dt,
201: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('DISCONTINUED_DT',
202: p_suah_rec.person_id,
203: p_suah_rec.course_cd,
204: p_suah_rec.hist_end_dt,
205: p_suah_rec.uoo_id)),

Line 209: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('RULE_WAIVED_DT',

205: p_suah_rec.uoo_id)),
206: p_sua_rec.discontinued_dt));
207: v_suah_rec.rule_waived_dt :=
208: NVL(p_suah_rec.rule_waived_dt,
209: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('RULE_WAIVED_DT',
210: p_suah_rec.person_id,
211: p_suah_rec.course_cd,
212: p_suah_rec.hist_end_dt,
213: p_suah_rec.uoo_id)),

Line 217: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('RULE_WAIVED_PERSON_ID',

213: p_suah_rec.uoo_id)),
214: p_sua_rec.rule_waived_dt));
215: v_suah_rec.rule_waived_person_id :=
216: NVL(p_suah_rec.rule_waived_person_id,
217: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('RULE_WAIVED_PERSON_ID',
218: p_suah_rec.person_id,
219: p_suah_rec.course_cd,
220: p_suah_rec.hist_end_dt,
221: p_suah_rec.uoo_id)),

Line 225: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('NO_ASSESSMENT_IND',

221: p_suah_rec.uoo_id)),
222: p_sua_rec.rule_waived_person_id));
223: v_suah_rec.no_assessment_ind :=
224: NVL(p_suah_rec.no_assessment_ind,
225: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('NO_ASSESSMENT_IND',
226: p_suah_rec.person_id,
227: p_suah_rec.course_cd,
228: p_suah_rec.hist_end_dt,
229: p_suah_rec.uoo_id),

Line 233: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('EXAM_LOCATION_CD',

229: p_suah_rec.uoo_id),
230: p_sua_rec.no_assessment_ind));
231: v_suah_rec.exam_location_cd :=
232: NVL(p_suah_rec.exam_location_cd,
233: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('EXAM_LOCATION_CD',
234: p_suah_rec.person_id,
235: p_suah_rec.course_cd,
236: p_suah_rec.hist_end_dt,
237: p_suah_rec.uoo_id),

Line 241: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('SUP_UNIT_CD',

237: p_suah_rec.uoo_id),
238: p_sua_rec.exam_location_cd));
239: v_suah_rec.sup_unit_cd :=
240: NVL(p_suah_rec.sup_unit_cd,
241: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('SUP_UNIT_CD',
242: p_suah_rec.person_id,
243: p_suah_rec.course_cd,
244: p_suah_rec.hist_end_dt,
245: p_suah_rec.uoo_id),

Line 249: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('SUP_VERSION_NUMBER',

245: p_suah_rec.uoo_id),
246: p_sua_rec.sup_unit_cd));
247: v_suah_rec.sup_version_number :=
248: NVL(p_suah_rec.sup_version_number,
249: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('SUP_VERSION_NUMBER',
250: p_suah_rec.person_id,
251: p_suah_rec.course_cd,
252: p_suah_rec.hist_end_dt,
253: p_suah_rec.uoo_id)),

Line 257: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ALTERNATIVE_TITLE',

253: p_suah_rec.uoo_id)),
254: p_sua_rec.sup_version_number));
255: v_suah_rec.alternative_title :=
256: NVL(p_suah_rec.alternative_title,
257: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ALTERNATIVE_TITLE',
258: p_suah_rec.person_id,
259: p_suah_rec.course_cd,
260: p_suah_rec.hist_end_dt,
261: p_suah_rec.uoo_id),

Line 265: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_ENROLLED_CP',

261: p_suah_rec.uoo_id),
262: p_sua_rec.alternative_title));
263: v_suah_rec.override_enrolled_cp :=
264: NVL(p_suah_rec.override_enrolled_cp,
265: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_ENROLLED_CP',
266: p_suah_rec.person_id,
267: p_suah_rec.course_cd,
268: p_suah_rec.hist_end_dt,
269: p_suah_rec.uoo_id)),

Line 273: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_EFTSU',

269: p_suah_rec.uoo_id)),
270: p_sua_rec.override_enrolled_cp));
271: v_suah_rec.override_eftsu :=
272: NVL(p_suah_rec.override_eftsu,
273: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_EFTSU',
274: p_suah_rec.person_id,
275: p_suah_rec.course_cd,
276: p_suah_rec.hist_end_dt,
277: p_suah_rec.uoo_id)),

Line 281: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_ACHIEVABLE_CP',

277: p_suah_rec.uoo_id)),
278: p_sua_rec.override_eftsu));
279: v_suah_rec.override_achievable_cp :=
280: NVL(p_suah_rec.override_achievable_cp,
281: NVL(TO_NUMBER(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_ACHIEVABLE_CP',
282: p_suah_rec.person_id,
283: p_suah_rec.course_cd,
284: p_suah_rec.hist_end_dt,
285: p_suah_rec.uoo_id)),

Line 289: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_OUTCOME_DUE_DT',

285: p_suah_rec.uoo_id)),
286: p_sua_rec.override_achievable_cp));
287: v_suah_rec.override_outcome_due_dt :=
288: NVL(p_suah_rec.override_outcome_due_dt,
289: NVL(igs_ge_date.igsdate(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_OUTCOME_DUE_DT',
290: p_suah_rec.person_id,
291: p_suah_rec.course_cd,
292: p_suah_rec.hist_end_dt,
293: p_suah_rec.uoo_id)),

Line 299: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_CREDIT_REASON',

295: v_suah_rec.LAST_UPDATED_BY := p_suah_rec.LAST_UPDATED_BY;
296: v_suah_rec.LAST_UPDATE_DATE := p_suah_rec.LAST_UPDATE_DATE;
297: v_suah_rec.override_credit_reason :=
298: NVL(p_suah_rec.override_credit_reason,
299: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_CREDIT_REASON',
300: p_suah_rec.person_id,
301: p_suah_rec.course_cd,
302: p_suah_rec.hist_end_dt,
303: p_suah_rec.uoo_id),

Line 574: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('UNIT_ATTEMPT_STATUS',

570: IF (c_suah%FOUND) THEN
571: v_suah_found := TRUE;
572: IF r_suah.unit_attempt_status IS NULL THEN
573: r_suah.unit_attempt_status :=
574: NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('UNIT_ATTEMPT_STATUS',
575: r_suah.person_id,
576: r_suah.course_cd,
577: r_suah.hist_end_dt,
578: r_suah.uoo_id),