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_GE_DATE

Line 179: NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

175: -- Because start date is part of the key it will be set and is not
176: -- updateable, so only need to check the end date is not null.
177: IF new_references.end_dt IS NOT NULL AND
178: (p_inserting OR
179: NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
180: new_references.end_dt) THEN
181: IF igs_ad_val_edtl.genp_val_strt_end_dt (
182: new_references.start_dt,
183: new_references.end_dt,

Line 193: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

189: END IF;
190: -- Validate END DATE.
191: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
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,

Line 194: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND

190: -- Validate END DATE.
191: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
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,

Line 300: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

296: -- the IGS_PS_COURSE type of the IGS_PS_COURSE version for the student IGS_PS_COURSE attempt,
297: -- and the IGS_PE_PERSON statistics citizenship code.
298: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
299: NVL(new_references.hecs_payment_option, 'NULL')) OR
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 (

Line 301: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND

297: -- and the IGS_PE_PERSON statistics citizenship code.
298: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
299: NVL(new_references.hecs_payment_option, 'NULL')) OR
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,

Line 326: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

322: -- Validate the student IGS_PS_COURSE attempt HECS option HECS payment option,
323: -- and the IGS_PE_PERSON statistics citizenship code.
324: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
325: NVL(new_references.hecs_payment_option, 'NULL')) OR
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 (

Line 327: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND

323: -- and the IGS_PE_PERSON statistics citizenship code.
324: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
325: NVL(new_references.hecs_payment_option, 'NULL')) OR
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,

Line 352: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

348: -- Validate the student IGS_PS_COURSE attempt HECS option HECS payment option,
349: -- and the IGS_PE_PERSON statistics citizenship code and permanent resident code.
350: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
351: NVL(new_references.hecs_payment_option, 'NULL')) OR
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 (

Line 353: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND

349: -- and the IGS_PE_PERSON statistics citizenship code and permanent resident code.
350: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
351: NVL(new_references.hecs_payment_option, 'NULL')) OR
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,

Line 385: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

381: (NVL(old_references.nz_citizen_less2yr_ind, 'NULL') <>
382: NVL(new_references.nz_citizen_less2yr_ind, 'NULL')) OR
383: (NVL(old_references.nz_citizen_not_res_ind, 'NULL') <>
384: NVL(new_references.nz_citizen_not_res_ind, 'NULL')) OR
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 (

Line 386: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND

382: NVL(new_references.nz_citizen_less2yr_ind, 'NULL')) OR
383: (NVL(old_references.nz_citizen_not_res_ind, 'NULL') <>
384: NVL(new_references.nz_citizen_not_res_ind, 'NULL')) OR
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,

Line 418: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

414: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
415: NVL(new_references.hecs_payment_option, 'NULL')) OR
416: (NVL(old_references.outside_aus_res_ind, 'NULL') <>
417: NVL(new_references.outside_aus_res_ind, 'NULL')) OR
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 (

Line 419: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND

415: NVL(new_references.hecs_payment_option, 'NULL')) OR
416: (NVL(old_references.outside_aus_res_ind, 'NULL') <>
417: NVL(new_references.outside_aus_res_ind, 'NULL')) OR
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,

Line 455: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

451: (NVL(old_references.nz_citizen_less2yr_ind, 'NULL') <>
452: NVL(new_references.nz_citizen_less2yr_ind, 'NULL')) OR
453: (NVL(old_references.nz_citizen_not_res_ind, 'NULL') <>
454: NVL(new_references.nz_citizen_not_res_ind, 'NULL')) OR
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 (

Line 456: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND

452: NVL(new_references.nz_citizen_less2yr_ind, 'NULL')) OR
453: (NVL(old_references.nz_citizen_not_res_ind, 'NULL') <>
454: NVL(new_references.nz_citizen_not_res_ind, 'NULL')) OR
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,

Line 487: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

483: -- and the IGS_PE_PERSON statistics citizenship code and other IGS_PE_PERSON statistics
484: -- values including year of arrival and term IGS_AD_LOCATION country and postcode.
485: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
486: NVL(new_references.hecs_payment_option, 'NULL')) OR
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 (

Line 488: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND

484: -- values including year of arrival and term IGS_AD_LOCATION country and postcode.
485: IF (NVL(old_references.hecs_payment_option, 'NULL') <>
486: NVL(new_references.hecs_payment_option, 'NULL')) OR
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,

Line 541: IF p_inserting OR (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

537: IF new_references.end_dt IS NULL THEN
538: v_rowid_saved := TRUE;
539: END IF;
540: -- Validate for date overlaps.
541: IF p_inserting OR (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
542: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
543: IF v_rowid_saved = FALSE THEN
544: v_rowid_saved := TRUE;
545: END IF;

Line 542: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

538: v_rowid_saved := TRUE;
539: END IF;
540: -- Validate for date overlaps.
541: IF p_inserting OR (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
542: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
543: IF v_rowid_saved = FALSE THEN
544: v_rowid_saved := TRUE;
545: END IF;
546: END IF;

Line 569: IGS_GE_DATE.IGSDATE('1900/01/01')) <>

565: (NVL(old_references.safety_net_ind, 'NULL') <>
566: NVL(new_references.safety_net_ind, 'NULL')) OR
567: (NVL(old_references.tax_file_number,0) <> NVL(new_references.tax_file_number,0)) OR
568: (NVL(old_references.tax_file_number_collected_dt,
569: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
570: NVL(new_references.tax_file_number_collected_dt,
571: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
572: (NVL(old_references.tax_file_certificate_number,0) <>
573: NVL(new_references.tax_file_certificate_number,0)) THEN

Line 571: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR

567: (NVL(old_references.tax_file_number,0) <> NVL(new_references.tax_file_number,0)) OR
568: (NVL(old_references.tax_file_number_collected_dt,
569: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
570: NVL(new_references.tax_file_number_collected_dt,
571: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
572: (NVL(old_references.tax_file_certificate_number,0) <>
573: NVL(new_references.tax_file_certificate_number,0)) THEN
574: IF v_rowid_saved = FALSE THEN
575: v_rowid_saved := TRUE;