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

Line 281: NVL(cfar.end_dt, igs_ge_date.igsdate('9999/01/01'));

277: WHERE cfar.person_id = p_person_id AND
278: cfar.course_cd = p_course_cd AND
279: cfar.fee_type = p_fee_type AND
280: p_effective_dt BETWEEN cfar.start_dt AND
281: NVL(cfar.end_dt, igs_ge_date.igsdate('9999/01/01'));
282: BEGIN
283: --- Set the default message number
284: p_message_name := NULL;
285: --validate parameters

Line 702: IF NVL(trunc(p_new_effective_dt),igs_ge_date.igsdate('1900/01/01'))

698: IF p_new_currency_cd <> p_old_currency_cd THEN
699: p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
700: RETURN FALSE;
701: END IF;
702: IF NVL(trunc(p_new_effective_dt),igs_ge_date.igsdate('1900/01/01'))
703: <> NVL(trunc(p_old_effective_dt),igs_ge_date.igsdate('1900/01/01')) THEN
704: p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
705: RETURN FALSE;
706: END IF;

Line 703: <> NVL(trunc(p_old_effective_dt),igs_ge_date.igsdate('1900/01/01')) THEN

699: p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
700: RETURN FALSE;
701: END IF;
702: IF NVL(trunc(p_new_effective_dt),igs_ge_date.igsdate('1900/01/01'))
703: <> NVL(trunc(p_old_effective_dt),igs_ge_date.igsdate('1900/01/01')) THEN
704: p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
705: RETURN FALSE;
706: END IF;
707: IF p_new_course_cd <> p_old_course_cd THEN

Line 711: IF NVL(p_new_logical_delete_dt,igs_ge_date.igsdate('1900/01/01'))

707: IF p_new_course_cd <> p_old_course_cd THEN
708: p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
709: RETURN FALSE;
710: END IF;
711: IF NVL(p_new_logical_delete_dt,igs_ge_date.igsdate('1900/01/01'))
712: <> NVL(p_old_logical_delete_dt,igs_ge_date.igsdate('1900/01/01')) AND
713: p_old_logical_delete_dt IS NOT NULL THEN
714: p_message_name := 'IGS_FI_LOGDEL_DATE_NOT_CLEAR';
715: RETURN FALSE;

Line 712: <> NVL(p_old_logical_delete_dt,igs_ge_date.igsdate('1900/01/01')) AND

708: p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
709: RETURN FALSE;
710: END IF;
711: IF NVL(p_new_logical_delete_dt,igs_ge_date.igsdate('1900/01/01'))
712: <> NVL(p_old_logical_delete_dt,igs_ge_date.igsdate('1900/01/01')) AND
713: p_old_logical_delete_dt IS NOT NULL THEN
714: p_message_name := 'IGS_FI_LOGDEL_DATE_NOT_CLEAR';
715: RETURN FALSE;
716: END IF;