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_PR_VAL_SPO dependencies on IGS_GE_DATE

Line 286: TRUNC(NVL(p_expiry_dt, igs_ge_date.igsdate('9999/01/01'))) <=

282: END IF;
283: IF p_old_decision_status = cst_approved AND
284: p_new_decision_status IN ( cst_removed,
285: cst_cancelled) AND
286: TRUNC(NVL(p_expiry_dt, igs_ge_date.igsdate('9999/01/01'))) <=
287: TRUNC(SYSDATE) THEN
288: p_message_name := 'IGS_PR_CNTCH_DEST_APRE_EXDT_AP';
289: RETURN FALSE;
290: END IF;

Line 388: IF TRUNC(NVL(p_new_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) >

384: IF p_person_id IS NULL OR
385: p_course_cd IS NULL THEN
386: RETURN TRUE;
387: END IF;
388: IF TRUNC(NVL(p_new_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) >
389: TRUNC(SYSDATE) THEN
390: p_message_name := 'IGS_PR_SHCA_DT_CNT_FUT';
391: RETURN FALSE;
392: END IF;

Line 413: IF TRUNC(NVL(p_new_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) <>

409: p_appeal_dt IS NOT NULL THEN
410: p_message_name := 'IGS_PR_SHCDT_CNT_ST_APDT_ST';
411: RETURN FALSE;
412: END IF;
413: IF TRUNC(NVL(p_new_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) <>
414: TRUNC(NVL(p_old_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) AND
415: p_show_cause_outcome_dt IS NOT NULL AND
416: p_old_show_cause_dt IS NOT NULL THEN
417: p_message_name := 'IGS_PR_SHCA_DTCNT_AL_OUDTS';

Line 414: TRUNC(NVL(p_old_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) AND

410: p_message_name := 'IGS_PR_SHCDT_CNT_ST_APDT_ST';
411: RETURN FALSE;
412: END IF;
413: IF TRUNC(NVL(p_new_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) <>
414: TRUNC(NVL(p_old_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) AND
415: p_show_cause_outcome_dt IS NOT NULL AND
416: p_old_show_cause_dt IS NOT NULL THEN
417: p_message_name := 'IGS_PR_SHCA_DTCNT_AL_OUDTS';
418: RETURN FALSE;

Line 525: igs_ge_date.igsdate('9999/01/01'))) < TRUNC(SYSDATE) THEN

521: p_course_cd IS NULL THEN
522: RETURN TRUE;
523: END IF;
524: IF TRUNC(NVL(p_new_show_cause_expiry_dt,
525: igs_ge_date.igsdate('9999/01/01'))) < TRUNC(SYSDATE) THEN
526: p_message_name := 'IGS_PR_SHCA_EXPDT_CNTB_TODAT';
527: RETURN FALSE;
528: END IF;
529: IF p_new_show_cause_expiry_dt IS NOT NULL AND

Line 535: igs_ge_date.igsdate('0001/01/01'))) >

531: p_message_name := 'IGS_PR_SHCA_EXPDT_CNTB_DSTNA';
532: RETURN FALSE;
533: END IF;
534: IF TRUNC(NVL(p_new_show_cause_expiry_dt,
535: igs_ge_date.igsdate('0001/01/01'))) >
536: TRUNC(NVL(p_appeal_expiry_dt,
537: igs_ge_date.igsdate('9999/01/01'))) THEN
538: p_message_name := 'IGS_PR_SH_EXPDT_CNT_APEXDT';
539: RETURN FALSE;

Line 537: igs_ge_date.igsdate('9999/01/01'))) THEN

533: END IF;
534: IF TRUNC(NVL(p_new_show_cause_expiry_dt,
535: igs_ge_date.igsdate('0001/01/01'))) >
536: TRUNC(NVL(p_appeal_expiry_dt,
537: igs_ge_date.igsdate('9999/01/01'))) THEN
538: p_message_name := 'IGS_PR_SH_EXPDT_CNT_APEXDT';
539: RETURN FALSE;
540: END IF;
541: IF TRUNC(NVL(p_new_show_cause_expiry_dt,

Line 542: igs_ge_date.igsdate('0001/01/01'))) <>

538: p_message_name := 'IGS_PR_SH_EXPDT_CNT_APEXDT';
539: RETURN FALSE;
540: END IF;
541: IF TRUNC(NVL(p_new_show_cause_expiry_dt,
542: igs_ge_date.igsdate('0001/01/01'))) <>
543: TRUNC(NVL(p_old_show_cause_expiry_dt,
544: igs_ge_date.igsdate('0001/01/01'))) AND
545: p_show_cause_dt IS NOT NULL THEN
546: p_message_name := 'IGS_PR_SHEXP_CNT_AL_SCDST';

Line 544: igs_ge_date.igsdate('0001/01/01'))) AND

540: END IF;
541: IF TRUNC(NVL(p_new_show_cause_expiry_dt,
542: igs_ge_date.igsdate('0001/01/01'))) <>
543: TRUNC(NVL(p_old_show_cause_expiry_dt,
544: igs_ge_date.igsdate('0001/01/01'))) AND
545: p_show_cause_dt IS NOT NULL THEN
546: p_message_name := 'IGS_PR_SHEXP_CNT_AL_SCDST';
547: RETURN FALSE;
548: END IF;

Line 550: igs_ge_date.igsdate('0001/01/01'))) <>

546: p_message_name := 'IGS_PR_SHEXP_CNT_AL_SCDST';
547: RETURN FALSE;
548: END IF;
549: IF TRUNC(NVL(p_new_show_cause_expiry_dt,
550: igs_ge_date.igsdate('0001/01/01'))) <>
551: TRUNC(NVL(p_old_show_cause_expiry_dt,
552: igs_ge_date.igsdate('0001/01/01'))) AND
553: p_show_cause_outcome_dt IS NOT NULL THEN
554: p_message_name := 'IGS_PR_SHEXP_DTCNT_ASHOU_DTST';

Line 552: igs_ge_date.igsdate('0001/01/01'))) AND

548: END IF;
549: IF TRUNC(NVL(p_new_show_cause_expiry_dt,
550: igs_ge_date.igsdate('0001/01/01'))) <>
551: TRUNC(NVL(p_old_show_cause_expiry_dt,
552: igs_ge_date.igsdate('0001/01/01'))) AND
553: p_show_cause_outcome_dt IS NOT NULL THEN
554: p_message_name := 'IGS_PR_SHEXP_DTCNT_ASHOU_DTST';
555: RETURN FALSE;
556: END IF;

Line 583: igs_ge_date.igsdate('0001/01/01'))) >

579: OPEN c_daiv(v_show_cause_cutoff_dt);
580: FETCH c_daiv INTO v_alias_val;
581: CLOSE c_daiv;
582: IF TRUNC(NVL(p_new_show_cause_expiry_dt,
583: igs_ge_date.igsdate('0001/01/01'))) >
584: TRUNC(v_alias_val) THEN
585: p_message_name := 'IGS_PR_WA_SCA_EXDT_ASCT_DT';
586: RETURN TRUE; -- warning only
587: END IF;

Line 635: igs_ge_date.igsdate('0001/01/01'))) > TRUNC(SYSDATE) THEN

631: p_message_name := 'IGS_PR_SHCA_OTY_ODTCT_SCDT_NT';
632: RETURN FALSE;
633: END IF;
634: IF TRUNC(NVL(p_show_cause_outcome_dt,
635: igs_ge_date.igsdate('0001/01/01'))) > TRUNC(SYSDATE) THEN
636: p_message_name := 'IGS_PR_SHCA_OUDT_CNT_FUT';
637: RETURN FALSE;
638: END IF;
639: IF p_show_cause_outcome_dt IS NOT NULL AND

Line 715: IF TRUNC(NVL(p_new_appeal_dt, igs_ge_date.igsdate('0001/01/01'))) >

711: IF p_person_id IS NULL OR
712: p_course_cd IS NULL THEN
713: RETURN TRUE;
714: END IF;
715: IF TRUNC(NVL(p_new_appeal_dt, igs_ge_date.igsdate('0001/01/01'))) >
716: TRUNC(SYSDATE) THEN
717: p_message_name := 'IGS_PR_APOUT_DT_CNT_FUT';
718: RETURN FALSE;
719: END IF;

Line 730: IF TRUNC(NVL(p_new_appeal_dt, igs_ge_date.igsdate('9999/01/01'))) <

726: p_new_appeal_dt IS NOT NULL THEN
727: p_message_name := 'IGS_PR_APDT_CNT_SAPEX_DTNTS';
728: RETURN FALSE;
729: END IF;
730: IF TRUNC(NVL(p_new_appeal_dt, igs_ge_date.igsdate('9999/01/01'))) <
731: TRUNC(NVL(p_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) THEN
732: p_message_name := 'IGS_PR_APDT_CNTS_BSHDT';
733: RETURN FALSE;
734: END IF;

Line 731: TRUNC(NVL(p_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) THEN

727: p_message_name := 'IGS_PR_APDT_CNT_SAPEX_DTNTS';
728: RETURN FALSE;
729: END IF;
730: IF TRUNC(NVL(p_new_appeal_dt, igs_ge_date.igsdate('9999/01/01'))) <
731: TRUNC(NVL(p_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) THEN
732: p_message_name := 'IGS_PR_APDT_CNTS_BSHDT';
733: RETURN FALSE;
734: END IF;
735: IF TRUNC(NVL(p_new_appeal_dt, igs_ge_date.igsdate('0001/01/01'))) <>

Line 735: IF TRUNC(NVL(p_new_appeal_dt, igs_ge_date.igsdate('0001/01/01'))) <>

731: TRUNC(NVL(p_show_cause_dt, igs_ge_date.igsdate('0001/01/01'))) THEN
732: p_message_name := 'IGS_PR_APDT_CNTS_BSHDT';
733: RETURN FALSE;
734: END IF;
735: IF TRUNC(NVL(p_new_appeal_dt, igs_ge_date.igsdate('0001/01/01'))) <>
736: TRUNC(NVL(p_old_appeal_dt, igs_ge_date.igsdate('0001/01/01'))) AND
737: p_appeal_outcome_dt IS NOT NULL AND
738: p_old_appeal_dt IS NOT NULL THEN
739: p_message_name := 'IGS_PR_APDT_CNT_AL_AODT_ST';

Line 736: TRUNC(NVL(p_old_appeal_dt, igs_ge_date.igsdate('0001/01/01'))) AND

732: p_message_name := 'IGS_PR_APDT_CNTS_BSHDT';
733: RETURN FALSE;
734: END IF;
735: IF TRUNC(NVL(p_new_appeal_dt, igs_ge_date.igsdate('0001/01/01'))) <>
736: TRUNC(NVL(p_old_appeal_dt, igs_ge_date.igsdate('0001/01/01'))) AND
737: p_appeal_outcome_dt IS NOT NULL AND
738: p_old_appeal_dt IS NOT NULL THEN
739: p_message_name := 'IGS_PR_APDT_CNT_AL_AODT_ST';
740: RETURN FALSE;

Line 844: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('9999/01/01'))) <

840: IF p_person_id IS NULL OR
841: p_course_cd IS NULL THEN
842: RETURN TRUE;
843: END IF;
844: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('9999/01/01'))) <
845: TRUNC(SYSDATE) THEN
846: p_message_name := 'IGS_PR_APEXDT_CNTS_BTODT';
847: RETURN FALSE;
848: END IF;

Line 849: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('9999/01/01'))) <

845: TRUNC(SYSDATE) THEN
846: p_message_name := 'IGS_PR_APEXDT_CNTS_BTODT';
847: RETURN FALSE;
848: END IF;
849: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('9999/01/01'))) <
850: TRUNC(NVL(p_show_cause_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) THEN
851: p_message_name := 'IGS_PR_APEXDT_CNTB_SEXDT';
852: RETURN FALSE;
853: END IF;

Line 850: TRUNC(NVL(p_show_cause_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) THEN

846: p_message_name := 'IGS_PR_APEXDT_CNTS_BTODT';
847: RETURN FALSE;
848: END IF;
849: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('9999/01/01'))) <
850: TRUNC(NVL(p_show_cause_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) THEN
851: p_message_name := 'IGS_PR_APEXDT_CNTB_SEXDT';
852: RETURN FALSE;
853: END IF;
854: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) <>

Line 854: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) <>

850: TRUNC(NVL(p_show_cause_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) THEN
851: p_message_name := 'IGS_PR_APEXDT_CNTB_SEXDT';
852: RETURN FALSE;
853: END IF;
854: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) <>
855: TRUNC(NVL(p_old_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) AND
856: p_appeal_dt IS NOT NULL THEN
857: p_message_name := 'IGS_PR_APEDT_CNT_AL_APDT_HST';
858: RETURN FALSE;

Line 855: TRUNC(NVL(p_old_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) AND

851: p_message_name := 'IGS_PR_APEXDT_CNTB_SEXDT';
852: RETURN FALSE;
853: END IF;
854: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) <>
855: TRUNC(NVL(p_old_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) AND
856: p_appeal_dt IS NOT NULL THEN
857: p_message_name := 'IGS_PR_APEDT_CNT_AL_APDT_HST';
858: RETURN FALSE;
859: END IF;

Line 860: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) <>

856: p_appeal_dt IS NOT NULL THEN
857: p_message_name := 'IGS_PR_APEDT_CNT_AL_APDT_HST';
858: RETURN FALSE;
859: END IF;
860: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) <>
861: TRUNC(NVL(p_old_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) AND
862: p_appeal_outcome_dt IS NOT NULL THEN
863: p_message_name := 'IGS_PR_APEXDT_CNTAL_AODT_HST';
864: RETURN FALSE;

Line 861: TRUNC(NVL(p_old_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) AND

857: p_message_name := 'IGS_PR_APEDT_CNT_AL_APDT_HST';
858: RETURN FALSE;
859: END IF;
860: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) <>
861: TRUNC(NVL(p_old_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) AND
862: p_appeal_outcome_dt IS NOT NULL THEN
863: p_message_name := 'IGS_PR_APEXDT_CNTAL_AODT_HST';
864: RETURN FALSE;
865: END IF;

Line 896: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) >

892: v_outcome_check_type);
893: OPEN c_daiv(v_appeal_cutoff_dt);
894: FETCH c_daiv INTO v_alias_val;
895: CLOSE c_daiv;
896: IF TRUNC(NVL(p_new_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) >
897: TRUNC(v_alias_val) THEN
898: p_message_name := 'IGS_PR_WA_APEX_DTAT_APCT_DT';
899: RETURN TRUE; -- warning only
900: END IF;

Line 946: IF TRUNC(NVL(p_appeal_outcome_dt, igs_ge_date.igsdate('0001/01/01'))) >

942: p_appeal_outcome_type IS NOT NULL) THEN
943: p_message_name := 'IGS_PR_APOTY_DTCNT_APDT_NST';
944: RETURN FALSE;
945: END IF;
946: IF TRUNC(NVL(p_appeal_outcome_dt, igs_ge_date.igsdate('0001/01/01'))) >
947: TRUNC(SYSDATE) THEN
948: p_message_name := 'IGS_PR_APOUT_DT_CNT_FUT';
949: RETURN FALSE;
950: END IF;

Line 1002: TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <>

998: -- If the student progression outcome details have been changed
999: -- return the correct applied date.
1000: p_out_applied_dt := NULL;
1001: IF p_decision_status <> 'APPROVED' OR
1002: TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <>
1003: TRUNC(NVL(p_old_applied_dt, igs_ge_date.igsdate('9999/01/01'))) THEN
1004: RETURN TRUE;
1005: END IF;
1006: IF NVL(p_old_encmb_course_group_cd, 'NULL') <>

Line 1003: TRUNC(NVL(p_old_applied_dt, igs_ge_date.igsdate('9999/01/01'))) THEN

999: -- return the correct applied date.
1000: p_out_applied_dt := NULL;
1001: IF p_decision_status <> 'APPROVED' OR
1002: TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <>
1003: TRUNC(NVL(p_old_applied_dt, igs_ge_date.igsdate('9999/01/01'))) THEN
1004: RETURN TRUE;
1005: END IF;
1006: IF NVL(p_old_encmb_course_group_cd, 'NULL') <>
1007: NVL(p_new_encmb_course_group_cd, 'NULL') OR

Line 1012: TRUNC(NVL(p_old_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) <>

1008: NVL(p_old_restricted_enrolment_cp, 0) <>
1009: NVL(p_new_restricted_enrolment_cp, 0) OR
1010: NVL(p_old_restricted_attend_type, 'NULL') <>
1011: NVL(p_new_restricted_attend_type, 'NULL') OR
1012: TRUNC(NVL(p_old_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) <>
1013: TRUNC(NVL(p_new_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) OR
1014: NVL(p_old_duration, 0) <>
1015: NVL(p_new_duration, 0) OR
1016: NVL(p_old_duration_type, 'NULL') <>

Line 1013: TRUNC(NVL(p_new_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) OR

1009: NVL(p_new_restricted_enrolment_cp, 0) OR
1010: NVL(p_old_restricted_attend_type, 'NULL') <>
1011: NVL(p_new_restricted_attend_type, 'NULL') OR
1012: TRUNC(NVL(p_old_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) <>
1013: TRUNC(NVL(p_new_expiry_dt, igs_ge_date.igsdate('0001/01/01'))) OR
1014: NVL(p_old_duration, 0) <>
1015: NVL(p_new_duration, 0) OR
1016: NVL(p_old_duration_type, 'NULL') <>
1017: NVL(p_new_duration_type, 'NULL') THEN

Line 1019: TRUNC(igs_ge_date.igsdate('0001/01/01')) THEN

1015: NVL(p_new_duration, 0) OR
1016: NVL(p_old_duration_type, 'NULL') <>
1017: NVL(p_new_duration_type, 'NULL') THEN
1018: If TRUNC(p_new_applied_dt) <>
1019: TRUNC(igs_ge_date.igsdate('0001/01/01')) THEN
1020: p_out_applied_dt := igs_ge_date.igsdate('0001/01/01');
1021: RETURN FALSE;
1022: END IF;
1023: END IF;

Line 1020: p_out_applied_dt := igs_ge_date.igsdate('0001/01/01');

1016: NVL(p_old_duration_type, 'NULL') <>
1017: NVL(p_new_duration_type, 'NULL') THEN
1018: If TRUNC(p_new_applied_dt) <>
1019: TRUNC(igs_ge_date.igsdate('0001/01/01')) THEN
1020: p_out_applied_dt := igs_ge_date.igsdate('0001/01/01');
1021: RETURN FALSE;
1022: END IF;
1023: END IF;
1024: RETURN TRUE;

Line 1607: IF TRUNC(NVL(p_expiry_dt, igs_ge_date.igsdate('9999/01/01')))

1603: RETURN TRUE;
1604: END IF;
1605: IF NVL(p_old_duration, 0) <> NVL(p_new_duration, 0) OR
1606: NVL(p_old_duration_type, 'NULL') <> NVL(p_new_duration_type, 'NULL') THEN
1607: IF TRUNC(NVL(p_expiry_dt, igs_ge_date.igsdate('9999/01/01')))
1608: < TRUNC(SYSDATE) THEN
1609: p_message_name := 'IGS_PR_DUTY_CNTCH_STPR_OAEXP';
1610: RETURN FALSE;
1611: END IF;

Line 2037: IF TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('0001/01/01'))) <>

2033: p_course_cd IS NULL THEN
2034: p_message_name := null;
2035: RETURN TRUE;
2036: END IF;
2037: IF TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('0001/01/01'))) <>
2038: TRUNC(NVL(p_old_applied_dt, igs_ge_date.igsdate('0001/01/01'))) THEN
2039: IF p_new_applied_dt IS NULL THEN
2040: IF p_decision_status NOT IN (
2041: cst_cancelled,

Line 2038: TRUNC(NVL(p_old_applied_dt, igs_ge_date.igsdate('0001/01/01'))) THEN

2034: p_message_name := null;
2035: RETURN TRUE;
2036: END IF;
2037: IF TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('0001/01/01'))) <>
2038: TRUNC(NVL(p_old_applied_dt, igs_ge_date.igsdate('0001/01/01'))) THEN
2039: IF p_new_applied_dt IS NULL THEN
2040: IF p_decision_status NOT IN (
2041: cst_cancelled,
2042: cst_removed) THEN

Line 2056: IF TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <

2052: p_message_name := 'IGS_PR_APDT_CNT_FUDT';
2053: RETURN FALSE;
2054: END IF;
2055: END IF;
2056: IF TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2057: TRUNC(NVL(p_decision_dt, igs_ge_date.igsdate('0001/01/01'))) AND
2058: TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('0001/01/01'))) <>
2059: TRUNC(igs_ge_date.igsdate('0001/01/01')) THEN
2060: p_message_name := 'IGS_PR_APDT_MST_ONAF_DEDT';

Line 2057: TRUNC(NVL(p_decision_dt, igs_ge_date.igsdate('0001/01/01'))) AND

2053: RETURN FALSE;
2054: END IF;
2055: END IF;
2056: IF TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2057: TRUNC(NVL(p_decision_dt, igs_ge_date.igsdate('0001/01/01'))) AND
2058: TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('0001/01/01'))) <>
2059: TRUNC(igs_ge_date.igsdate('0001/01/01')) THEN
2060: p_message_name := 'IGS_PR_APDT_MST_ONAF_DEDT';
2061: RETURN FALSE;

Line 2058: TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('0001/01/01'))) <>

2054: END IF;
2055: END IF;
2056: IF TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2057: TRUNC(NVL(p_decision_dt, igs_ge_date.igsdate('0001/01/01'))) AND
2058: TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('0001/01/01'))) <>
2059: TRUNC(igs_ge_date.igsdate('0001/01/01')) THEN
2060: p_message_name := 'IGS_PR_APDT_MST_ONAF_DEDT';
2061: RETURN FALSE;
2062: END IF;

Line 2059: TRUNC(igs_ge_date.igsdate('0001/01/01')) THEN

2055: END IF;
2056: IF TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2057: TRUNC(NVL(p_decision_dt, igs_ge_date.igsdate('0001/01/01'))) AND
2058: TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('0001/01/01'))) <>
2059: TRUNC(igs_ge_date.igsdate('0001/01/01')) THEN
2060: p_message_name := 'IGS_PR_APDT_MST_ONAF_DEDT';
2061: RETURN FALSE;
2062: END IF;
2063: OPEN c_sca;

Line 2087: IF NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01')) <>

2083: v_outcome_check_type);
2084: IF v_show_cause_ind = 'Y' AND
2085: v_apply_before_show_ind = 'N' AND
2086: p_show_cause_outcome_dt IS NULL THEN
2087: IF NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01')) <>
2088: igs_ge_date.igsdate('0001/01/01') AND
2089: (TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2090: TRUNC(NVL(p_show_cause_expiry_dt,
2091: igs_ge_date.igsdate('0001/01/01')))) THEN

Line 2088: igs_ge_date.igsdate('0001/01/01') AND

2084: IF v_show_cause_ind = 'Y' AND
2085: v_apply_before_show_ind = 'N' AND
2086: p_show_cause_outcome_dt IS NULL THEN
2087: IF NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01')) <>
2088: igs_ge_date.igsdate('0001/01/01') AND
2089: (TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2090: TRUNC(NVL(p_show_cause_expiry_dt,
2091: igs_ge_date.igsdate('0001/01/01')))) THEN
2092: p_message_name := 'IGS_PR__APDT_CNT_BFSCA_EXDT';

Line 2089: (TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <

2085: v_apply_before_show_ind = 'N' AND
2086: p_show_cause_outcome_dt IS NULL THEN
2087: IF NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01')) <>
2088: igs_ge_date.igsdate('0001/01/01') AND
2089: (TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2090: TRUNC(NVL(p_show_cause_expiry_dt,
2091: igs_ge_date.igsdate('0001/01/01')))) THEN
2092: p_message_name := 'IGS_PR__APDT_CNT_BFSCA_EXDT';
2093: RETURN FALSE;

Line 2091: igs_ge_date.igsdate('0001/01/01')))) THEN

2087: IF NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01')) <>
2088: igs_ge_date.igsdate('0001/01/01') AND
2089: (TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2090: TRUNC(NVL(p_show_cause_expiry_dt,
2091: igs_ge_date.igsdate('0001/01/01')))) THEN
2092: p_message_name := 'IGS_PR__APDT_CNT_BFSCA_EXDT';
2093: RETURN FALSE;
2094: END IF;
2095: END IF;

Line 2099: IF NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01')) <>

2095: END IF;
2096: IF v_appeal_ind = 'Y' AND
2097: v_apply_before_appeal_ind ='N' AND
2098: p_appeal_outcome_dt IS NULL THEN
2099: IF NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01')) <>
2100: igs_ge_date.igsdate('0001/01/01') AND
2101: (TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2102: TRUNC(NVL(p_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01')))) THEN
2103: p_message_name := 'IGS_PR_APDT_CNT_BFAP_EXP_APNT';

Line 2100: igs_ge_date.igsdate('0001/01/01') AND

2096: IF v_appeal_ind = 'Y' AND
2097: v_apply_before_appeal_ind ='N' AND
2098: p_appeal_outcome_dt IS NULL THEN
2099: IF NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01')) <>
2100: igs_ge_date.igsdate('0001/01/01') AND
2101: (TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2102: TRUNC(NVL(p_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01')))) THEN
2103: p_message_name := 'IGS_PR_APDT_CNT_BFAP_EXP_APNT';
2104: RETURN FALSE;

Line 2101: (TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <

2097: v_apply_before_appeal_ind ='N' AND
2098: p_appeal_outcome_dt IS NULL THEN
2099: IF NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01')) <>
2100: igs_ge_date.igsdate('0001/01/01') AND
2101: (TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2102: TRUNC(NVL(p_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01')))) THEN
2103: p_message_name := 'IGS_PR_APDT_CNT_BFAP_EXP_APNT';
2104: RETURN FALSE;
2105: END IF;

Line 2102: TRUNC(NVL(p_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01')))) THEN

2098: p_appeal_outcome_dt IS NULL THEN
2099: IF NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01')) <>
2100: igs_ge_date.igsdate('0001/01/01') AND
2101: (TRUNC(NVL(p_new_applied_dt, igs_ge_date.igsdate('9999/01/01'))) <
2102: TRUNC(NVL(p_appeal_expiry_dt, igs_ge_date.igsdate('0001/01/01')))) THEN
2103: p_message_name := 'IGS_PR_APDT_CNT_BFAP_EXP_APNT';
2104: RETURN FALSE;
2105: END IF;
2106: END IF;