DBA Data[Home] [Help]

APPS.IGS_FI_INVLN_INT_PKG SQL Statements

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

Line: 34

    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER ,
    x_REC_ACCOUNT_CD    IN VARCHAR2 ,
    x_REV_ACCOUNT_CD    IN VARCHAR2 ,
    x_REC_GL_CCID    IN NUMBER ,
    x_REV_GL_CCID    IN NUMBER ,
    x_ORG_UNIT_CD    IN VARCHAR2 ,
    x_POSTING_ID    IN NUMBER ,
    x_ATTRIBUTE11    IN VARCHAR2 ,
    x_ATTRIBUTE12    IN VARCHAR2 ,
    x_ATTRIBUTE13    IN VARCHAR2 ,
    x_ATTRIBUTE14    IN VARCHAR2 ,
    x_ATTRIBUTE15    IN VARCHAR2 ,
    x_ATTRIBUTE16    IN VARCHAR2 ,
    x_ATTRIBUTE17    IN VARCHAR2 ,
    x_ATTRIBUTE18    IN VARCHAR2 ,
    x_ATTRIBUTE19    IN VARCHAR2 ,
    x_ATTRIBUTE20    IN VARCHAR2 ,
    x_ERROR_STRING   IN VARCHAR2 ,
    x_ERROR_ACCOUNT  IN VARCHAR2 ,
    x_location_cd    IN VARCHAR2 ,
    x_uoo_id         IN NUMBER ,
    x_gl_date                IN     DATE,
    x_gl_posted_date         IN     DATE,
    x_posting_control_id     IN     NUMBER,
    x_unit_type_id           IN     NUMBER,
    x_unit_level             IN     VARCHAR2
  ) AS

  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  svuppala      30-MAY-2005       Enh 3442712 - Added new columns Unit_Type_Id, Unit_Level
  vchappid     23-Dec-2002        Enh#2720702, Error_Account is inserted as 'N' whenever it is found NULL
  smadathi     01-Nov-2002        Enh. Bug 2584986. Added new column GL_DATE,GL_POSTED_DATE,
                                  POSTING_CONTROL_ID. Also removed all DEFAULT CLAUSES
  msrinivi        17 Jul,2001    Added 2 new cols : error_string, error_account
  (reverse chronological order - newest change first)
  ***************************************************************/

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_FI_INVLN_INT_ALL
      WHERE    rowid = x_rowid;
Line: 92

    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Close cur_old_ref_values;
Line: 94

      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 150

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

    new_references.last_update_date  := x_last_update_date;
Line: 158

    new_references.last_updated_by   := x_last_updated_by;
Line: 159

    new_references.last_update_login := x_last_update_login;
Line: 238

      SELECT   rowid
      FROM     igs_fi_invln_int_all
      WHERE    invoice_lines_id = x_invoice_lines_id
      FOR UPDATE NOWAIT;
Line: 281

        Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 293

        Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Line: 307

         Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
Line: 318

      fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
Line: 329

      fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
Line: 354

      SELECT   rowid
      FROM     igs_fi_invln_int_all
      WHERE    invoice_id = x_invoice_id
      AND      line_number = x_line_number      and      ((l_rowid is null) or (rowid <> l_rowid))

      ;
Line: 389

      SELECT   rowid
      FROM     igs_fi_invln_int_all
      WHERE   ((posting_id = x_posting_id));
Line: 424

      SELECT   rowid
      FROM     igs_fi_invln_int_all
      WHERE   ((UOO_ID  = x_UOO_ID ));
Line: 472

    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER ,
    x_REC_ACCOUNT_CD    IN VARCHAR2 ,
    x_REV_ACCOUNT_CD    IN VARCHAR2 ,
    x_REC_GL_CCID    IN NUMBER ,
    x_REV_GL_CCID    IN NUMBER ,
    x_ORG_UNIT_CD    IN VARCHAR2 ,
    x_POSTING_ID    IN NUMBER ,
    x_ATTRIBUTE11    IN VARCHAR2 ,
    x_ATTRIBUTE12    IN VARCHAR2 ,
    x_ATTRIBUTE13    IN VARCHAR2 ,
    x_ATTRIBUTE14    IN VARCHAR2 ,
    x_ATTRIBUTE15    IN VARCHAR2 ,
    x_ATTRIBUTE16    IN VARCHAR2 ,
    x_ATTRIBUTE17    IN VARCHAR2 ,
    x_ATTRIBUTE18    IN VARCHAR2 ,
    x_ATTRIBUTE19    IN VARCHAR2 ,
    x_ATTRIBUTE20    IN VARCHAR2 ,
    x_ERROR_STRING   IN VARCHAR2 ,
    x_ERROR_ACCOUNT  IN VARCHAR2 ,
    x_location_cd    IN VARCHAR2 ,
    x_uoo_id         IN NUMBER   ,
    x_gl_date                IN     DATE,
    x_gl_posted_date         IN     DATE,
    x_posting_control_id     IN     NUMBER,
    x_unit_type_id           IN     NUMBER,
    x_unit_level             IN     VARCHAR2
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  svuppala      30-MAY-2005       Enh 3442712 - Added new columns Unit_Type_Id, Unit_Level
  smadathi     01-Nov-2002        Enh. Bug 2584986. Added new column GL_DATE,GL_POSTED_DATE,
                                  POSTING_CONTROL_ID. Also removed all DEFAULT CLAUSES
  msrinivi        17 Jul,2001    Added 2 new cols : error_string, error_account
  (reverse chronological order - newest change first)
  ***************************************************************/

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_invoice_id,
      x_line_number,
      x_invoice_lines_id,
      x_attribute2,
      x_chg_elements,
      x_amount,
      x_unit_attempt_status,
      x_eftsu,
      x_credit_points,
      x_attribute_category,
      x_attribute1,
      x_s_chg_method_type,
      x_description,
      x_attribute3,
      x_attribute4,
      x_attribute5,
      x_attribute6,
      x_attribute7,
      x_attribute8,
      x_attribute9,
      x_attribute10,
      x_org_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_rec_account_cd,
      x_rev_account_cd,
      x_rec_gl_ccid,
      x_rev_gl_ccid,
      x_org_unit_cd,
      x_posting_id,
      x_attribute11,
      x_attribute12,
      x_attribute13,
      x_attribute14,
      x_attribute15,
      x_attribute16,
      x_attribute17,
      x_attribute18,
      x_attribute19,
      x_attribute20,
      x_error_string,
      x_error_account,
      x_location_cd,
      x_uoo_id,
      x_gl_date,
      x_gl_posted_date,
      x_posting_control_id,
      x_unit_type_id,
      x_unit_level
    );
Line: 574

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      Null;
Line: 586

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      Null;
Line: 591

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      Null;
Line: 594

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
         -- Call all the procedures related to Before Insert.
      IF Get_PK_For_Validation (
                new_references.invoice_lines_id)  THEN
               Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
Line: 604

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;
Line: 607

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;
Line: 632

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      Null;
Line: 635

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      Null;
Line: 638

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

 procedure INSERT_ROW (
       X_ROWID in out NOCOPY VARCHAR2,
       x_INVOICE_ID IN NUMBER,
       x_LINE_NUMBER IN NUMBER,
       x_INVOICE_LINES_ID IN out NOCOPY NUMBER,
       x_ATTRIBUTE2 IN VARCHAR2,
       x_CHG_ELEMENTS IN NUMBER,
       x_AMOUNT IN NUMBER,
       x_UNIT_ATTEMPT_STATUS IN VARCHAR2,
       x_EFTSU IN NUMBER,
       x_CREDIT_POINTS IN NUMBER,
       x_ATTRIBUTE_CATEGORY IN VARCHAR2,
       x_ATTRIBUTE1 IN VARCHAR2,
       x_S_CHG_METHOD_TYPE IN VARCHAR2,
       x_DESCRIPTION IN VARCHAR2,
       x_ATTRIBUTE3 IN VARCHAR2,
       x_ATTRIBUTE4 IN VARCHAR2,
       x_ATTRIBUTE5 IN VARCHAR2,
       x_ATTRIBUTE6 IN VARCHAR2,
       x_ATTRIBUTE7 IN VARCHAR2,
       x_ATTRIBUTE8 IN VARCHAR2,
       x_ATTRIBUTE9 IN VARCHAR2,
       x_ATTRIBUTE10 IN VARCHAR2,
       x_org_id IN NUMBER,
       X_MODE in VARCHAR2 ,
       x_REC_ACCOUNT_CD    IN VARCHAR2,
       x_REV_ACCOUNT_CD    IN VARCHAR2,
       x_REC_GL_CCID    IN NUMBER,
       x_REV_GL_CCID    IN NUMBER,
       x_ORG_UNIT_CD    IN VARCHAR2,
       x_POSTING_ID    IN NUMBER,
       x_ATTRIBUTE11    IN VARCHAR2,
       x_ATTRIBUTE12    IN VARCHAR2,
       x_ATTRIBUTE13    IN VARCHAR2,
       x_ATTRIBUTE14    IN VARCHAR2,
       x_ATTRIBUTE15    IN VARCHAR2,
       x_ATTRIBUTE16    IN VARCHAR2,
       x_ATTRIBUTE17    IN VARCHAR2,
       x_ATTRIBUTE18    IN VARCHAR2,
       x_ATTRIBUTE19    IN VARCHAR2,
       x_ATTRIBUTE20    IN VARCHAR2,
       x_error_string   IN VARCHAR2 ,
       x_error_account  IN VARCHAR2 ,
       x_location_cd    IN VARCHAR2 ,
       x_uoo_id         IN NUMBER ,
       x_gl_date                IN     DATE,
       x_gl_posted_date         IN     DATE,
       x_posting_control_id     IN     NUMBER,
       x_unit_type_id           IN     NUMBER,
       x_unit_level             IN     VARCHAR2
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  smadathi     01-Nov-2002        Enh. Bug 2584986. Added new column GL_DATE,GL_POSTED_DATE,
                                  POSTING_CONTROL_ID. Also removed all DEFAULT CLAUSES
  msrinivi        17 Jul,2001    Added 2 new cols : error_string, error_account
  (reverse chronological order - newest change first)
  ***************************************************************/

    cursor C is select ROWID from IGS_FI_INVLN_INT_ALL
             where                 INVOICE_LINES_ID= X_INVOICE_LINES_ID;
Line: 712

     X_LAST_UPDATE_DATE DATE ;
Line: 713

     X_LAST_UPDATED_BY NUMBER ;
Line: 714

     X_LAST_UPDATE_LOGIN NUMBER ;
Line: 718

     X_PROGRAM_UPDATE_DATE DATE;
Line: 721

     X_LAST_UPDATE_DATE := SYSDATE;
Line: 723

        X_LAST_UPDATED_BY := 1;
Line: 724

        X_LAST_UPDATE_LOGIN := 0;
Line: 726

               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 727

            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;
Line: 730

            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 731

         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;
Line: 741

               X_PROGRAM_UPDATE_DATE:=NULL;
Line: 743

               X_PROGRAM_UPDATE_DATE:=SYSDATE;
Line: 751

          SELECT
            IGS_FI_INVLN_INT_S.nextval
          INTO
            x_invoice_lines_id
          FROM
           dual;
Line: 759

               p_action=>'INSERT',
               x_rowid=>X_ROWID,
               x_invoice_id=>X_INVOICE_ID,
               x_line_number=>X_LINE_NUMBER,
               x_invoice_lines_id=>X_INVOICE_LINES_ID,
               x_attribute2=>X_ATTRIBUTE2,
               x_chg_elements=>X_CHG_ELEMENTS,
               x_amount=>X_AMOUNT,
               x_unit_attempt_status=>X_UNIT_ATTEMPT_STATUS,
               x_eftsu=>X_EFTSU,
               x_credit_points=>X_CREDIT_POINTS,
               x_attribute_category=>X_ATTRIBUTE_CATEGORY,
               x_attribute1=>X_ATTRIBUTE1,
               x_s_chg_method_type=>X_S_CHG_METHOD_TYPE,
               x_description=>X_DESCRIPTION,
               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_org_id=>igs_ge_gen_003.get_org_id,
               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_rec_account_cd=>X_REC_ACCOUNT_CD,
               x_rev_account_cd=>X_REV_ACCOUNT_Cd,
               x_rec_gl_ccid=>X_REC_GL_CCID,
               x_rev_gl_ccid=>X_REV_GL_CCID,
               x_org_unit_cd=>X_ORG_UNIT_CD,
               x_posting_id=>X_POSTING_ID,
               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_error_string => x_error_string,
               x_error_account => x_error_account,
               x_location_cd => x_location_cd,
               x_uoo_id  => x_uoo_id,
               x_gl_date               => x_gl_date,
               x_gl_posted_date        => x_gl_posted_date,
               x_posting_control_id    => x_posting_control_id,
               x_unit_type_id          => x_unit_type_id,
               x_unit_level            => x_unit_level
               );
Line: 815

     INSERT INTO IGS_FI_INVLN_INT_ALL (
                INVOICE_ID
                ,LINE_NUMBER
                ,INVOICE_LINES_ID
                ,ATTRIBUTE2
                ,CHG_ELEMENTS
                ,AMOUNT
                ,UNIT_ATTEMPT_STATUS
                ,EFTSU
                ,CREDIT_POINTS
                ,ATTRIBUTE_CATEGORY
                ,ATTRIBUTE1
                ,S_CHG_METHOD_TYPE
                ,DESCRIPTION
                ,ATTRIBUTE3
                ,ATTRIBUTE4
                ,ATTRIBUTE5
                ,ATTRIBUTE6
                ,ATTRIBUTE7
                ,ATTRIBUTE8
                ,ATTRIBUTE9
                ,ATTRIBUTE10
                ,ORG_ID
                ,CREATION_DATE
                ,CREATED_BY
                ,LAST_UPDATE_DATE
                ,LAST_UPDATED_BY
                ,LAST_UPDATE_LOGIN
                ,REC_ACCOUNT_CD
                ,REV_ACCOUNT_CD
                ,REC_GL_CCID
                ,REV_GL_CCID
                ,ORG_UNIT_CD
                ,POSTING_ID
                ,ATTRIBUTE11
                ,ATTRIBUTE12
                ,ATTRIBUTE13
                ,ATTRIBUTE14
                ,ATTRIBUTE15
                ,ATTRIBUTE16
                ,ATTRIBUTE17
                ,ATTRIBUTE18
                ,ATTRIBUTE19
                ,ATTRIBUTE20
                ,REQUEST_ID
                ,PROGRAM_ID
                ,PROGRAM_APPLICATION_ID
                ,PROGRAM_UPDATE_DATE
                ,error_string
                ,error_account
                ,LOCATION_CD
                ,UOO_ID
                ,GL_DATE
                ,GL_POSTED_DATE
                ,POSTING_CONTROL_ID
                ,UNIT_TYPE_ID
                ,UNIT_LEVEL
        ) VALUES
        (
                 NEW_REFERENCES.INVOICE_ID
                ,NEW_REFERENCES.LINE_NUMBER
                ,NEW_REFERENCES.INVOICE_LINES_ID
                ,NEW_REFERENCES.ATTRIBUTE2
                ,NEW_REFERENCES.CHG_ELEMENTS
                ,NEW_REFERENCES.AMOUNT
                ,NEW_REFERENCES.UNIT_ATTEMPT_STATUS
                ,NEW_REFERENCES.EFTSU
                ,NEW_REFERENCES.CREDIT_POINTS
                ,NEW_REFERENCES.ATTRIBUTE_CATEGORY
                ,NEW_REFERENCES.ATTRIBUTE1
                ,NEW_REFERENCES.S_CHG_METHOD_TYPE
                ,NEW_REFERENCES.DESCRIPTION
                ,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.ORG_ID
                ,X_LAST_UPDATE_DATE
                ,X_LAST_UPDATED_BY
                ,X_LAST_UPDATE_DATE
                ,X_LAST_UPDATED_BY
                ,X_LAST_UPDATE_LOGIN
                ,NEW_REFERENCES.REC_ACCOUNT_CD
                ,NEW_REFERENCES.REV_ACCOUNT_CD
                ,NEW_REFERENCES.REC_GL_CCID
                ,NEW_REFERENCES.REV_GL_CCID
                ,NEW_REFERENCES.ORG_UNIT_CD
                ,NEW_REFERENCES.POSTING_ID
                ,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_REQUEST_ID
                ,X_PROGRAM_ID
                ,X_PROGRAM_APPLICATION_ID
                ,X_PROGRAM_UPDATE_DATE
                ,new_references.error_string
                ,new_references.error_account
                ,NEW_REFERENCES.LOCATION_CD
                ,NEW_REFERENCES.UOO_ID
                ,NEW_REFERENCES.GL_DATE
                ,NEW_REFERENCES.GL_POSTED_DATE
                ,NEW_REFERENCES.POSTING_CONTROL_ID
                ,NEW_REFERENCES.UNIT_TYPE_ID
                ,NEW_REFERENCES.UNIT_LEVEL
              );
Line: 939

                p_action => 'INSERT' ,
                x_rowid => X_ROWID );
Line: 941

end INSERT_ROW;
Line: 1007

   cursor c1 is select

      INVOICE_ID
,      LINE_NUMBER
,      ATTRIBUTE2
,      CHG_ELEMENTS
,      AMOUNT
,      UNIT_ATTEMPT_STATUS
,      EFTSU
,      CREDIT_POINTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      S_CHG_METHOD_TYPE
,      DESCRIPTION
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      REC_ACCOUNT_CD
,      REV_ACCOUNT_CD
,      REC_GL_CCID
,      REV_GL_CCID
,      ORG_UNIT_CD
,      POSTING_ID
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      error_string
,      error_account
,      LOCATION_CD
,      UOO_ID
,      gl_date
,      gl_posted_date
,      posting_control_id
,      unit_type_id
,      unit_level

    from IGS_FI_INVLN_INT_ALL
    where ROWID = X_ROWID
    for update nowait;
Line: 1063

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Line: 1203

 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_INVOICE_ID IN NUMBER,
       x_LINE_NUMBER IN NUMBER,
       x_INVOICE_LINES_ID IN NUMBER,
       x_ATTRIBUTE2 IN VARCHAR2,
       x_CHG_ELEMENTS IN NUMBER,
       x_AMOUNT IN NUMBER,
       x_UNIT_ATTEMPT_STATUS IN VARCHAR2,
       x_EFTSU IN NUMBER,
       x_CREDIT_POINTS IN NUMBER,
       x_ATTRIBUTE_CATEGORY IN VARCHAR2,
       x_ATTRIBUTE1 IN VARCHAR2,
       x_S_CHG_METHOD_TYPE IN VARCHAR2,
       x_DESCRIPTION IN VARCHAR2,
       x_ATTRIBUTE3 IN VARCHAR2,
       x_ATTRIBUTE4 IN VARCHAR2,
       x_ATTRIBUTE5 IN VARCHAR2,
       x_ATTRIBUTE6 IN VARCHAR2,
       x_ATTRIBUTE7 IN VARCHAR2,
       x_ATTRIBUTE8 IN VARCHAR2,
       x_ATTRIBUTE9 IN VARCHAR2,
       x_ATTRIBUTE10 IN VARCHAR2,
       X_MODE in VARCHAR2 ,
       x_REC_ACCOUNT_CD    IN VARCHAR2,
       x_REV_ACCOUNT_CD    IN VARCHAR2,
       x_REC_GL_CCID    IN NUMBER,
       x_REV_GL_CCID    IN NUMBER,
       x_ORG_UNIT_CD    IN VARCHAR2,
       x_POSTING_ID    IN NUMBER,
       x_ATTRIBUTE11    IN VARCHAR2,
       x_ATTRIBUTE12    IN VARCHAR2,
       x_ATTRIBUTE13    IN VARCHAR2,
       x_ATTRIBUTE14    IN VARCHAR2,
       x_ATTRIBUTE15    IN VARCHAR2,
       x_ATTRIBUTE16    IN VARCHAR2,
       x_ATTRIBUTE17    IN VARCHAR2,
       x_ATTRIBUTE18    IN VARCHAR2,
       x_ATTRIBUTE19    IN VARCHAR2,
       x_ATTRIBUTE20    IN VARCHAR2,
       x_error_string   IN VARCHAR2 ,
       x_error_account  IN VARCHAR2 ,
       x_location_cd    IN VARCHAR2 ,
       x_uoo_id         IN NUMBER ,
       x_gl_date                IN     DATE,
       x_gl_posted_date         IN     DATE,
       x_posting_control_id     IN     NUMBER,
       x_unit_type_id           IN     NUMBER,
       x_unit_level             IN     VARCHAR2
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  svuppala      30-MAY-2005       Enh 3442712 - Added new columns Unit_Type_Id, Unit_Level
  vchappid      23-Dec-2002        Bug#2720702,columns Error_String, Error_Account, location_cd, uoo_id
                                  are directly passed to the Update Statement instead of passing as
                                  new_references.error_string etc. Changed to pass as new_references.column_name
  smadathi     01-Nov-2002        Enh. Bug 2584986. Added new column GL_DATE,GL_POSTED_DATE,
                                  POSTING_CONTROL_ID. Also removed all DEFAULT CLAUSES
  msrinivi        17 Jul,2001    Added 2 new cols : error_string, error_account
  (reverse chronological order - newest change first)
  ***************************************************************/

     X_LAST_UPDATE_DATE DATE ;
Line: 1271

     X_LAST_UPDATED_BY NUMBER ;
Line: 1272

     X_LAST_UPDATE_LOGIN NUMBER ;
Line: 1276

     X_PROGRAM_UPDATE_DATE DATE;
Line: 1279

     X_LAST_UPDATE_DATE := SYSDATE;
Line: 1281

        X_LAST_UPDATED_BY := 1;
Line: 1282

        X_LAST_UPDATE_LOGIN := 0;
Line: 1284

               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1285

            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;
Line: 1288

            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 1289

         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;
Line: 1299

                  X_PROGRAM_UPDATE_DATE:=OLD_REFERENCES.PROGRAM_UPDATE_DATE;
Line: 1301

                  X_PROGRAM_UPDATE_DATE:=SYSDATE;
Line: 1309

               p_action             =>'UPDATE',
               x_rowid              =>X_ROWID,
               x_invoice_id         =>X_INVOICE_ID,
               x_line_number        =>X_LINE_NUMBER,
               x_invoice_lines_id   =>X_INVOICE_LINES_ID,
               x_attribute2         =>X_ATTRIBUTE2,
               x_chg_elements       =>X_CHG_ELEMENTS,
               x_amount             =>X_AMOUNT,
               x_unit_attempt_status=>X_UNIT_ATTEMPT_STATUS,
               x_eftsu              =>X_EFTSU,
               x_credit_points      =>X_CREDIT_POINTS,
               x_attribute_category =>X_ATTRIBUTE_CATEGORY,
               x_attribute1         =>X_ATTRIBUTE1,
               x_s_chg_method_type  =>X_S_CHG_METHOD_TYPE,
               x_description        =>X_DESCRIPTION,
               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_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_rec_account_cd     =>X_REC_ACCOUNT_CD,
               x_rev_account_cd     =>X_REV_ACCOUNT_CD,
               x_rec_gl_ccid=>X_REC_GL_CCID,
               x_rev_gl_ccid=>X_REV_GL_CCID,
               x_org_unit_cd=>X_ORG_UNIT_CD,
               x_posting_id=>X_POSTING_ID,
               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_error_string =>x_error_string,
               x_error_account=>x_error_account,
               x_location_cd=>x_location_cd,
               x_uoo_id=>x_uoo_id,
               x_gl_date               => x_gl_date,
               x_gl_posted_date        => x_gl_posted_date,
               x_posting_control_id    => x_posting_control_id ,
               x_unit_type_id          => x_unit_type_id,
               x_unit_level            => x_unit_level
               );
Line: 1364

   update IGS_FI_INVLN_INT_ALL set
      INVOICE_ID =  NEW_REFERENCES.INVOICE_ID,
      LINE_NUMBER =  NEW_REFERENCES.LINE_NUMBER,
      ATTRIBUTE2 =  NEW_REFERENCES.ATTRIBUTE2,
      CHG_ELEMENTS =  NEW_REFERENCES.CHG_ELEMENTS,
      AMOUNT =  NEW_REFERENCES.AMOUNT,
      UNIT_ATTEMPT_STATUS =  NEW_REFERENCES.UNIT_ATTEMPT_STATUS,
      EFTSU =  NEW_REFERENCES.EFTSU,
      CREDIT_POINTS =  NEW_REFERENCES.CREDIT_POINTS,
      ATTRIBUTE_CATEGORY =  NEW_REFERENCES.ATTRIBUTE_CATEGORY,
      ATTRIBUTE1 =  NEW_REFERENCES.ATTRIBUTE1,
      S_CHG_METHOD_TYPE =  NEW_REFERENCES.S_CHG_METHOD_TYPE,
      DESCRIPTION =  NEW_REFERENCES.DESCRIPTION,
      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,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
      REC_ACCOUNT_CD = NEW_REFERENCES.REC_ACCOUNT_CD,
      REV_ACCOUNT_CD = NEW_REFERENCES.REV_ACCOUNT_CD,
      REC_GL_CCID = NEW_REFERENCES.REC_GL_CCID,
      REV_GL_CCID = NEW_REFERENCES.REV_GL_CCID,
      ORG_UNIT_CD = NEW_REFERENCES.ORG_UNIT_CD,
      POSTING_ID = NEW_REFERENCES.POSTING_ID,
      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,
      REQUEST_ID  =  X_REQUEST_ID,
      PROGRAM_ID  =  X_PROGRAM_ID,
      PROGRAM_APPLICATION_ID=X_PROGRAM_APPLICATION_ID,
      PROGRAM_UPDATE_DATE=X_PROGRAM_UPDATE_DATE,
      error_string = new_references.error_string,
      error_account = new_references.error_account,
      location_cd = new_references.location_cd,
      uoo_id = new_references.uoo_id,
      gl_date                           = new_references.gl_date,
      gl_posted_date                    = new_references.gl_posted_date,
      posting_control_id                = new_references.posting_control_id,
      unit_type_id                      = new_references.unit_type_id,
      unit_level                        = new_references.unit_level
      WHERE ROWID = X_ROWID;
Line: 1424

        p_action => 'UPDATE' ,
        x_rowid => X_ROWID
        );
Line: 1427

end UPDATE_ROW;
Line: 1494

    cursor c1 is select ROWID from IGS_FI_INVLN_INT_ALL
             where     INVOICE_LINES_ID= X_INVOICE_LINES_ID
;
Line: 1502

    INSERT_ROW (
      X_ROWID,
       X_INVOICE_ID,
       X_LINE_NUMBER,
       X_INVOICE_LINES_ID,
       X_ATTRIBUTE2,
       X_CHG_ELEMENTS,
       X_AMOUNT,
       X_UNIT_ATTEMPT_STATUS,
       X_EFTSU,
       X_CREDIT_POINTS,
       X_ATTRIBUTE_CATEGORY,
       X_ATTRIBUTE1,
       X_S_CHG_METHOD_TYPE,
       X_DESCRIPTION,
       X_ATTRIBUTE3,
       X_ATTRIBUTE4,
       X_ATTRIBUTE5,
       X_ATTRIBUTE6,
       X_ATTRIBUTE7,
       X_ATTRIBUTE8,
       X_ATTRIBUTE9,
       X_ATTRIBUTE10,
       X_ORG_ID,
       X_MODE,
       X_REC_ACCOUNT_CD,
       X_REV_ACCOUNT_CD,
       X_REC_GL_CCID,
       X_REV_GL_CCID,
       X_ORG_UNIT_CD,
       X_POSTING_ID,
       X_ATTRIBUTE11,
       X_ATTRIBUTE12,
       X_ATTRIBUTE13,
       X_ATTRIBUTE14,
       X_ATTRIBUTE15,
       X_ATTRIBUTE16,
       X_ATTRIBUTE17,
       X_ATTRIBUTE18,
       X_ATTRIBUTE19,
       X_ATTRIBUTE20,
       x_error_string,
       x_error_account,
       X_LOCATION_CD,
       X_UOO_ID,
       x_gl_date,
       x_gl_posted_date,
       x_posting_control_id,
       x_unit_type_id,
       x_unit_level
       );
Line: 1556

UPDATE_ROW (
      X_ROWID,
       X_INVOICE_ID,
       X_LINE_NUMBER,
       X_INVOICE_LINES_ID,
       X_ATTRIBUTE2,
       X_CHG_ELEMENTS,
       X_AMOUNT,
       X_UNIT_ATTEMPT_STATUS,
       X_EFTSU,
       X_CREDIT_POINTS,
       X_ATTRIBUTE_CATEGORY,
       X_ATTRIBUTE1,
       X_S_CHG_METHOD_TYPE,
       X_DESCRIPTION,
       X_ATTRIBUTE3,
       X_ATTRIBUTE4,
       X_ATTRIBUTE5,
       X_ATTRIBUTE6,
       X_ATTRIBUTE7,
       X_ATTRIBUTE8,
       X_ATTRIBUTE9,
       X_ATTRIBUTE10,
       X_MODE,
       X_REC_ACCOUNT_CD,
       X_REV_ACCOUNT_CD,
       X_REC_GL_CCID,
       X_REV_GL_CCID,
       X_ORG_UNIT_CD,
       X_POSTING_ID,
       X_ATTRIBUTE11,
       X_ATTRIBUTE12,
       X_ATTRIBUTE13,
       X_ATTRIBUTE14,
       X_ATTRIBUTE15,
       X_ATTRIBUTE16,
       X_ATTRIBUTE17,
       X_ATTRIBUTE18,
       X_ATTRIBUTE19,
       X_ATTRIBUTE20,
       x_error_string,
       x_error_account,
       X_LOCATION_CD,
       X_UOO_ID,
       x_gl_date,
       x_gl_posted_date,
       x_posting_control_id,
       x_unit_type_id,
       x_unit_level
       );
Line: 1608

procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

begin
Before_DML (
p_action => 'DELETE',
x_rowid => X_ROWID
);
Line: 1627

 delete from IGS_FI_INVLN_INT_ALL
 where ROWID = X_ROWID;
Line: 1633

 p_action => 'DELETE',
 x_rowid => X_ROWID
);
Line: 1636

end DELETE_ROW;