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

Line 68: IF NVL(p_new_actual_reached_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>

64: IF NVL(p_new_description,'NULL') <> NVL(p_old_description,'NULL') THEN
65: v_mil_rec.description := p_old_description;
66: v_create_history := TRUE;
67: END IF;
68: IF NVL(p_new_actual_reached_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
69: NVL(p_old_actual_reached_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
70: v_mil_rec.actual_reached_dt := p_old_actual_reached_dt;
71: v_create_history := TRUE;
72: END IF;

Line 69: NVL(p_old_actual_reached_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

65: v_mil_rec.description := p_old_description;
66: v_create_history := TRUE;
67: END IF;
68: IF NVL(p_new_actual_reached_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
69: NVL(p_old_actual_reached_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
70: v_mil_rec.actual_reached_dt := p_old_actual_reached_dt;
71: v_create_history := TRUE;
72: END IF;
73: IF NVL(p_new_preced_sequence_number,0) <>

Line 171: IF NVL(p_new_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

167: -- associated new values (p_new_) (with the exception the
168: -- last_updated_by and last_update_date columns) then create an IGS_RE_THS_EXAM_HIST history
169: -- record with the old values (p_old_). Do not set the
170: -- last_updated_by and last_update_date columns when creating the history record.
171: IF NVL(p_new_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
172: NVL(p_old_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
173: v_teh_rec.submission_dt := p_old_submission_dt;
174: v_create_history := TRUE;
175: END IF;

Line 172: NVL(p_old_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

168: -- last_updated_by and last_update_date columns) then create an IGS_RE_THS_EXAM_HIST history
169: -- record with the old values (p_old_). Do not set the
170: -- last_updated_by and last_update_date columns when creating the history record.
171: IF NVL(p_new_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
172: NVL(p_old_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
173: v_teh_rec.submission_dt := p_old_submission_dt;
174: v_create_history := TRUE;
175: END IF;
176: IF p_new_thesis_exam_type <> p_old_thesis_exam_type THEN

Line 650: IF NVL(p_new_expected_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

646: NVL(p_old_thesis_result_cd, 'NULL') THEN
647: v_th_rec.thesis_result_cd := NVL(p_old_thesis_result_cd,' ');
648: v_create_history := TRUE;
649: END IF;
650: IF NVL(p_new_expected_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
651: NVL(p_old_expected_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
652: v_th_rec.expected_submission_dt := p_old_expected_submission_dt;
653: v_create_history := TRUE;
654: END IF;

Line 651: NVL(p_old_expected_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

647: v_th_rec.thesis_result_cd := NVL(p_old_thesis_result_cd,' ');
648: v_create_history := TRUE;
649: END IF;
650: IF NVL(p_new_expected_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
651: NVL(p_old_expected_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
652: v_th_rec.expected_submission_dt := p_old_expected_submission_dt;
653: v_create_history := TRUE;
654: END IF;
655: IF NVL(p_new_library_lodgement_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

Line 655: IF NVL(p_new_library_lodgement_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

651: NVL(p_old_expected_submission_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
652: v_th_rec.expected_submission_dt := p_old_expected_submission_dt;
653: v_create_history := TRUE;
654: END IF;
655: IF NVL(p_new_library_lodgement_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
656: NVL(p_old_library_lodgement_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
657: v_th_rec.date_of_library_lodgement := p_old_library_lodgement_dt;
658: v_create_history := TRUE;
659: END IF;

Line 656: NVL(p_old_library_lodgement_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

652: v_th_rec.expected_submission_dt := p_old_expected_submission_dt;
653: v_create_history := TRUE;
654: END IF;
655: IF NVL(p_new_library_lodgement_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
656: NVL(p_old_library_lodgement_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
657: v_th_rec.date_of_library_lodgement := p_old_library_lodgement_dt;
658: v_create_history := TRUE;
659: END IF;
660: IF NVL(p_new_library_catalogue_number, 'NULL') <>

Line 665: IF NVL(p_new_embargo_expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

661: NVL(p_old_library_catalogue_number, 'NULL') THEN
662: v_th_rec.library_catalogue_number := p_old_library_catalogue_number;
663: v_create_history := TRUE;
664: END IF;
665: IF NVL(p_new_embargo_expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
666: NVL(p_old_embargo_expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
667: v_th_rec.embargo_expiry_dt := p_old_embargo_expiry_dt;
668: v_create_history := TRUE;
669: END IF;

Line 666: NVL(p_old_embargo_expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

662: v_th_rec.library_catalogue_number := p_old_library_catalogue_number;
663: v_create_history := TRUE;
664: END IF;
665: IF NVL(p_new_embargo_expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
666: NVL(p_old_embargo_expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
667: v_th_rec.embargo_expiry_dt := p_old_embargo_expiry_dt;
668: v_create_history := TRUE;
669: END IF;
670: IF NVL(p_new_thesis_format, 'NULL') <> NVL(p_old_thesis_format, 'NULL') THEN

Line 674: IF NVL(p_new_logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

670: IF NVL(p_new_thesis_format, 'NULL') <> NVL(p_old_thesis_format, 'NULL') THEN
671: v_th_rec.thesis_format := p_old_thesis_format;
672: v_create_history := TRUE;
673: END IF;
674: IF NVL(p_new_logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
675: NVL(p_old_logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
676: v_th_rec.logical_delete_dt := p_old_logical_delete_dt;
677: v_create_history := TRUE;
678: END IF;

Line 675: NVL(p_old_logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

671: v_th_rec.thesis_format := p_old_thesis_format;
672: v_create_history := TRUE;
673: END IF;
674: IF NVL(p_new_logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
675: NVL(p_old_logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
676: v_th_rec.logical_delete_dt := p_old_logical_delete_dt;
677: v_create_history := TRUE;
678: END IF;
679: IF NVL(p_new_embargo_details, 'NULL') <>

Line 786: IF NVL(p_new_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

782: IF p_new_panel_member_type <> p_old_panel_member_type THEN
783: v_tpmh_rec.panel_member_type := p_old_panel_member_type;
784: v_create_history := TRUE;
785: END IF;
786: IF NVL(p_new_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
787: NVL(p_old_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
788: v_tpmh_rec.confirmed_dt := p_old_confirmed_dt;
789: v_create_history := TRUE;
790: END IF;

Line 787: NVL(p_old_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

783: v_tpmh_rec.panel_member_type := p_old_panel_member_type;
784: v_create_history := TRUE;
785: END IF;
786: IF NVL(p_new_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
787: NVL(p_old_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
788: v_tpmh_rec.confirmed_dt := p_old_confirmed_dt;
789: v_create_history := TRUE;
790: END IF;
791: IF NVL(p_new_declined_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

Line 791: IF NVL(p_new_declined_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

787: NVL(p_old_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
788: v_tpmh_rec.confirmed_dt := p_old_confirmed_dt;
789: v_create_history := TRUE;
790: END IF;
791: IF NVL(p_new_declined_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
792: NVL(p_old_declined_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
793: v_tpmh_rec.declined_dt := p_old_declined_dt;
794: v_create_history := TRUE;
795: END IF;

Line 792: NVL(p_old_declined_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

788: v_tpmh_rec.confirmed_dt := p_old_confirmed_dt;
789: v_create_history := TRUE;
790: END IF;
791: IF NVL(p_new_declined_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
792: NVL(p_old_declined_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
793: v_tpmh_rec.declined_dt := p_old_declined_dt;
794: v_create_history := TRUE;
795: END IF;
796: IF NVL(p_new_anonymity_ind, 'NULL') <> NVL(p_old_anonymity_ind, 'NULL') THEN

Line 805: IF NVL(p_new_paid_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

801: NVL(p_old_thesis_result_cd, 'NULL') THEN
802: v_tpmh_rec.thesis_result_cd := NVL(p_old_thesis_result_cd, ' ');
803: v_create_history := TRUE;
804: END IF;
805: IF NVL(p_new_paid_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
806: NVL(p_old_paid_dt, IGS_GE_DATE.IGSDATE('1900/01/01' )) THEN
807: v_tpmh_rec.paid_dt := p_old_paid_dt;
808: v_create_history := TRUE;
809: END IF;

Line 806: NVL(p_old_paid_dt, IGS_GE_DATE.IGSDATE('1900/01/01' )) THEN

802: v_tpmh_rec.thesis_result_cd := NVL(p_old_thesis_result_cd, ' ');
803: v_create_history := TRUE;
804: END IF;
805: IF NVL(p_new_paid_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
806: NVL(p_old_paid_dt, IGS_GE_DATE.IGSDATE('1900/01/01' )) THEN
807: v_tpmh_rec.paid_dt := p_old_paid_dt;
808: v_create_history := TRUE;
809: END IF;
810: IF NVL(p_new_tracking_id, -1) <> NVL(p_old_tracking_id, -1) THEN