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

Line 5822: IF NVL(TRUNC(p_new_enrolled_dt), igs_ge_date.igsdate('1900/01/01')) <>

5818: IF p_new_unit_class <> p_old_unit_class THEN
5819: r_suah.unit_class := p_old_unit_class;
5820: v_create_history := TRUE;
5821: END IF;
5822: IF NVL(TRUNC(p_new_enrolled_dt), igs_ge_date.igsdate('1900/01/01')) <>
5823: NVL(TRUNC(p_old_enrolled_dt), igs_ge_date.igsdate('1900/01/01')) THEN
5824: r_suah.enrolled_dt := TRUNC(p_old_enrolled_dt);
5825: v_create_history := TRUE;
5826: END IF;

Line 5823: NVL(TRUNC(p_old_enrolled_dt), igs_ge_date.igsdate('1900/01/01')) THEN

5819: r_suah.unit_class := p_old_unit_class;
5820: v_create_history := TRUE;
5821: END IF;
5822: IF NVL(TRUNC(p_new_enrolled_dt), igs_ge_date.igsdate('1900/01/01')) <>
5823: NVL(TRUNC(p_old_enrolled_dt), igs_ge_date.igsdate('1900/01/01')) THEN
5824: r_suah.enrolled_dt := TRUNC(p_old_enrolled_dt);
5825: v_create_history := TRUE;
5826: END IF;
5827: IF p_new_unit_attempt_status <> p_old_unit_attempt_status THEN

Line 5842: IF NVL(TRUNC(p_new_discontinued_dt), igs_ge_date.igsdate('1900/01/01')) <>

5838: CLOSE c_find_aus_desc;
5839: END IF;
5840: v_create_history := TRUE;
5841: END IF;
5842: IF NVL(TRUNC(p_new_discontinued_dt), igs_ge_date.igsdate('1900/01/01')) <>
5843: NVL(TRUNC(p_old_discontinued_dt), igs_ge_date.igsdate('1900/01/01')) THEN
5844: r_suah.discontinued_dt := TRUNC(p_old_discontinued_dt);
5845: v_create_history := TRUE;
5846: END IF;

Line 5843: NVL(TRUNC(p_old_discontinued_dt), igs_ge_date.igsdate('1900/01/01')) THEN

5839: END IF;
5840: v_create_history := TRUE;
5841: END IF;
5842: IF NVL(TRUNC(p_new_discontinued_dt), igs_ge_date.igsdate('1900/01/01')) <>
5843: NVL(TRUNC(p_old_discontinued_dt), igs_ge_date.igsdate('1900/01/01')) THEN
5844: r_suah.discontinued_dt := TRUNC(p_old_discontinued_dt);
5845: v_create_history := TRUE;
5846: END IF;
5847: IF NVL(p_new_rule_waived_dt, igs_ge_date.igsdate('1900/01/01')) <>

Line 5847: IF NVL(p_new_rule_waived_dt, igs_ge_date.igsdate('1900/01/01')) <>

5843: NVL(TRUNC(p_old_discontinued_dt), igs_ge_date.igsdate('1900/01/01')) THEN
5844: r_suah.discontinued_dt := TRUNC(p_old_discontinued_dt);
5845: v_create_history := TRUE;
5846: END IF;
5847: IF NVL(p_new_rule_waived_dt, igs_ge_date.igsdate('1900/01/01')) <>
5848: NVL(p_old_rule_waived_dt, igs_ge_date.igsdate('1900/01/01')) THEN
5849: r_suah.rule_waived_dt := p_old_rule_waived_dt;
5850: v_create_history := TRUE;
5851: END IF;

Line 5848: NVL(p_old_rule_waived_dt, igs_ge_date.igsdate('1900/01/01')) THEN

5844: r_suah.discontinued_dt := TRUNC(p_old_discontinued_dt);
5845: v_create_history := TRUE;
5846: END IF;
5847: IF NVL(p_new_rule_waived_dt, igs_ge_date.igsdate('1900/01/01')) <>
5848: NVL(p_old_rule_waived_dt, igs_ge_date.igsdate('1900/01/01')) THEN
5849: r_suah.rule_waived_dt := p_old_rule_waived_dt;
5850: v_create_history := TRUE;
5851: END IF;
5852: IF NVL(p_new_rule_waived_person_id, 0) <>

Line 5901: igs_ge_date.igsdate('1900/01/01')) <>

5897: r_suah.override_achievable_cp := p_old_override_achievable_cp;
5898: v_create_history := TRUE;
5899: END IF;
5900: IF NVL(p_new_override_outcome_due_dt,
5901: igs_ge_date.igsdate('1900/01/01')) <>
5902: NVL(p_old_override_outcome_due_dt,
5903: igs_ge_date.igsdate('1900/01/01')) THEN
5904: r_suah.override_outcome_due_dt := p_old_override_outcome_due_dt;
5905: v_create_history := TRUE;

Line 5903: igs_ge_date.igsdate('1900/01/01')) THEN

5899: END IF;
5900: IF NVL(p_new_override_outcome_due_dt,
5901: igs_ge_date.igsdate('1900/01/01')) <>
5902: NVL(p_old_override_outcome_due_dt,
5903: igs_ge_date.igsdate('1900/01/01')) THEN
5904: r_suah.override_outcome_due_dt := p_old_override_outcome_due_dt;
5905: v_create_history := TRUE;
5906: END IF;
5907: IF NVL(p_new_override_credit_reason, 'NULL') <>

Line 6677: IF NVL(p_new_selection_dt, igs_ge_date.igsdate('1900/01/01')) <>

6673: IF p_new_us_version_number <> p_old_us_version_number THEN
6674: v_susa_rec.us_version_number := p_old_us_version_number;
6675: v_create_history := TRUE;
6676: END IF;
6677: IF NVL(p_new_selection_dt, igs_ge_date.igsdate('1900/01/01')) <>
6678: NVL(p_old_selection_dt,igs_ge_date.igsdate('1900/01/01')) THEN
6679: v_susa_rec.selection_dt := p_old_selection_dt;
6680: v_create_history := TRUE;
6681: END IF;

Line 6678: NVL(p_old_selection_dt,igs_ge_date.igsdate('1900/01/01')) THEN

6674: v_susa_rec.us_version_number := p_old_us_version_number;
6675: v_create_history := TRUE;
6676: END IF;
6677: IF NVL(p_new_selection_dt, igs_ge_date.igsdate('1900/01/01')) <>
6678: NVL(p_old_selection_dt,igs_ge_date.igsdate('1900/01/01')) THEN
6679: v_susa_rec.selection_dt := p_old_selection_dt;
6680: v_create_history := TRUE;
6681: END IF;
6682: IF NVL(p_new_student_confirmed_ind,'U') <>

Line 6687: IF NVL(p_new_end_dt,igs_ge_date.igsdate('1800/01/01')) <>

6683: NVL(p_old_student_confirmed_ind,'U') THEN
6684: v_susa_rec.student_confirmed_ind := p_old_student_confirmed_ind;
6685: v_create_history := TRUE;
6686: END IF;
6687: IF NVL(p_new_end_dt,igs_ge_date.igsdate('1800/01/01')) <>
6688: NVL(p_old_end_dt,igs_ge_date.igsdate('1800/01/01')) THEN
6689: v_susa_rec.end_dt := p_old_end_dt;
6690: v_create_history := TRUE;
6691: END IF;

Line 6688: NVL(p_old_end_dt,igs_ge_date.igsdate('1800/01/01')) THEN

6684: v_susa_rec.student_confirmed_ind := p_old_student_confirmed_ind;
6685: v_create_history := TRUE;
6686: END IF;
6687: IF NVL(p_new_end_dt,igs_ge_date.igsdate('1800/01/01')) <>
6688: NVL(p_old_end_dt,igs_ge_date.igsdate('1800/01/01')) THEN
6689: v_susa_rec.end_dt := p_old_end_dt;
6690: v_create_history := TRUE;
6691: END IF;
6692: IF NVL(p_new_parent_unit_set_cd, 'NULL') <>

Line 6715: IF NVL(p_new_authorised_on, igs_ge_date.igsdate('1800/01/01')) <>

6711: NVL(p_old_authorised_person_id, 0) THEN
6712: v_susa_rec.authorised_person_id := p_old_authorised_person_id;
6713: v_create_history := TRUE;
6714: END IF;
6715: IF NVL(p_new_authorised_on, igs_ge_date.igsdate('1800/01/01')) <>
6716: NVL(p_old_authorised_on, igs_ge_date.igsdate('1800/01/01')) THEN
6717: v_susa_rec.authorised_on := p_old_authorised_on;
6718: v_create_history := TRUE;
6719: END IF;

Line 6716: NVL(p_old_authorised_on, igs_ge_date.igsdate('1800/01/01')) THEN

6712: v_susa_rec.authorised_person_id := p_old_authorised_person_id;
6713: v_create_history := TRUE;
6714: END IF;
6715: IF NVL(p_new_authorised_on, igs_ge_date.igsdate('1800/01/01')) <>
6716: NVL(p_old_authorised_on, igs_ge_date.igsdate('1800/01/01')) THEN
6717: v_susa_rec.authorised_on := p_old_authorised_on;
6718: v_create_history := TRUE;
6719: END IF;
6720: IF NVL(p_new_override_title,'NULL') <> NVL(p_old_override_title,'NULL') THEN

Line 6728: IF NVL(p_new_rqrmnts_complete_dt, igs_ge_date.igsdate('1800/01/01')) <>

6724: IF p_new_rqrmnts_complete_ind <> p_old_rqrmnts_complete_ind THEN
6725: v_susa_rec.rqrmnts_complete_ind := p_old_rqrmnts_complete_ind;
6726: v_create_history := TRUE;
6727: END IF;
6728: IF NVL(p_new_rqrmnts_complete_dt, igs_ge_date.igsdate('1800/01/01')) <>
6729: NVL(p_old_rqrmnts_complete_dt, igs_ge_date.igsdate('1800/01/01')) THEN
6730: v_susa_rec.rqrmnts_complete_dt := p_old_rqrmnts_complete_dt;
6731: v_create_history := TRUE;
6732: END IF;

Line 6729: NVL(p_old_rqrmnts_complete_dt, igs_ge_date.igsdate('1800/01/01')) THEN

6725: v_susa_rec.rqrmnts_complete_ind := p_old_rqrmnts_complete_ind;
6726: v_create_history := TRUE;
6727: END IF;
6728: IF NVL(p_new_rqrmnts_complete_dt, igs_ge_date.igsdate('1800/01/01')) <>
6729: NVL(p_old_rqrmnts_complete_dt, igs_ge_date.igsdate('1800/01/01')) THEN
6730: v_susa_rec.rqrmnts_complete_dt := p_old_rqrmnts_complete_dt;
6731: v_create_history := TRUE;
6732: END IF;
6733: IF NVL(p_new_s_completed_source_type,'NULL') <>

Line 8099: IF NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00') )

8095: END IF;
8096: v_selection_dt := NVL(v_selection_dt,vc_susa_upd_rec.selection_dt);
8097: END IF;
8098:
8099: IF NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00') )
8100: <> NVL(vc_susa_upd_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8101: OR v_confirmed_ind <> vc_susa_upd_rec.student_confirmed_ind
8102: THEN
8103:

Line 8100: <> NVL(vc_susa_upd_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))

8096: v_selection_dt := NVL(v_selection_dt,vc_susa_upd_rec.selection_dt);
8097: END IF;
8098:
8099: IF NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00') )
8100: <> NVL(vc_susa_upd_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8101: OR v_confirmed_ind <> vc_susa_upd_rec.student_confirmed_ind
8102: THEN
8103:
8104: IF igs_en_gen_legacy.check_usa_overlap(

Line 8261: IF NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))

8257: END IF;
8258: v_selection_dt := NVL(NVL(v_selection_dt,v_susa_rec.selection_dt),sysdate);
8259: END IF;
8260:
8261: IF NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8262: <> NVL(v_susa_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8263: OR v_confirmed_ind <> v_susa_rec.student_confirmed_ind
8264: THEN
8265: IF igs_en_gen_legacy.check_usa_overlap(

Line 8262: <> NVL(v_susa_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))

8258: v_selection_dt := NVL(NVL(v_selection_dt,v_susa_rec.selection_dt),sysdate);
8259: END IF;
8260:
8261: IF NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8262: <> NVL(v_susa_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8263: OR v_confirmed_ind <> v_susa_rec.student_confirmed_ind
8264: THEN
8265: IF igs_en_gen_legacy.check_usa_overlap(
8266: v_susa_rec.person_id,

Line 8512: OR NVL(v_rqrmnts_complete_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))

8508: END IF; -- end of IF v_rqrmnts_complete_ind = 'Y' THEN
8509:
8510:
8511: IF v_rqrmnts_complete_ind <> vc_susa_upd_rec.rqrmnts_complete_ind
8512: OR NVL(v_rqrmnts_complete_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8513: <> NVL(vc_susa_upd_rec.rqrmnts_complete_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8514: OR NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8515: <> NVL(vc_susa_upd_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8516: OR v_confirmed_ind <> vc_susa_upd_rec.student_confirmed_ind

Line 8513: <> NVL(vc_susa_upd_rec.rqrmnts_complete_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))

8509:
8510:
8511: IF v_rqrmnts_complete_ind <> vc_susa_upd_rec.rqrmnts_complete_ind
8512: OR NVL(v_rqrmnts_complete_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8513: <> NVL(vc_susa_upd_rec.rqrmnts_complete_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8514: OR NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8515: <> NVL(vc_susa_upd_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8516: OR v_confirmed_ind <> vc_susa_upd_rec.student_confirmed_ind
8517: THEN

Line 8514: OR NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))

8510:
8511: IF v_rqrmnts_complete_ind <> vc_susa_upd_rec.rqrmnts_complete_ind
8512: OR NVL(v_rqrmnts_complete_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8513: <> NVL(vc_susa_upd_rec.rqrmnts_complete_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8514: OR NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8515: <> NVL(vc_susa_upd_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8516: OR v_confirmed_ind <> vc_susa_upd_rec.student_confirmed_ind
8517: THEN
8518:

Line 8515: <> NVL(vc_susa_upd_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))

8511: IF v_rqrmnts_complete_ind <> vc_susa_upd_rec.rqrmnts_complete_ind
8512: OR NVL(v_rqrmnts_complete_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8513: <> NVL(vc_susa_upd_rec.rqrmnts_complete_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8514: OR NVL(v_selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8515: <> NVL(vc_susa_upd_rec.selection_dt,igs_ge_date.igsdate('1000/01/01 00:00:00'))
8516: OR v_confirmed_ind <> vc_susa_upd_rec.student_confirmed_ind
8517: THEN
8518:
8519: IF igs_en_gen_legacy.check_usa_overlap(