APPS.IGS_PS_GEN_006 dependencies on IGS_EN_UNIT_SET_HIST

Line 867: -- Insert a IGS_EN_UNIT_SET_HIST record. This routine also gets descriptions from

863: p_old_update_on IN DATE )
864: AS
865: lv_param_values VARCHAR2(1080);
866: BEGIN -- crsp_ins_us_hist
867: -- Insert a IGS_EN_UNIT_SET_HIST record. This routine also gets descriptions from
868: -- relevant reference data records for historical purposes.
869: DECLARE
870:
871: v_ush_rec IGS_EN_UNIT_SET_HIST%ROWTYPE;

Line 871: v_ush_rec IGS_EN_UNIT_SET_HIST%ROWTYPE;

867: -- Insert a IGS_EN_UNIT_SET_HIST record. This routine also gets descriptions from
868: -- relevant reference data records for historical purposes.
869: DECLARE
870:
871: v_ush_rec IGS_EN_UNIT_SET_HIST%ROWTYPE;
872: v_create_history BOOLEAN := FALSE;
873: v_hist_start_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
874: v_hist_end_dt IGS_EN_UNIT_SET.LAST_UPDATE_DATE%TYPE;
875: v_hist_who IGS_EN_UNIT_SET.LAST_UPDATED_BY%TYPE;

Line 888: -- IGS_EN_UNIT_SET_HIST history record with the old IGS_EN_UNIT_SET values

884: BEGIN
885: -- If any of the old IGS_EN_UNIT_SET values (p_old_) are different from
886: -- the associated new IGS_EN_UNIT_SET values (p_new_) (with the
887: -- exception of the LAST_UPDATED_BY and LAST_UPDATE_DATE columns) then create a
888: -- IGS_EN_UNIT_SET_HIST history record with the old IGS_EN_UNIT_SET values
889: -- (p_old_). Only write the changed values to the history
890: -- record. Do not set the LAST_UPDATED_BY and LAST_UPDATE_DATE columns when creating the
891: -- history record.
892: IF p_new_unit_set_status <> p_old_unit_set_status THEN

Line 990: IGS_EN_UNIT_SET_HIST_PKG.Insert_Row(

986: END IF;
987:
988: l_org_id := igs_ge_gen_003.get_org_id;
989:
990: IGS_EN_UNIT_SET_HIST_PKG.Insert_Row(
991: X_ROWID => x_rowid,
992: X_UNIT_SET_CD => v_ush_rec.unit_set_cd,
993: X_VERSION_NUMBER => v_ush_rec.version_number,
994: X_HIST_START_DT => v_ush_rec.hist_start_dt,