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.

[Home] [Help]

APPS.IGS_RE_GEN_003 dependencies on IGS_RE_THS_EXAM_HIST

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 160: v_teh_rec IGS_RE_THS_EXAM_HIST%ROWTYPE;

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;
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;

Line 168: -- last_updated_by and last_update_date columns) then create an IGS_RE_THS_EXAM_HIST history

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
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

Line 202: IGS_RE_THS_EXAM_HIST_PKG.INSERT_ROW(

198: v_teh_rec.creation_dt := p_creation_dt;
199: v_teh_rec.hist_start_dt := p_old_update_on;
200: v_teh_rec.hist_end_dt := NVL(p_new_update_on,SYSDATE);
201: v_teh_rec.hist_who := p_old_update_who;
202: IGS_RE_THS_EXAM_HIST_PKG.INSERT_ROW(
203: X_ROWID => LV_ROWID,
204: X_person_id => v_teh_rec.person_id,
205: X_ca_sequence_number => v_teh_rec.ca_sequence_number,
206: X_the_sequence_number => v_teh_rec.the_sequence_number,

Line 779: -- last_updated_by and last_update_date columns) then create an IGS_RE_THS_EXAM_HIST history

775: v_hist_who IGS_RE_THS_PNL_MBR.last_updated_by%TYPE;
776: BEGIN
777: -- If any of the old values (p_old_) are different from the
778: -- associated new values (p_new_) (with the exception the
779: -- last_updated_by and last_update_date columns) then create an IGS_RE_THS_EXAM_HIST history
780: -- record with the old values (p_old_). Do not set the
781: -- last_updated_by and last_update_date columns when creating the history record.
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;