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_EN_UNIT_SET_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8


  PROCEDURE beforerowdelete AS
  ------------------------------------------------------------------
    --Created by  : smvk, Oracle India
    --Date created: 03-Jan-2003
    --
    --Purpose: Only planned unit set status are allowed for deletion
    --
    --
    --Known limitations/enhancements and/or remarks:
    --
    --Change History:
    --Who         When            What
    -------------------------------------------------------------------
    CURSOR cur_delete (cp_c_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE,
                       cp_n_version_number igs_en_unit_set_all.version_number%TYPE)
    IS
    SELECT 'x'
      FROM     igs_en_unit_set_all usv,
               igs_en_unit_set_stat uss
      WHERE    usv.unit_set_status = uss.unit_set_status
      AND      uss.s_unit_set_status = 'PLANNED'
      AND      usv.unit_set_cd = cp_c_unit_set_cd
      AND      usv.version_number = cp_n_version_number;

Line: 36


    OPEN  cur_delete (old_references.unit_set_cd,old_references.version_number);

Line: 37


    FETCH cur_delete INTO l_check;

Line: 38


    IF cur_delete%NOTFOUND THEN
      CLOSE cur_delete;

Line: 44


    CLOSE cur_delete;

Line: 45


  END beforerowdelete;

Line: 47


  PROCEDURE beforerowupdate AS
    ------------------------------------------------------------------
    --Created by  : smvk, Oracle India
    --Date created: 03-Jan-2003
    --
    --Purpose: Active/Inactive Unit Set Status can not be changed to Planned Status
    --
    --
    --Known limitations/enhancements and/or remarks:
    --
    --Change History:
    --Who         When            What
    -------------------------------------------------------------------
    CURSOR cur_get_status (cp_c_unit_set_status igs_en_unit_set_stat.unit_set_status%TYPE)
    IS
      SELECT s_unit_set_status
      FROM   igs_en_unit_set_stat
      WHERE  unit_set_status = cp_c_unit_set_status;

Line: 68


    CURSOR cur_check_update (cp_c_unit_set_cd igs_en_unit_set_all.unit_set_cd%TYPE,
                             cp_n_version_number igs_en_unit_set_all.version_number%TYPE)
    IS
      SELECT 'x'
      FROM     igs_en_unit_set_all usv,
               igs_en_unit_set_stat  uss
      WHERE    usv.unit_set_status=uss.unit_set_status
      AND      uss.s_unit_set_status <> 'PLANNED'
      AND      usv.unit_set_cd = cp_c_unit_set_cd
      AND      usv.version_number = cp_n_version_number;

Line: 87


        OPEN cur_check_update(old_references.unit_set_cd,old_references.version_number);

Line: 88


        FETCH cur_check_update INTO l_check;

Line: 89


        IF cur_check_update%FOUND THEN
          CLOSE cur_check_update;

Line: 95


        CLOSE cur_check_update;

Line: 100


      fnd_message.set_name('FND','FORM_RECORD_DELETED');

Line: 104


  END beforerowupdate;

Line: 147


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_org_id IN NUMBER DEFAULT NULL
  ) as

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_EN_UNIT_SET_ALL
      WHERE    rowid = x_rowid;

Line: 166


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 212


    IF (p_action = 'UPDATE') THEN
      new_references.creation_date := old_references.creation_date;

Line: 219


    new_references.last_update_date := x_last_update_date;

Line: 220


    new_references.last_updated_by := x_last_updated_by;

Line: 221


    new_references.last_update_login := x_last_update_login;

Line: 232


  PROCEDURE BeforeRowInsertUpdate1(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) as

      v_message_name  varchar2(30);

Line: 241


	-- Validate that inserts/updates are allowed
	IF  p_inserting THEN
		-- 
		-- Org UNIT inactive validation
		-- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_US.crsp_val_ou_sys_sts
		IF  IGS_PS_VAL_CRV.crsp_val_ou_sys_sts (
						new_references.responsible_org_unit_cd,
						new_references.responsible_ou_start_dt,
						v_message_name) = FALSE THEN
			    Fnd_Message.Set_Name('IGS', v_message_name);

Line: 273


	-- Validate that inserts/updates are allowed
	IF  p_inserting OR p_updating THEN
		-- , , 
		-- Start/Expiry/End date validations
		IF  IGS_PS_VAL_US.crsp_val_ver_dt (
						new_references.start_dt,
						new_references.end_dt,
						new_references.expiry_dt,
						v_message_name,FALSE) = FALSE THEN
			    Fnd_Message.Set_Name('IGS', v_message_name);

Line: 335


  END BeforeRowInsertUpdate1;

Line: 343


  PROCEDURE AfterRowInsertUpdate2(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) as
      v_message_name  varchar2(30);

Line: 361


  END AfterRowInsertUpdate2;

Line: 369


  PROCEDURE AfterRowUpdate3(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) as
      v_message_name  varchar2(30);

Line: 407


			new_references.last_updated_by,
			old_references.last_updated_by,
			new_references.last_update_date,
			old_references.last_update_date);

Line: 414


  END AfterRowUpdate3;

Line: 525


	     Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 542


	     Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 558


	     Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 716


        SELECT   uss.s_unit_set_status
        FROM     igs_en_unit_set_all usv,
                 igs_en_unit_set_stat uss
        WHERE    usv.unit_set_status = uss.unit_set_status
        AND      usv.unit_set_cd = x_unit_set_cd
        AND      usv.version_number = x_version_number;

Line: 726


      SELECT   rowid
      FROM     IGS_EN_UNIT_SET_ALL
      WHERE    unit_set_cd = x_unit_set_cd
      AND      version_number = x_version_number
      FOR UPDATE NOWAIT;

Line: 766


      SELECT   rowid
      FROM     IGS_EN_UNIT_SET_ALL
      WHERE    responsible_org_unit_cd = x_org_unit_cd
      AND      responsible_ou_start_dt = x_start_dt ;

Line: 793


      SELECT   rowid
      FROM     IGS_EN_UNIT_SET_ALL
      WHERE    UNIT_SET_CAT = x_unit_set_cat ;

Line: 819


      SELECT   rowid
      FROM     IGS_EN_UNIT_SET_ALL
      WHERE    UNIT_SET_STATUS = x_unit_set_status ;

Line: 881


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_org_id IN NUMBER
  )  as
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_unit_set_cd,
      x_version_number,
      x_unit_set_status,
      x_unit_set_cat,
      x_start_dt,
      x_review_dt,
      x_expiry_dt,
      x_end_dt,
      x_title,
      x_short_title,
      x_abbreviation,
      x_responsible_org_unit_cd,
      x_responsible_ou_start_dt,
      x_administrative_ind,
      x_authorisation_rqrd_ind,
      x_attribute_category ,
      x_attribute1,
      x_attribute2,
      x_attribute3,
      x_attribute4,
      x_attribute5,
      x_attribute6,
      x_attribute7,
      x_attribute8,
      x_attribute9,
      x_attribute10,
      x_attribute11,
      x_attribute12,
      x_attribute13,
      x_attribute14,
      x_attribute15,
      x_attribute16 ,
      x_attribute17 ,
      x_attribute18 ,
      x_attribute19 ,
      x_attribute20 ,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_org_id
    );

Line: 935


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      BeforeRowInsertUpdate1 ( p_inserting => TRUE );

Line: 951


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      -- Added the call to beforerowupdate as a part of Bug # 2729917
      beforerowupdate;

Line: 955


      BeforeRowInsertUpdate1 ( p_updating => TRUE );

Line: 958


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      -- Added the call to beforerowdelete as a part of Bug # 2729917
      beforerowdelete;

Line: 963


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      		IF  Get_PK_For_Validation (
		          new_references.unit_set_cd,
		          new_references.version_number
				          ) THEN
		         	 Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 973


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      		  Check_Constraints;

Line: 975


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      -- Added the call to beforerowdelete as a part of Bug # 2729917
      beforerowdelete;

Line: 991


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      AfterRowInsertUpdate2 ( p_inserting => TRUE );

Line: 995


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      AfterRowInsertUpdate2 ( p_updating => TRUE );

Line: 998


      AfterRowUpdate3 ( p_updating => TRUE );

Line: 1000


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to After Delete.
      Null;

Line: 1008


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_UNIT_SET_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_UNIT_SET_STATUS in VARCHAR2,
  X_UNIT_SET_CAT in VARCHAR2,
  X_START_DT in DATE,
  X_REVIEW_DT in DATE,
  X_EXPIRY_DT in DATE,
  X_END_DT in DATE,
  X_TITLE in VARCHAR2,
  X_SHORT_TITLE in VARCHAR2,
  X_ABBREVIATION in VARCHAR2,
  X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
  X_RESPONSIBLE_OU_START_DT in DATE,
  X_ADMINISTRATIVE_IND in VARCHAR2,
  X_AUTHORISATION_RQRD_IND in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
  X_MODE in VARCHAR2 default 'R',
    x_org_id IN NUMBER
  )  AS
    cursor C is select ROWID from IGS_EN_UNIT_SET_ALL
      where UNIT_SET_CD = X_UNIT_SET_CD
      and VERSION_NUMBER = X_VERSION_NUMBER;

Line: 1052


    X_LAST_UPDATE_DATE DATE;

Line: 1053


    X_LAST_UPDATED_BY NUMBER;

Line: 1054


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 1056


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 1058


    X_LAST_UPDATED_BY := 1;

Line: 1059


    X_LAST_UPDATE_LOGIN := 0;

Line: 1061


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1062


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 1065


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1066


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 1076


    p_action => 'INSERT',
    x_rowid => x_rowid  ,
    x_unit_set_cd => x_unit_set_cd   ,
    x_version_number => x_version_number ,
    x_unit_set_status => x_unit_set_status ,
    x_unit_set_cat => x_unit_set_cat  ,
    x_start_dt => x_start_dt ,
    x_review_dt => x_review_dt ,
    x_expiry_dt => x_expiry_dt ,
    x_end_dt => x_end_dt ,
    x_title => x_title  ,
    x_short_title => x_short_title ,
    x_abbreviation => x_abbreviation ,
    x_responsible_org_unit_cd => x_responsible_org_unit_cd ,
    x_responsible_ou_start_dt => x_responsible_ou_start_dt ,
    x_administrative_ind => NVL(X_ADMINISTRATIVE_IND,'N') ,
    x_authorisation_rqrd_ind=> NVL(X_AUTHORISATION_RQRD_IND,'N') ,
    x_attribute_category => x_attribute_category,
    x_attribute1 => x_attribute1,
    x_attribute2 => x_attribute2,
    x_attribute3 => x_attribute3,
    x_attribute4 => x_attribute4,
    x_attribute5 => x_attribute5,
    x_attribute6 => x_attribute6,
    x_attribute7 => x_attribute7,
    x_attribute8 => x_attribute8,
    x_attribute9 => x_attribute9,
    x_attribute10 => x_attribute10,
    x_attribute11 => x_attribute11,
    x_attribute12 => x_attribute12,
    x_attribute13 => x_attribute13,
    x_attribute14 => x_attribute14,
    x_attribute15 => x_attribute15,
    x_attribute16 => x_attribute16,
    x_attribute17 => x_attribute17,
    x_attribute18 => x_attribute18,
    x_attribute19 => x_attribute19,
    x_attribute20 => x_attribute20,
    x_creation_date => x_last_update_date ,
    x_created_by => x_last_updated_by,
    x_last_update_date => x_last_update_date,
    x_last_updated_by => x_last_updated_by,
    x_last_update_login => x_last_update_login ,
    x_org_id => igs_ge_gen_003.get_org_id
  );

Line: 1122


  insert into IGS_EN_UNIT_SET_ALL (
    UNIT_SET_CD,
    VERSION_NUMBER,
    UNIT_SET_STATUS,
    UNIT_SET_CAT,
    START_DT,
    REVIEW_DT,
    EXPIRY_DT,
    END_DT,
    TITLE,
    SHORT_TITLE,
    ABBREVIATION,
    RESPONSIBLE_ORG_UNIT_CD,
    RESPONSIBLE_OU_START_DT,
    ADMINISTRATIVE_IND,
    AUTHORISATION_RQRD_IND,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE16,
    ATTRIBUTE17,
    ATTRIBUTE18,
    ATTRIBUTE19,
    ATTRIBUTE20,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    org_id
  ) values (
    NEW_REFERENCES.UNIT_SET_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.UNIT_SET_STATUS,
    NEW_REFERENCES.UNIT_SET_CAT,
    NEW_REFERENCES.START_DT,
    NEW_REFERENCES.REVIEW_DT,
    NEW_REFERENCES.EXPIRY_DT,
    NEW_REFERENCES.END_DT,
    NEW_REFERENCES.TITLE,
    NEW_REFERENCES.SHORT_TITLE,
    NEW_REFERENCES.ABBREVIATION,
    NEW_REFERENCES.RESPONSIBLE_ORG_UNIT_CD,
    NEW_REFERENCES.RESPONSIBLE_OU_START_DT,
    NEW_REFERENCES.ADMINISTRATIVE_IND,
    NEW_REFERENCES.AUTHORISATION_RQRD_IND,
    NEW_REFERENCES.ATTRIBUTE_CATEGORY,
    NEW_REFERENCES.ATTRIBUTE1,
    NEW_REFERENCES.ATTRIBUTE2,
    NEW_REFERENCES.ATTRIBUTE3,
    NEW_REFERENCES.ATTRIBUTE4,
    NEW_REFERENCES.ATTRIBUTE5,
    NEW_REFERENCES.ATTRIBUTE6,
    NEW_REFERENCES.ATTRIBUTE7,
    NEW_REFERENCES.ATTRIBUTE8,
    NEW_REFERENCES.ATTRIBUTE9,
    NEW_REFERENCES.ATTRIBUTE10,
    NEW_REFERENCES.ATTRIBUTE11,
    NEW_REFERENCES.ATTRIBUTE12,
    NEW_REFERENCES.ATTRIBUTE13,
    NEW_REFERENCES.ATTRIBUTE14,
    NEW_REFERENCES.ATTRIBUTE15,
    NEW_REFERENCES.ATTRIBUTE16,
    NEW_REFERENCES.ATTRIBUTE17,
    NEW_REFERENCES.ATTRIBUTE18,
    NEW_REFERENCES.ATTRIBUTE19,
    NEW_REFERENCES.ATTRIBUTE20,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    NEW_REFERENCES.org_id
  );

Line: 1219


	p_action => 'INSERT',
	x_rowid => X_ROWID
  );

Line: 1222


end INSERT_ROW;

Line: 1264


  cursor c1 is select
      UNIT_SET_STATUS,
      UNIT_SET_CAT,
      START_DT,
      REVIEW_DT,
      EXPIRY_DT,
      END_DT,
      TITLE,
      SHORT_TITLE,
      ABBREVIATION,
      RESPONSIBLE_ORG_UNIT_CD,
      RESPONSIBLE_OU_START_DT,
      ADMINISTRATIVE_IND,
      AUTHORISATION_RQRD_IND,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20
    from IGS_EN_UNIT_SET_ALL
    where ROWID = X_ROWID
    for update nowait;

Line: 1308


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 1391


procedure UPDATE_ROW (
  X_ROWID IN VARCHAR2,
  X_UNIT_SET_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_UNIT_SET_STATUS in VARCHAR2,
  X_UNIT_SET_CAT in VARCHAR2,
  X_START_DT in DATE,
  X_REVIEW_DT in DATE,
  X_EXPIRY_DT in DATE,
  X_END_DT in DATE,
  X_TITLE in VARCHAR2,
  X_SHORT_TITLE in VARCHAR2,
  X_ABBREVIATION in VARCHAR2,
  X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
  X_RESPONSIBLE_OU_START_DT in DATE,
  X_ADMINISTRATIVE_IND in VARCHAR2,
  X_AUTHORISATION_RQRD_IND in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
  X_MODE in VARCHAR2 default 'R'
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 1432


    X_LAST_UPDATED_BY NUMBER;

Line: 1433


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 1435


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 1437


    X_LAST_UPDATED_BY := 1;

Line: 1438


    X_LAST_UPDATE_LOGIN := 0;

Line: 1440


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1441


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 1444


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1445


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 1455


    p_action => 'UPDATE' ,
    x_rowid =>  x_rowid,
    x_unit_set_cd => x_unit_set_cd ,
    x_version_number => x_version_number ,
    x_unit_set_status => x_unit_set_status ,
    x_unit_set_cat => x_unit_set_cat ,
    x_start_dt =>  x_start_dt,
    x_review_dt => x_review_dt ,
    x_expiry_dt => x_expiry_dt ,
    x_end_dt =>  x_end_dt ,
    x_title => x_title ,
    x_short_title => x_short_title ,
    x_abbreviation => x_abbreviation ,
    x_responsible_org_unit_cd => x_responsible_org_unit_cd ,
    x_responsible_ou_start_dt => x_responsible_ou_start_dt ,
    x_administrative_ind => x_administrative_ind ,
    x_authorisation_rqrd_ind => x_authorisation_rqrd_ind ,
    x_attribute_category => x_attribute_category,
    x_attribute1 => x_attribute1,
    x_attribute2 => x_attribute2,
    x_attribute3 => x_attribute3,
    x_attribute4 => x_attribute4,
    x_attribute5 => x_attribute5,
    x_attribute6 => x_attribute6,
    x_attribute7 => x_attribute7,
    x_attribute8 => x_attribute8,
    x_attribute9 => x_attribute9,
    x_attribute10 => x_attribute10,
    x_attribute11 => x_attribute11,
    x_attribute12 => x_attribute12,
    x_attribute13 => x_attribute13,
    x_attribute14 => x_attribute14,
    x_attribute15 => x_attribute15,
    x_attribute16 => x_attribute16,
    x_attribute17 => x_attribute17,
    x_attribute18 => x_attribute18,
    x_attribute19 => x_attribute19,
    x_attribute20 => x_attribute20,
    x_creation_date => x_last_update_date ,
    x_created_by => x_last_updated_by ,
    x_last_update_date =>  x_last_update_date,
    x_last_updated_by => x_last_updated_by ,
    x_last_update_login => x_last_update_login
  );

Line: 1500


  update IGS_EN_UNIT_SET_ALL set
    UNIT_SET_STATUS = NEW_REFERENCES.UNIT_SET_STATUS,
    UNIT_SET_CAT = NEW_REFERENCES.UNIT_SET_CAT,
    START_DT = NEW_REFERENCES.START_DT,
    REVIEW_DT = NEW_REFERENCES.REVIEW_DT,
    EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
    END_DT = NEW_REFERENCES.END_DT,
    TITLE = NEW_REFERENCES.TITLE,
    SHORT_TITLE = NEW_REFERENCES.SHORT_TITLE,
    ABBREVIATION = NEW_REFERENCES.ABBREVIATION,
    RESPONSIBLE_ORG_UNIT_CD = NEW_REFERENCES.RESPONSIBLE_ORG_UNIT_CD,
    RESPONSIBLE_OU_START_DT = NEW_REFERENCES.RESPONSIBLE_OU_START_DT,
    ADMINISTRATIVE_IND = NEW_REFERENCES.ADMINISTRATIVE_IND,
    AUTHORISATION_RQRD_IND = NEW_REFERENCES.AUTHORISATION_RQRD_IND,
    ATTRIBUTE_CATEGORY = NEW_REFERENCES.ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = NEW_REFERENCES.ATTRIBUTE1,
    ATTRIBUTE2 = NEW_REFERENCES.ATTRIBUTE2,
    ATTRIBUTE3 = NEW_REFERENCES.ATTRIBUTE3,
    ATTRIBUTE4 = NEW_REFERENCES.ATTRIBUTE4,
    ATTRIBUTE5 = NEW_REFERENCES.ATTRIBUTE5,
    ATTRIBUTE6 = NEW_REFERENCES.ATTRIBUTE6,
    ATTRIBUTE7 = NEW_REFERENCES.ATTRIBUTE7,
    ATTRIBUTE8 = NEW_REFERENCES.ATTRIBUTE8,
    ATTRIBUTE9 = NEW_REFERENCES.ATTRIBUTE9,
    ATTRIBUTE10 = NEW_REFERENCES.ATTRIBUTE10,
    ATTRIBUTE11 = NEW_REFERENCES.ATTRIBUTE11,
    ATTRIBUTE12 = NEW_REFERENCES.ATTRIBUTE12,
    ATTRIBUTE13 = NEW_REFERENCES.ATTRIBUTE13,
    ATTRIBUTE14 = NEW_REFERENCES.ATTRIBUTE14,
    ATTRIBUTE15 = NEW_REFERENCES.ATTRIBUTE15,
    ATTRIBUTE16 = NEW_REFERENCES.ATTRIBUTE16,
    ATTRIBUTE17 = NEW_REFERENCES.ATTRIBUTE17,
    ATTRIBUTE18 = NEW_REFERENCES.ATTRIBUTE18,
    ATTRIBUTE19 = NEW_REFERENCES.ATTRIBUTE19,
    ATTRIBUTE20 = NEW_REFERENCES.ATTRIBUTE20,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

  where ROWID = X_ROWID
  ;

Line: 1546


    p_action => 'UPDATE',
    x_rowid => X_ROWID
  );

Line: 1550


end UPDATE_ROW;

Line: 1593


  cursor c1 is select rowid from IGS_EN_UNIT_SET_ALL
     where UNIT_SET_CD = X_UNIT_SET_CD
     and VERSION_NUMBER = X_VERSION_NUMBER;

Line: 1602


    INSERT_ROW (
     X_ROWID,
     X_UNIT_SET_CD,
     X_VERSION_NUMBER,
     X_UNIT_SET_STATUS,
     X_UNIT_SET_CAT,
     X_START_DT,
     X_REVIEW_DT,
     X_EXPIRY_DT,
     X_END_DT,
     X_TITLE,
     X_SHORT_TITLE,
     X_ABBREVIATION,
     X_RESPONSIBLE_ORG_UNIT_CD,
     X_RESPONSIBLE_OU_START_DT,
     X_ADMINISTRATIVE_IND,
     X_AUTHORISATION_RQRD_IND,
     X_ATTRIBUTE_CATEGORY ,
     X_ATTRIBUTE1 ,
     X_ATTRIBUTE2 ,
     X_ATTRIBUTE3 ,
     X_ATTRIBUTE4 ,
     X_ATTRIBUTE5 ,
     X_ATTRIBUTE6 ,
     X_ATTRIBUTE7 ,
     X_ATTRIBUTE8 ,
     X_ATTRIBUTE9 ,
     X_ATTRIBUTE10,
     X_ATTRIBUTE11 ,
     X_ATTRIBUTE12 ,
     X_ATTRIBUTE13 ,
     X_ATTRIBUTE14 ,
     X_ATTRIBUTE15 ,
     X_ATTRIBUTE16 ,
     X_ATTRIBUTE17 ,
     X_ATTRIBUTE18 ,
     X_ATTRIBUTE19 ,
     X_ATTRIBUTE20 ,
     X_MODE,
     x_org_id);

Line: 1645


  UPDATE_ROW (
   X_ROWID,
   X_UNIT_SET_CD,
   X_VERSION_NUMBER,
   X_UNIT_SET_STATUS,
   X_UNIT_SET_CAT,
   X_START_DT,
   X_REVIEW_DT,
   X_EXPIRY_DT,
   X_END_DT,
   X_TITLE,
   X_SHORT_TITLE,
   X_ABBREVIATION,
   X_RESPONSIBLE_ORG_UNIT_CD,
   X_RESPONSIBLE_OU_START_DT,
   X_ADMINISTRATIVE_IND,
   X_AUTHORISATION_RQRD_IND,
   X_ATTRIBUTE_CATEGORY ,
   X_ATTRIBUTE1 ,
   X_ATTRIBUTE2 ,
   X_ATTRIBUTE3 ,
   X_ATTRIBUTE4 ,
   X_ATTRIBUTE5 ,
   X_ATTRIBUTE6 ,
   X_ATTRIBUTE7 ,
   X_ATTRIBUTE8 ,
   X_ATTRIBUTE9 ,
   X_ATTRIBUTE10,
   X_ATTRIBUTE11 ,
   X_ATTRIBUTE12 ,
   X_ATTRIBUTE13 ,
   X_ATTRIBUTE14 ,
   X_ATTRIBUTE15 ,
   X_ATTRIBUTE16 ,
   X_ATTRIBUTE17 ,
   X_ATTRIBUTE18 ,
   X_ATTRIBUTE19 ,
   X_ATTRIBUTE20 ,
   X_MODE);

Line: 1686


procedure DELETE_ROW (
  X_ROWID IN VARCHAR2
) as
begin
  Before_DML(
    p_action => 'DELETE',
    x_rowid => X_ROWID
  );

Line: 1694


  delete from IGS_EN_UNIT_SET_ALL
  where ROWID = X_ROWID;

Line: 1701


    p_action => 'DELETE',
    x_rowid => X_ROWID
  );

Line: 1704


end DELETE_ROW;