APPS.OE_CREDIT_SUMMARIES_PKG SQL Statements

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

Line: 35

    SELECT
        party_id
    INTO
      l_id
    FROM
       HZ_CUST_ACCOUNTS
    WHERE
       cust_account_id = p_cust_account_id ;

Line: 76

PROCEDURE Insert_Row
  ( p_cust_account_id            IN  NUMBER
  , p_org_id                     IN  NUMBER
  , p_site_use_id                IN  NUMBER
  , p_currency_code              IN  VARCHAR2
  , p_balance_type               IN  NUMBER
  , p_balance                    IN  NUMBER
  , p_creation_date              IN  DATE
  , p_created_by                 IN  NUMBER
  , p_last_update_date           IN  DATE
  , p_last_updated_by            IN  NUMBER
  , p_last_update_login          IN  NUMBER
  , p_program_application_id     IN  NUMBER
  , p_program_id                 IN  NUMBER
  , p_program_update_date        IN  DATE
  , p_request_id                 IN  NUMBER
  , p_exposure_source_code       IN  VARCHAR2
  )
IS
l_party_id NUMBER ;

Line: 101

  OE_DEBUG_PUB.ADD('OEXCRSMB - IN Insert row ');

Line: 107

  INSERT INTO oe_credit_summaries (
      cust_account_id
    , org_id
    , site_use_id
    , currency_code
    , balance_type
    , balance
    , creation_date
    , created_by
    , last_update_date
    , last_updated_by
    , last_update_login
    , program_application_id
    , program_id
    , program_update_date
    , request_id
    , exposure_source_code
    , party_id
    , bucket
    , bucket_duration
   )
   VALUES (
      p_cust_account_id
    , p_org_id
    , p_site_use_id
    , p_currency_code
    , p_balance_type
    , p_balance
    , p_creation_date
    , p_created_by
    , p_last_update_date
    , p_last_updated_by
    , p_last_update_login
    , p_program_application_id
    , p_program_id
    , p_program_update_date
    , p_request_id
    , p_exposure_source_code
    , l_party_id
    , -1
    , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
   );

Line: 150

OE_DEBUG_PUB.ADD('OEXCRSMB - OUT NOCOPY Insert row ');

Line: 156

       OE_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Insert_row');

Line: 159

END Insert_row;

Line: 170

PROCEDURE Update_Row
  ( p_row_id                     IN  VARCHAR2
  , p_balance                    IN  NUMBER
  , p_last_update_date           IN  DATE
  , p_last_updated_by            IN  NUMBER
  , p_last_update_login          IN  NUMBER
  , p_program_application_id     IN  NUMBER
  , p_program_id                 IN  NUMBER
  , p_program_update_date        IN  DATE
  , p_request_id                 IN  NUMBER
  )
IS
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line: 186

   OE_DEBUG_PUB.ADD('OEXCRSMB - IN Update row');

Line: 187

  UPDATE oe_credit_summaries
  SET
      balance                  = p_balance
    , last_update_date         = p_last_update_date
    , last_updated_by          = p_last_updated_by
    , last_update_login        = p_last_update_login
    , program_application_id   = p_program_application_id
    , program_id               = p_program_id
    , program_update_date      = p_program_update_date
    , request_id               = p_request_id
  WHERE ROWID = CHARTOROWID(p_row_id);

Line: 199

OE_DEBUG_PUB.ADD('OEXCRSMB - OUT NOCOPY Update row');

Line: 206

       OE_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Update_row');

Line: 209

END Update_Row;

Line: 220

PROCEDURE Delete_Row
  ( p_row_id                     IN  VARCHAR2
  )
IS
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line: 228

  DELETE FROM oe_credit_summaries
  WHERE ROWID = CHARTOROWID(p_row_id);

Line: 234

       OE_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Update_row');

Line: 237

END Delete_Row;