APPS.HZ_CREDIT_PROFILE_AMTS_PKG SQL Statements

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

Line: 27

PROCEDURE Insert_row
( p_row_id             OUT NOCOPY VARCHAR2
, p_credit_profile_amt_id  NUMBER
, p_credit_profile_id      NUMBER
, p_currency_code          VARCHAR2
, p_trx_credit_limit       NUMBER
, p_overall_credit_limit   NUMBER
, p_creation_date          DATE
, p_created_by             NUMBER
, p_last_update_date       DATE
, p_last_updated_by        NUMBER
, p_last_update_login      NUMBER
, p_attribute_category     VARCHAR2
, p_attribute1             VARCHAR2
, p_attribute2             VARCHAR2
, p_attribute3             VARCHAR2
, p_attribute4             VARCHAR2
, p_attribute5             VARCHAR2
, p_attribute6             VARCHAR2
, p_attribute7             VARCHAR2
, p_attribute8             VARCHAR2
, p_attribute9             VARCHAR2
, p_attribute10            VARCHAR2
, p_attribute11            VARCHAR2
, p_attribute12            VARCHAR2
, p_attribute13            VARCHAR2
, p_attribute14            VARCHAR2
, p_attribute15            VARCHAR2
)
IS

CURSOR prof_amt_csr IS
  SELECT
    rowid
  FROM
    hz_credit_profile_amts
  WHERE credit_profile_amt_id=p_credit_profile_amt_id;

Line: 67

  INSERT INTO hz_credit_profile_amts
  ( credit_profile_amt_id
  , credit_profile_id
  , creation_date
  , created_by
  , last_update_date
  , last_updated_by
  , last_update_login
  , program_application_id
  , program_id
  , program_update_date
  , request_id
  , currency_code
  , trx_credit_limit
  , overall_credit_limit
  , attribute_category
  , attribute1
  , attribute2
  , attribute3
  , attribute4
  , attribute5
  , attribute6
  , attribute7
  , attribute8
  , attribute9
  , attribute10
  , attribute11
  , attribute12
  , attribute13
  , attribute14
  , attribute15
  )
  VALUES
  ( p_credit_profile_amt_id
  , p_credit_profile_id
  , p_creation_date
  , p_created_by
  , p_last_update_date
  , p_last_updated_by
  , p_last_update_login
  , null
  , null
  , null
  , null
  , p_currency_code
  , p_trx_credit_limit
  , p_overall_credit_limit
  , p_attribute_category
  , p_attribute1
  , p_attribute2
  , p_attribute3
  , p_attribute4
  , p_attribute5
  , p_attribute6
  , p_attribute7
  , p_attribute8
  , p_attribute9
  , p_attribute10
  , p_attribute11
  , p_attribute12
  , p_attribute13
  , p_attribute14
  , p_attribute15
  );

Line: 145

       FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Insert_row');

Line: 149

 END Insert_row;

Line: 166

, p_last_update_date     DATE
)
IS
  CURSOR prof_csr
  IS
    SELECT *
    FROM hz_credit_profile_amts
    WHERE ROWID=CHARTOROWID(p_row_id)
    FOR UPDATE OF last_update_date NOWAIT;

Line: 185

    FND_MESSAGE.Set_name('FND', 'FORM_RECORD_DELETED');

Line: 223

PROCEDURE Update_row
( p_row_id                 VARCHAR2
, p_credit_profile_amt_id  NUMBER
, p_credit_profile_id      NUMBER
, p_currency_code          VARCHAR2
, p_trx_credit_limit       NUMBER
, p_overall_credit_limit   NUMBER
, p_last_update_date       DATE
, p_last_updated_by        NUMBER
, p_attribute_category     VARCHAR2
, p_attribute1             VARCHAR2
, p_attribute2             VARCHAR2
, p_attribute3             VARCHAR2
, p_attribute4             VARCHAR2
, p_attribute5             VARCHAR2
, p_attribute6             VARCHAR2
, p_attribute7             VARCHAR2
, p_attribute8             VARCHAR2
, p_attribute9             VARCHAR2
, p_attribute10            VARCHAR2
, p_attribute11            VARCHAR2
, p_attribute12            VARCHAR2
, p_attribute13            VARCHAR2
, p_attribute14            VARCHAR2
, p_attribute15            VARCHAR2
)
IS

BEGIN
  UPDATE hz_credit_profile_amts
  SET
    credit_profile_id =p_credit_profile_id
  , currency_code=p_currency_code
  , trx_credit_limit=p_trx_credit_limit
  , overall_credit_limit=p_overall_credit_limit
  , last_update_date=p_last_update_date
  , last_updated_by=p_last_updated_by
  , attribute_category =p_attribute_category
   , attribute1= p_attribute1
   , attribute2= p_attribute2
   , attribute3= p_attribute3
   , attribute4= p_attribute4
   , attribute5= p_attribute5
   , attribute6= p_attribute6
   , attribute7= p_attribute7
   , attribute8= p_attribute8
   , attribute9= p_attribute9
   , attribute10= p_attribute10
   , attribute11= p_attribute11
   , attribute12= p_attribute12
   , attribute13= p_attribute13
   , attribute14= p_attribute14
   , attribute15= p_attribute15
  WHERE ROWID=CHARTOROWID(p_row_id);

Line: 287

       FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Update_row');

Line: 291

END Update_Row;

Line: 300

PROCEDURE Delete_row
( p_row_id VARCHAR2
)
IS
BEGIN
  DELETE
  FROM HZ_CREDIT_PROFILE_AMTS
  WHERE ROWID=CHARTOROWID(p_row_id);

Line: 318

       FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Delete_row');

Line: 322

END Delete_row;

Line: 331

PROCEDURE Delete_rows
( p_credit_profile_id NUMBER
)
IS
BEGIN
  DELETE
  FROM HZ_CREDIT_PROFILE_AMTS
  WHERE credit_profile_id=p_credit_profile_id;

Line: 345

       FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Delete_row');

Line: 349

END Delete_rows;