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

Line 709: NVL(TRUNC(old_references.prpsd_commencement_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>

705: NVL(old_references.us_version_number, -1) <>
706: NVL(new_references.us_version_number, -1) OR
707: NVL(old_references.preference_number, -1) <>
708: NVL(new_references.preference_number, -1) OR
709: NVL(TRUNC(old_references.prpsd_commencement_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
710: NVL(new_references.prpsd_commencement_dt,
711: IGS_GE_DATE.IGSDATE('1900/01/01')) OR
712: NVL(old_references.fee_cat, '-1') <>
713: NVL(new_references.fee_cat, '-1') OR

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

707: NVL(old_references.preference_number, -1) <>
708: NVL(new_references.preference_number, -1) OR
709: NVL(TRUNC(old_references.prpsd_commencement_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
710: NVL(new_references.prpsd_commencement_dt,
711: IGS_GE_DATE.IGSDATE('1900/01/01')) OR
712: NVL(old_references.fee_cat, '-1') <>
713: NVL(new_references.fee_cat, '-1') OR
714: NVL(old_references.hecs_payment_option, '-1') <>
715: NVL(new_references.hecs_payment_option, '-1') OR

Line 1282: NVL(TRUNC(old_references.actual_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>

1278: -- Validate admission offer response status.
1279: --
1280: IF NVL(old_references.course_cd, '-1') <> new_references.course_cd OR
1281: NVL(old_references.adm_offer_resp_status, '-1') <> new_references.adm_offer_resp_status OR
1282: NVL(TRUNC(old_references.actual_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1283: NVL(new_references.actual_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1284: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aors (
1285: new_references.person_id,
1286: new_references.admission_appl_number,

Line 1283: NVL(new_references.actual_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

1279: --
1280: IF NVL(old_references.course_cd, '-1') <> new_references.course_cd OR
1281: NVL(old_references.adm_offer_resp_status, '-1') <> new_references.adm_offer_resp_status OR
1282: NVL(TRUNC(old_references.actual_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1283: NVL(new_references.actual_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1284: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aors (
1285: new_references.person_id,
1286: new_references.admission_appl_number,
1287: new_references.nominated_course_cd,

Line 1365: IF (NVL(TRUNC(old_references.offer_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>

1361: END IF;
1362: --
1363: -- Validate offer date.
1364: --
1365: IF (NVL(TRUNC(old_references.offer_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1366: NVL(new_references.offer_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) OR
1367: NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status OR
1368: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
1369: NVL(old_references.adm_ci_sequence_number, -1) <>

Line 1366: NVL(new_references.offer_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) OR

1362: --
1363: -- Validate offer date.
1364: --
1365: IF (NVL(TRUNC(old_references.offer_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1366: NVL(new_references.offer_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) OR
1367: NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status OR
1368: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
1369: NVL(old_references.adm_ci_sequence_number, -1) <>
1370: NVL(new_references.adm_ci_sequence_number, -1)) THEN

Line 1385: IF (NVL(TRUNC(old_references.offer_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>

1381: END IF;
1382: --
1383: -- Validate offer response date.
1384: --
1385: IF (NVL(TRUNC(old_references.offer_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1386: NVL(new_references.offer_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1387: (NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status) OR
1388: (NVL(TRUNC(old_references.offer_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1389: NVL(new_references.offer_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

Line 1386: NVL(new_references.offer_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR

1382: --
1383: -- Validate offer response date.
1384: --
1385: IF (NVL(TRUNC(old_references.offer_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1386: NVL(new_references.offer_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1387: (NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status) OR
1388: (NVL(TRUNC(old_references.offer_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1389: NVL(new_references.offer_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
1390: IF IGS_AD_VAL_ACAI.admp_val_off_resp_dt (

Line 1388: (NVL(TRUNC(old_references.offer_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>

1384: --
1385: IF (NVL(TRUNC(old_references.offer_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1386: NVL(new_references.offer_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1387: (NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status) OR
1388: (NVL(TRUNC(old_references.offer_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1389: NVL(new_references.offer_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
1390: IF IGS_AD_VAL_ACAI.admp_val_off_resp_dt (
1391: new_references.offer_response_dt,
1392: new_references.adm_outcome_status,

Line 1389: NVL(new_references.offer_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

1385: IF (NVL(TRUNC(old_references.offer_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1386: NVL(new_references.offer_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1387: (NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status) OR
1388: (NVL(TRUNC(old_references.offer_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1389: NVL(new_references.offer_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
1390: IF IGS_AD_VAL_ACAI.admp_val_off_resp_dt (
1391: new_references.offer_response_dt,
1392: new_references.adm_outcome_status,
1393: new_references.offer_dt,

Line 1403: IF (NVL(TRUNC(old_references.prpsd_commencement_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>

1399: END IF;
1400: --
1401: -- Validate proposed commencement date.
1402: --
1403: IF (NVL(TRUNC(old_references.prpsd_commencement_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1404: NVL(new_references.prpsd_commencement_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
1405: IF IGS_RE_VAL_CA.admp_val_acai_comm (
1406: new_references.person_id,
1407: new_references.course_cd,

Line 1404: NVL(new_references.prpsd_commencement_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

1400: --
1401: -- Validate proposed commencement date.
1402: --
1403: IF (NVL(TRUNC(old_references.prpsd_commencement_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1404: NVL(new_references.prpsd_commencement_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
1405: IF IGS_RE_VAL_CA.admp_val_acai_comm (
1406: new_references.person_id,
1407: new_references.course_cd,
1408: new_references.crv_version_number,

Line 1428: IF (NVL(TRUNC(old_references.actual_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>

1424: END IF;
1425: --
1426: -- Validate actual response date.
1427: --
1428: IF (NVL(TRUNC(old_references.actual_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1429: NVL(new_references.actual_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1430: (NVL(old_references.adm_offer_resp_status, '-1') <> new_references.adm_offer_resp_status) THEN
1431: IF IGS_AD_VAL_ACAI.admp_val_act_resp_dt (
1432: new_references.actual_response_dt,

Line 1429: NVL(new_references.actual_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR

1425: --
1426: -- Validate actual response date.
1427: --
1428: IF (NVL(TRUNC(old_references.actual_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1429: NVL(new_references.actual_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1430: (NVL(old_references.adm_offer_resp_status, '-1') <> new_references.adm_offer_resp_status) THEN
1431: IF IGS_AD_VAL_ACAI.admp_val_act_resp_dt (
1432: new_references.actual_response_dt,
1433: new_references.adm_offer_resp_status,

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

1441: --
1442: -- Validate conditional offer satisfied date.
1443: --
1444: IF (NVL(TRUNC(old_references.cndtnl_offer_satisfied_dt),
1445: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1446: NVL(new_references.cndtnl_offer_satisfied_dt,
1447: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1448: (NVL(old_references.adm_cndtnl_offer_status, '-1') <>
1449: new_references.adm_cndtnl_offer_status) THEN

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

1443: --
1444: IF (NVL(TRUNC(old_references.cndtnl_offer_satisfied_dt),
1445: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1446: NVL(new_references.cndtnl_offer_satisfied_dt,
1447: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1448: (NVL(old_references.adm_cndtnl_offer_status, '-1') <>
1449: new_references.adm_cndtnl_offer_status) THEN
1450: IF IGS_AD_VAL_ACAI.admp_val_stsfd_dt (
1451: new_references.cndtnl_offer_satisfied_dt,

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

1639: --
1640: -- Validate the Outcome Status Authorising Date.
1641: --
1642: IF NVL(TRUNC(old_references.adm_outcome_status_auth_dt),
1643: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1644: NVL(new_references.adm_outcome_status_auth_dt,
1645: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1646: IF IGS_AD_VAL_ACAI.admp_val_ovrd_dt (
1647: new_references.adm_outcome_status_auth_dt,

Line 1645: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

1641: --
1642: IF NVL(TRUNC(old_references.adm_outcome_status_auth_dt),
1643: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1644: NVL(new_references.adm_outcome_status_auth_dt,
1645: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1646: IF IGS_AD_VAL_ACAI.admp_val_ovrd_dt (
1647: new_references.adm_outcome_status_auth_dt,
1648: v_override_outcome_allowed_ind,
1649: v_message_name) = FALSE THEN

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

1657: --
1658: IF NVL(old_references.adm_otcm_status_auth_person_id, -1) <>
1659: NVL(new_references.adm_otcm_status_auth_person_id, -1) OR
1660: NVL(TRUNC(old_references.adm_outcome_status_auth_dt),
1661: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1662: NVL(new_references.adm_outcome_status_auth_dt,
1663: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1664: IF IGS_AD_VAL_ACAI.admp_val_ovrd_person (
1665: new_references.adm_otcm_status_auth_person_id,

Line 1663: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

1659: NVL(new_references.adm_otcm_status_auth_person_id, -1) OR
1660: NVL(TRUNC(old_references.adm_outcome_status_auth_dt),
1661: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1662: NVL(new_references.adm_outcome_status_auth_dt,
1663: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1664: IF IGS_AD_VAL_ACAI.admp_val_ovrd_person (
1665: new_references.adm_otcm_status_auth_person_id,
1666: new_references.adm_outcome_status_auth_dt,
1667: v_override_outcome_allowed_ind,

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

1676: --
1677: IF NVL(old_references.adm_outcome_status_reason, '-1') <>
1678: NVL(new_references.adm_outcome_status_reason, '-1') OR
1679: NVL(TRUNC(old_references.adm_outcome_status_auth_dt),
1680: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1681: NVL(new_references.adm_outcome_status_auth_dt,
1682: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1683: IF IGS_AD_VAL_ACAI.admp_val_ovrd_reason (
1684: new_references.adm_outcome_status_reason,

Line 1682: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

1678: NVL(new_references.adm_outcome_status_reason, '-1') OR
1679: NVL(TRUNC(old_references.adm_outcome_status_auth_dt),
1680: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1681: NVL(new_references.adm_outcome_status_auth_dt,
1682: IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1683: IF IGS_AD_VAL_ACAI.admp_val_ovrd_reason (
1684: new_references.adm_outcome_status_reason,
1685: new_references.adm_outcome_status_auth_dt,
1686: v_override_outcome_allowed_ind,

Line 7173: IF NVL(TRUNC(old_references.Decision_Date),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Decision_Date),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN

7169: END IF;
7170: IF NVL(old_references.Unit_Set_Cd,'**##') <> NVL(new_references.Unit_Set_Cd,'**##')THEN
7171: RETURN TRUE;
7172: END IF;
7173: IF NVL(TRUNC(old_references.Decision_Date),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Decision_Date),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN
7174: RETURN TRUE;
7175: END IF;
7176: IF NVL(old_references.Decision_Reason_Id,-1) <> NVL(new_references.Decision_Reason_Id,-1)THEN
7177: RETURN TRUE;

Line 7209: IF NVL(TRUNC(old_references.Adm_Outcome_Status_Auth_Dt),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Adm_Outcome_Status_Auth_Dt),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN

7205: END IF;
7206: IF NVL(old_references.Adm_Otcm_Status_Auth_Person_Id,-1) <> NVL(new_references.Adm_Otcm_Status_Auth_Person_Id,-1)THEN
7207: RETURN TRUE;
7208: END IF;
7209: IF NVL(TRUNC(old_references.Adm_Outcome_Status_Auth_Dt),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Adm_Outcome_Status_Auth_Dt),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN
7210: RETURN TRUE;
7211: END IF;
7212: IF NVL(old_references.Adm_Outcome_Status_Reason,'**##') <> NVL(new_references.Adm_Outcome_Status_Reason,'**##')THEN
7213: RETURN TRUE;

Line 7215: IF NVL(TRUNC(old_references.Offer_Dt),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Offer_Dt),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN

7211: END IF;
7212: IF NVL(old_references.Adm_Outcome_Status_Reason,'**##') <> NVL(new_references.Adm_Outcome_Status_Reason,'**##')THEN
7213: RETURN TRUE;
7214: END IF;
7215: IF NVL(TRUNC(old_references.Offer_Dt),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Offer_Dt),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN
7216: RETURN TRUE;
7217: END IF;
7218: IF NVL(old_references.Adm_Cndtnl_Offer_Status,'**##') <> NVL(new_references.Adm_Cndtnl_Offer_Status,'**##')THEN
7219: RETURN TRUE;

Line 7221: IF NVL(TRUNC(old_references.Cndtnl_Offer_Satisfied_Dt),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Cndtnl_Offer_Satisfied_Dt),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN

7217: END IF;
7218: IF NVL(old_references.Adm_Cndtnl_Offer_Status,'**##') <> NVL(new_references.Adm_Cndtnl_Offer_Status,'**##')THEN
7219: RETURN TRUE;
7220: END IF;
7221: IF NVL(TRUNC(old_references.Cndtnl_Offer_Satisfied_Dt),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Cndtnl_Offer_Satisfied_Dt),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN
7222: RETURN TRUE;
7223: END IF;
7224: IF NVL(old_references.Cndtnl_Offer_Must_Be_Stsfd_Ind,'**##') <> NVL(new_references.Cndtnl_Offer_Must_Be_Stsfd_Ind,'**##')THEN
7225: RETURN TRUE;

Line 7243: IF NVL(TRUNC(old_references.Creation_Date),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Creation_Date),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN

7239: IF NVL(old_references.Cndtnl_Offer_Cndtn,'**##') <> NVL(new_references.Cndtnl_Offer_Cndtn,'**##')THEN
7240: RETURN TRUE;
7241: END IF;
7242: /*
7243: IF NVL(TRUNC(old_references.Creation_Date),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Creation_Date),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN
7244: RETURN TRUE;
7245: END IF;
7246: IF NVL(old_references.Created_By,-99999) <> NVL(new_references.Created_By,-99999)THEN
7247: RETURN TRUE;

Line 7249: IF NVL(TRUNC(old_references.Last_Update_Date),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Last_Update_Date),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN

7245: END IF;
7246: IF NVL(old_references.Created_By,-99999) <> NVL(new_references.Created_By,-99999)THEN
7247: RETURN TRUE;
7248: END IF;
7249: IF NVL(TRUNC(old_references.Last_Update_Date),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Last_Update_Date),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN
7250: RETURN TRUE;
7251: END IF;
7252: IF NVL(old_references.Last_Updated_By,-99999) <> NVL(new_references.Last_Updated_By,-99999)THEN
7253: RETURN TRUE;

Line 7269: IF NVL(TRUNC(old_references.Program_Update_Date),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Program_Update_Date),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN

7265: IF NVL(old_references.Program_Application_Id,-1) <> NVL(new_references.Program_Application_Id,-1)THEN
7266: RETURN TRUE;
7267: END IF;
7268:
7269: IF NVL(TRUNC(old_references.Program_Update_Date),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Program_Update_Date),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN
7270: RETURN TRUE;
7271: END IF;
7272: */
7273: IF NVL(old_references.Ss_Application_Id,-1) <> NVL(new_references.Ss_Application_Id,-1)THEN

Line 7288: IF NVL(TRUNC(old_references.Idx_Calc_Date),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Idx_Calc_Date),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN

7284: END IF;
7285: IF NVL(old_references.Sch_Apl_To_Id,-1) <> NVL(new_references.Sch_Apl_To_Id,-1)THEN
7286: RETURN TRUE;
7287: END IF;
7288: IF NVL(TRUNC(old_references.Idx_Calc_Date),IGS_GE_DATE.IGSDATE('1900/01/01')) <> NVL(TRUNC(new_references.Idx_Calc_Date),IGS_GE_DATE.IGSDATE('1900/01/01'))THEN
7289: RETURN TRUE;
7290: END IF;
7291: IF NVL(old_references.Waitlist_Status,'**##') <> NVL(new_references.Waitlist_Status,'**##')THEN
7292: RETURN TRUE;