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_EN_STDNTPSHECSOP_PKG dependencies on IGS_EN_VAL_SCHO

Line 6: --smadathi 28-AUG-2001 Bug No. 1956374 .The call to igs_en_val_scho.genp_val_strt_end_dt

2: /* $Header: IGSEI17B.pls 115.4 2002/11/28 23:35:22 nsidana ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --smadathi 28-AUG-2001 Bug No. 1956374 .The call to igs_en_val_scho.genp_val_strt_end_dt
7: -- is changed to igs_ad_val_edtl.genp_val_strt_end_dt
8: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_en_val_scho.genp_val_sdtt_sess
9: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
10: -------------------------------------------------------------------------------------------

Line 8: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_en_val_scho.genp_val_sdtt_sess

4: --Change History:
5: --Who When What
6: --smadathi 28-AUG-2001 Bug No. 1956374 .The call to igs_en_val_scho.genp_val_strt_end_dt
7: -- is changed to igs_ad_val_edtl.genp_val_strt_end_dt
8: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_en_val_scho.genp_val_sdtt_sess
9: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
10: -------------------------------------------------------------------------------------------
11: l_rowid VARCHAR2(25);
12: old_references IGS_EN_STDNTPSHECSOP%RowType;

Line 125: IF IGS_EN_VAL_SCHO.enrp_val_scho_insert (

121: -- If trigger has not been disabled, perform required processing
122: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNTPSHECSOP') THEN
123: IF p_inserting THEN
124: -- Validate if the insert is allowed.
125: IF IGS_EN_VAL_SCHO.enrp_val_scho_insert (
126: new_references.person_id,
127: new_references.course_cd,
128: v_message_name) = FALSE THEN
129: fnd_message.set_name('IGS',v_message_name);

Line 139: IF IGS_EN_VAL_SCHO.enrp_val_scho_trgdel (

135: v_return_val := IGS_GE_GEN_003.GENP_INS_STDNT_TODO(new_references.person_id, 'FEE_RECALC', NULL,'Y');
136: END IF;
137: IF p_deleting THEN
138: -- Validate if the delete is allowed.
139: IF IGS_EN_VAL_SCHO.enrp_val_scho_trgdel (
140: old_references.person_id,
141: old_references.course_cd,
142: old_references.start_dt,
143: v_message_name) = FALSE THEN

Line 161: IF IGS_EN_VAL_SCHO.enrp_val_scho_update (

157: (NVL(old_references.nz_citizen_less2yr_ind, 'NULL') <>
158: NVL(new_references.nz_citizen_less2yr_ind, 'NULL') ) OR
159: (NVL(old_references.nz_citizen_not_res_ind, 'NULL') <>
160: NVL(new_references.nz_citizen_not_res_ind, 'NULL') ) THEN
161: IF IGS_EN_VAL_SCHO.enrp_val_scho_update (
162: old_references.start_dt,
163: v_message_name) = FALSE THEN
164: fnd_message.set_name('IGS',v_message_name);
165: IGS_GE_MSG_STACK.ADD;

Line 196: IF IGS_EN_VAL_SCHO.enrp_val_scho_expire (

192: NVL(new_references.hecs_payment_option, 'NULL')) OR
193: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
194: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
195: new_references.end_dt >= TRUNC(SYSDATE)) THEN
196: IF IGS_EN_VAL_SCHO.enrp_val_scho_expire (
197: new_references.person_id,
198: new_references.course_cd,
199: new_references.start_dt,
200: new_references.end_dt,

Line 211: IF IGS_EN_VAL_SCHO.enrp_val_hpo_closed (

207: END IF;
208: -- Validate HECS PAYMENT OPTION closed indicator.
209: IF NVL(old_references.hecs_payment_option, 'NULL') <>
210: NVL(new_references.hecs_payment_option, 'NULL') THEN
211: IF IGS_EN_VAL_SCHO.enrp_val_hpo_closed (
212: new_references.hecs_payment_option,
213: v_message_name) = FALSE THEN
214: fnd_message.set_name('IGS',v_message_name);
215: IGS_GE_MSG_STACK.ADD;

Line 220: IF IGS_EN_VAL_SCHO.enrp_val_tfn_invalid (

216: app_exception.raise_exception;
217: END IF;
218: END IF;
219: -- Validate TAX FILE NUMBER INVALID DATE.
220: IF IGS_EN_VAL_SCHO.enrp_val_tfn_invalid (
221: new_references.tax_file_number,
222: new_references.tax_file_invalid_dt,
223: v_message_name) = FALSE THEN
224: fnd_message.set_name('IGS',v_message_name);

Line 229: IF IGS_EN_VAL_SCHO.enrp_val_tfn_crtfct (

225: IGS_GE_MSG_STACK.ADD;
226: app_exception.raise_exception;
227: END IF;
228: -- Validate TAX FILE NUMBER CERTIFICATE NUMBER.
229: IF IGS_EN_VAL_SCHO.enrp_val_tfn_crtfct (
230: new_references.tax_file_number,
231: new_references.tax_file_invalid_dt,
232: new_references.tax_file_certificate_number,
233: v_message_name) = FALSE THEN

Line 247: IF IGS_EN_VAL_SCHO.enrp_val_scho_visa (

243: (NVL(old_references.nz_citizen_less2yr_ind, 'NULL') <>
244: NVL(new_references.nz_citizen_less2yr_ind, 'NULL')) OR
245: (NVL(old_references.nz_citizen_not_res_ind, 'NULL') <>
246: NVL(new_references.nz_citizen_not_res_ind, 'NULL')) THEN
247: IF IGS_EN_VAL_SCHO.enrp_val_scho_visa (
248: new_references.outside_aus_res_ind,
249: new_references.nz_citizen_ind,
250: new_references.nz_citizen_less2yr_ind,
251: new_references.nz_citizen_not_res_ind,

Line 264: IF IGS_EN_VAL_SCHO.enrp_val_hpo_crs_typ (

260: -- Validate the student IGS_PS_COURSE attempt HECS option HECS payment option,
261: -- and the IGS_PS_COURSE type of the IGS_PS_COURSE version for the student IGS_PS_COURSE attempt.
262: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
263: NVL(new_references.hecs_payment_option, 'NULL')) THEN
264: IF IGS_EN_VAL_SCHO.enrp_val_hpo_crs_typ (
265: new_references.person_id,
266: new_references.course_cd,
267: new_references.hecs_payment_option,
268: v_message_name,

Line 282: IF IGS_EN_VAL_SCHO.enrp_val_hpo_spc_crs (

278: -- and the special IGS_PS_COURSE type of the IGS_PS_COURSE version for the student IGS_PS_COURSE
279: -- attempt.
280: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
281: NVL(new_references.hecs_payment_option, 'NULL')) THEN
282: IF IGS_EN_VAL_SCHO.enrp_val_hpo_spc_crs (
283: new_references.person_id,
284: new_references.course_cd,
285: new_references.hecs_payment_option,
286: v_message_name,

Line 304: IF IGS_EN_VAL_SCHO.enrp_val_hpo_crs_cic (

300: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
301: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
302: (new_references.end_dt >= TRUNC(SYSDATE) OR
303: new_references.end_dt IS NULL)) THEN
304: IF IGS_EN_VAL_SCHO.enrp_val_hpo_crs_cic (
305: new_references.person_id,
306: new_references.course_cd,
307: new_references.start_dt,
308: new_references.end_dt,

Line 330: IF IGS_EN_VAL_SCHO.enrp_val_hpo_cic (

326: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
327: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
328: (new_references.end_dt >= TRUNC(SYSDATE) OR
329: new_references.end_dt IS NULL)) THEN
330: IF IGS_EN_VAL_SCHO.enrp_val_hpo_cic (
331: new_references.person_id,
332: new_references.course_cd,
333: new_references.start_dt,
334: new_references.end_dt,

Line 356: IF IGS_EN_VAL_SCHO.enrp_val_hpo_cic_prc (

352: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
353: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
354: (new_references.end_dt >= TRUNC(SYSDATE) OR
355: new_references.end_dt IS NULL)) THEN
356: IF IGS_EN_VAL_SCHO.enrp_val_hpo_cic_prc (
357: new_references.person_id,
358: new_references.course_cd,
359: new_references.start_dt,
360: new_references.end_dt,

Line 389: IF IGS_EN_VAL_SCHO.enrp_val_vis_cic_prc (

385: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
386: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
387: (new_references.end_dt >= TRUNC(SYSDATE) OR
388: new_references.end_dt IS NULL)) THEN
389: IF IGS_EN_VAL_SCHO.enrp_val_vis_cic_prc (
390: new_references.person_id,
391: new_references.course_cd,
392: new_references.start_dt,
393: new_references.end_dt,

Line 422: IF IGS_EN_VAL_SCHO.enrp_val_ho_cic_prc (

418: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
419: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
420: (new_references.end_dt >= TRUNC(SYSDATE) OR
421: new_references.end_dt IS NULL)) THEN
422: IF IGS_EN_VAL_SCHO.enrp_val_ho_cic_prc (
423: new_references.person_id,
424: new_references.course_cd,
425: new_references.start_dt,
426: new_references.end_dt,

Line 459: IF IGS_EN_VAL_SCHO.enrp_val_hpo_vis_cic (

455: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
456: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
457: (new_references.end_dt >= TRUNC(SYSDATE) OR
458: new_references.end_dt IS NULL)) THEN
459: IF IGS_EN_VAL_SCHO.enrp_val_hpo_vis_cic (
460: new_references.person_id,
461: new_references.course_cd,
462: new_references.start_dt,
463: new_references.end_dt,

Line 491: IF IGS_EN_VAL_SCHO.enrp_val_hpo_cic_ps (

487: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
488: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
489: (new_references.end_dt >= TRUNC(SYSDATE) OR
490: new_references.end_dt IS NULL)) THEN
491: IF IGS_EN_VAL_SCHO.enrp_val_hpo_cic_ps (
492: new_references.person_id,
493: new_references.course_cd,
494: new_references.start_dt,
495: new_references.end_dt,

Line 591: IF IGS_EN_VAL_SCHO.enrp_val_scho_open (

587: -- If trigger has not been disabled, perform required processing
588: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNTPSHECSOP') THEN
589: -- Validate for open ended IGS_EN_STDNTPSHECSOP records.
590: IF New_References.end_dt IS NULL THEN
591: IF IGS_EN_VAL_SCHO.enrp_val_scho_open (
592: New_References.person_id,
593: New_References.course_cd,
594: New_References.start_dt,
595: v_message_name) = FALSE THEN

Line 602: IF IGS_EN_VAL_SCHO.enrp_val_scho_ovrlp (

598: app_exception.raise_exception;
599: END IF;
600: END IF;
601: -- Validate IGS_EN_STDNTPSHECSOP date overlaps.
602: IF IGS_EN_VAL_SCHO.enrp_val_scho_ovrlp (
603: New_References.person_id,
604: New_References.course_cd,
605: New_References.start_dt,
606: New_References.end_dt,

Line 613: IF IGS_EN_VAL_SCHO.enrp_val_scho_tfn(

609: IGS_GE_MSG_STACK.ADD;
610: app_exception.raise_exception;
611: END IF;
612: -- Validate TAX FILE NUMBER.
613: IF IGS_EN_VAL_SCHO.enrp_val_scho_tfn(
614: New_References.person_id,
615: New_References.course_cd,
616: New_References.start_dt,
617: New_References.tax_file_number,

Line 627: IF IGS_EN_VAL_SCHO.enrp_val_scho_hpo (

623: app_exception.raise_exception;
624: END IF;
625: END IF;
626: -- Validate HECS PAYMENT OPTION and other fields.
627: IF IGS_EN_VAL_SCHO.enrp_val_scho_hpo (
628: New_References.hecs_payment_option,
629: New_References.outside_aus_res_ind,
630: New_References.nz_citizen_ind,
631: New_References.nz_citizen_less2yr_ind,