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_RE_THESIS

Line 158: -- Insert IGS_RE_THESIS_EXAM history (IGS_RE_THS_EXAM_HIST)

154: gv_other_detail VARCHAR2(255);
155: LV_ROWID VARCHAR2(25);
156: v_org_id IGS_PR_MILESTONE_HST.ORG_ID%TYPE := IGS_GE_GEN_003.Get_Org_Id;
157: BEGIN -- resp_ins_tex_hist
158: -- Insert IGS_RE_THESIS_EXAM history (IGS_RE_THS_EXAM_HIST)
159: DECLARE
160: v_teh_rec IGS_RE_THS_EXAM_HIST%ROWTYPE;
161: v_create_history BOOLEAN := FALSE;
162: v_hist_start_dt IGS_RE_THESIS_EXAM.last_update_date%TYPE;

Line 162: v_hist_start_dt IGS_RE_THESIS_EXAM.last_update_date%TYPE;

158: -- Insert IGS_RE_THESIS_EXAM history (IGS_RE_THS_EXAM_HIST)
159: DECLARE
160: v_teh_rec IGS_RE_THS_EXAM_HIST%ROWTYPE;
161: v_create_history BOOLEAN := FALSE;
162: v_hist_start_dt IGS_RE_THESIS_EXAM.last_update_date%TYPE;
163: v_hist_end_dt IGS_RE_THESIS_EXAM.last_update_date%TYPE;
164: v_hist_who IGS_RE_THESIS_EXAM.last_updated_by%TYPE;
165: BEGIN
166: -- If any of the old values (p_old_) are different from the

Line 163: v_hist_end_dt IGS_RE_THESIS_EXAM.last_update_date%TYPE;

159: DECLARE
160: v_teh_rec IGS_RE_THS_EXAM_HIST%ROWTYPE;
161: v_create_history BOOLEAN := FALSE;
162: v_hist_start_dt IGS_RE_THESIS_EXAM.last_update_date%TYPE;
163: v_hist_end_dt IGS_RE_THESIS_EXAM.last_update_date%TYPE;
164: v_hist_who IGS_RE_THESIS_EXAM.last_updated_by%TYPE;
165: BEGIN
166: -- If any of the old values (p_old_) are different from the
167: -- associated new values (p_new_) (with the exception the

Line 164: v_hist_who IGS_RE_THESIS_EXAM.last_updated_by%TYPE;

160: v_teh_rec IGS_RE_THS_EXAM_HIST%ROWTYPE;
161: v_create_history BOOLEAN := FALSE;
162: v_hist_start_dt IGS_RE_THESIS_EXAM.last_update_date%TYPE;
163: v_hist_end_dt IGS_RE_THESIS_EXAM.last_update_date%TYPE;
164: v_hist_who IGS_RE_THESIS_EXAM.last_updated_by%TYPE;
165: BEGIN
166: -- If any of the old values (p_old_) are different from the
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

Line 615: -- Insert IGS_RE_THESIS history (IGS_RE_THESIS_HIST)

611: LV_ROWID VARCHAR2(25);
612: v_org_id IGS_PR_MILESTONE_HST.ORG_ID%TYPE := IGS_GE_GEN_003.Get_Org_Id;
613:
614: BEGIN -- resp_ins_the_hist
615: -- Insert IGS_RE_THESIS history (IGS_RE_THESIS_HIST)
616: DECLARE
617: v_th_rec IGS_RE_THESIS_HIST%ROWTYPE;
618: v_create_history BOOLEAN := FALSE;
619: v_hist_start_dt IGS_RE_THESIS.last_update_date%TYPE;

Line 617: v_th_rec IGS_RE_THESIS_HIST%ROWTYPE;

613:
614: BEGIN -- resp_ins_the_hist
615: -- Insert IGS_RE_THESIS history (IGS_RE_THESIS_HIST)
616: DECLARE
617: v_th_rec IGS_RE_THESIS_HIST%ROWTYPE;
618: v_create_history BOOLEAN := FALSE;
619: v_hist_start_dt IGS_RE_THESIS.last_update_date%TYPE;
620: v_hist_end_dt IGS_RE_THESIS.last_update_date%TYPE;
621: v_hist_who IGS_RE_THESIS.last_updated_by%TYPE;

Line 619: v_hist_start_dt IGS_RE_THESIS.last_update_date%TYPE;

615: -- Insert IGS_RE_THESIS history (IGS_RE_THESIS_HIST)
616: DECLARE
617: v_th_rec IGS_RE_THESIS_HIST%ROWTYPE;
618: v_create_history BOOLEAN := FALSE;
619: v_hist_start_dt IGS_RE_THESIS.last_update_date%TYPE;
620: v_hist_end_dt IGS_RE_THESIS.last_update_date%TYPE;
621: v_hist_who IGS_RE_THESIS.last_updated_by%TYPE;
622: BEGIN
623: -- If any of the old values (p_old_) are different from the

Line 620: v_hist_end_dt IGS_RE_THESIS.last_update_date%TYPE;

616: DECLARE
617: v_th_rec IGS_RE_THESIS_HIST%ROWTYPE;
618: v_create_history BOOLEAN := FALSE;
619: v_hist_start_dt IGS_RE_THESIS.last_update_date%TYPE;
620: v_hist_end_dt IGS_RE_THESIS.last_update_date%TYPE;
621: v_hist_who IGS_RE_THESIS.last_updated_by%TYPE;
622: BEGIN
623: -- If any of the old values (p_old_) are different from the
624: -- associated new values (p_new_) (with the exception the

Line 621: v_hist_who IGS_RE_THESIS.last_updated_by%TYPE;

617: v_th_rec IGS_RE_THESIS_HIST%ROWTYPE;
618: v_create_history BOOLEAN := FALSE;
619: v_hist_start_dt IGS_RE_THESIS.last_update_date%TYPE;
620: v_hist_end_dt IGS_RE_THESIS.last_update_date%TYPE;
621: v_hist_who IGS_RE_THESIS.last_updated_by%TYPE;
622: BEGIN
623: -- If any of the old values (p_old_) are different from the
624: -- associated new values (p_new_) (with the exception the
625: -- last_updated_by and last_update_date columns) then create an IGS_RE_THESIS_HIST history

Line 625: -- last_updated_by and last_update_date columns) then create an IGS_RE_THESIS_HIST history

621: v_hist_who IGS_RE_THESIS.last_updated_by%TYPE;
622: BEGIN
623: -- If any of the old values (p_old_) are different from the
624: -- associated new values (p_new_) (with the exception the
625: -- last_updated_by and last_update_date columns) then create an IGS_RE_THESIS_HIST history
626: -- record with the old values (p_old_). Do not set the
627: -- last_updated_by and last_update_date columns when creating the history record.
628: IF p_new_title <> p_old_title THEN
629: v_th_rec.title := p_old_title;

Line 703: IGS_RE_THESIS_HIST_PKG.INSERT_ROW(

699: v_th_rec.sequence_number := p_sequence_number;
700: v_th_rec.hist_start_dt := p_old_update_on;
701: v_th_rec.hist_end_dt := NVL(p_new_update_on,SYSDATE);
702: v_th_rec.hist_who := p_old_update_who;
703: IGS_RE_THESIS_HIST_PKG.INSERT_ROW(
704: X_ROWID => LV_ROWID,
705: X_person_id => v_th_rec.person_id,
706: X_ca_sequence_number => v_th_rec.ca_sequence_number,
707: X_sequence_number => v_th_rec.sequence_number,