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_PR_MILESTONE_HST

Line 38: v_org_id IGS_PR_MILESTONE_HST.ORG_ID%TYPE := IGS_GE_GEN_003.Get_Org_Id;

34: p_new_update_on IN DATE )
35: AS
36: gv_other_detail VARCHAR2(255);
37: lv_rowid VARCHAR2(25);
38: v_org_id IGS_PR_MILESTONE_HST.ORG_ID%TYPE := IGS_GE_GEN_003.Get_Org_Id;
39:
40: BEGIN -- resp_ins_mil_hist
41: -- Insert IGS_PR_MILESTONE history(IGS_PR_MILESTONE_HST)
42: DECLARE

Line 41: -- Insert IGS_PR_MILESTONE history(IGS_PR_MILESTONE_HST)

37: lv_rowid VARCHAR2(25);
38: v_org_id IGS_PR_MILESTONE_HST.ORG_ID%TYPE := IGS_GE_GEN_003.Get_Org_Id;
39:
40: BEGIN -- resp_ins_mil_hist
41: -- Insert IGS_PR_MILESTONE history(IGS_PR_MILESTONE_HST)
42: DECLARE
43: v_mil_rec IGS_PR_MILESTONE_HST%ROWTYPE;
44: v_create_history BOOLEAN := FALSE;
45: BEGIN

Line 43: v_mil_rec IGS_PR_MILESTONE_HST%ROWTYPE;

39:
40: BEGIN -- resp_ins_mil_hist
41: -- Insert IGS_PR_MILESTONE history(IGS_PR_MILESTONE_HST)
42: DECLARE
43: v_mil_rec IGS_PR_MILESTONE_HST%ROWTYPE;
44: v_create_history BOOLEAN := FALSE;
45: BEGIN
46: -- If any of the old values (p_old_) are
47: -- different from the associated new values (p_new_)

Line 49: -- then create a IGS_PR_MILESTONE_HST history record with the old values

45: BEGIN
46: -- If any of the old values (p_old_) are
47: -- different from the associated new values (p_new_)
48: -- (with the exception of the last_update_date and last_updated_by columns)
49: -- then create a IGS_PR_MILESTONE_HST history record with the old values
50: -- (p_old_). Do not set the last_updated_by and last_update_date
51: -- columns when creating the history record.
52: IF p_new_milestone_type <> p_old_milestone_type THEN
53: v_mil_rec.milestone_type := p_old_milestone_type;

Line 104: IGS_PR_MILESTONE_HST_PKG.INSERT_ROW(

100: v_mil_rec.sequence_number := p_sequence_number;
101: v_mil_rec.hist_start_dt := p_old_update_on;
102: v_mil_rec.hist_end_dt := p_new_update_on;
103: v_mil_rec.hist_who := p_old_update_who;
104: IGS_PR_MILESTONE_HST_PKG.INSERT_ROW(
105: X_ROWID => LV_ROWID,
106: X_person_id => v_mil_rec.person_id,
107: X_ca_sequence_number => v_mil_rec.ca_sequence_number,
108: X_sequence_number => v_mil_rec.sequence_number,

Line 156: v_org_id IGS_PR_MILESTONE_HST.ORG_ID%TYPE := IGS_GE_GEN_003.Get_Org_Id;

152: p_new_update_on IN DATE )
153: AS
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;

Line 612: v_org_id IGS_PR_MILESTONE_HST.ORG_ID%TYPE := IGS_GE_GEN_003.Get_Org_Id;

608: p_new_update_on IN DATE )
609: AS
610: gv_other_detail VARCHAR2(255);
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

Line 767: v_org_id IGS_PR_MILESTONE_HST.ORG_ID%TYPE := IGS_GE_GEN_003.Get_Org_Id;

763: p_new_update_on IN DATE )
764: AS
765: gv_other_detail VARCHAR2(255);
766: LV_ROWID VARCHAR2(25);
767: v_org_id IGS_PR_MILESTONE_HST.ORG_ID%TYPE := IGS_GE_GEN_003.Get_Org_Id;
768: BEGIN -- resp_ins_tpm_hist
769: -- Insert IGS_RE_THS_PNL_MBR history (IGS_RE_THS_PNL_MR_HS)
770: DECLARE
771: v_tpmh_rec IGS_RE_THS_PNL_MR_HS%ROWTYPE;