APPS.IGS_RE_GEN_003 dependencies on IGS_RE_THS_PNL_MR_HS

Line 769: -- Insert IGS_RE_THS_PNL_MBR history (IGS_RE_THS_PNL_MR_HS)

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;
772: v_create_history BOOLEAN := FALSE;
773: v_hist_start_dt IGS_RE_THS_PNL_MBR.last_update_date%TYPE;

Line 771: v_tpmh_rec IGS_RE_THS_PNL_MR_HS%ROWTYPE;

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;
772: v_create_history BOOLEAN := FALSE;
773: v_hist_start_dt IGS_RE_THS_PNL_MBR.last_update_date%TYPE;
774: v_hist_end_dt IGS_RE_THS_PNL_MBR.last_update_date%TYPE;
775: v_hist_who IGS_RE_THS_PNL_MBR.last_updated_by%TYPE;

Line 829: IGS_RE_THS_PNL_MR_HS_PKG.INSERT_ROW(

825: v_tpmh_rec.person_id := p_person_id;
826: v_tpmh_rec.hist_start_dt := p_old_update_on;
827: v_tpmh_rec.hist_end_dt := NVL(p_new_update_on,SYSDATE);
828: v_tpmh_rec.hist_who := p_old_update_who;
829: IGS_RE_THS_PNL_MR_HS_PKG.INSERT_ROW(
830: X_ROWID => LV_ROWID,
831: X_ca_person_id => v_tpmh_rec.ca_person_id,
832: X_ca_sequence_number => v_tpmh_rec.ca_sequence_number,
833: X_the_sequence_number => v_tpmh_rec.the_sequence_number,