DBA Data[Home] [Help]

APPS.IGS_RE_GEN_003 dependencies on IGS_RE_THESIS_EXAM

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