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.HZ_CREDIT_USAGE_RULES_PKG SQL Statements

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

Line: 23


PROCEDURE Insert_row
( p_row_id IN OUT  NOCOPY           VARCHAR2
, p_credit_usage_rule_set_id   NUMBER
, p_credit_usage_rule_id       NUMBER
, p_usage_type                 VARCHAR2
, p_user_code                  VARCHAR2
, p_exclude_flag               VARCHAR2
, p_include_all_flag           VARCHAR2
, 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 usage_rule_csr IS
  SELECT
    rowid
  FROM
    HZ_CREDIT_USAGE_RULES
  WHERE credit_usage_rule_id=p_credit_usage_rule_id;

Line: 64


  INSERT INTO hz_credit_usage_rules
  ( credit_usage_rule_id
  , usage_type
  , user_code
  , exclude_flag
  , include_all_flag
  , credit_usage_rule_set_id
  , creation_date
  , created_by
  , last_update_date
  , last_updated_by
  , last_update_login
  , program_application_id
  , program_id
  , program_update_date
  , request_id
  , attribute_category
  , attribute1
  , attribute2
  , attribute3
  , attribute4
  , attribute5
  , attribute6
  , attribute7
  , attribute8
  , attribute9
  , attribute10
  , attribute11
  , attribute12
  , attribute13
  , attribute14
  , attribute15
  )
  VALUES
  ( p_credit_usage_rule_id
  , p_usage_type
  , p_user_code
  , p_exclude_flag
  , p_include_all_flag
  , p_credit_usage_rule_set_id
  , p_creation_date
  , p_created_by
  , p_last_update_date
  , p_last_updated_by
  , p_last_update_login
  , null
  , null
  , null
  , null
  , 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: 144


       FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Insert_row');

Line: 148


 END Insert_row;

Line: 169


    SELECT *
    FROM HZ_CREDIT_USAGE_RULES
    WHERE ROWID=CHARTOROWID(p_row_id)
    FOR UPDATE OF user_code NOWAIT;

Line: 183


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

Line: 222


PROCEDURE Update_row
( p_row_id                     VARCHAR2
, p_usage_type                 VARCHAR2
, p_user_code                  VARCHAR2
, p_exclude_flag               VARCHAR2
, p_include_all_flag           VARCHAR2
, 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_USAGE_RULES
  SET
    usage_type=p_usage_type
   ,user_code=p_user_code
   ,exclude_flag=p_exclude_flag
   ,include_all_flag=p_include_all_flag
   ,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: 285


       FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Update_row');

Line: 289


  END Update_Row;

Line: 297


PROCEDURE Delete_row
( p_credit_usage_rule_id NUMBER
)
IS
BEGIN
  DELETE
  FROM HZ_CREDIT_USAGE_RULES
  WHERE credit_usage_rule_id=p_credit_usage_rule_id;

Line: 314


       FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Delete_row');

Line: 318


END Delete_row;