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

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

Line: 44


   SELECT ozf_claim_types_all_b_s.NEXTVAL
     FROM DUAL;

Line: 49


   SELECT  'ANYTHING'
     FROM  ozf_claim_types_VL
     WHERE claim_type_id = cv_claim_type_id;

Line: 102


     OZF_Utility_PVT.debug_message(l_full_name ||': insert');

Line: 122


    OZF_claim_types_All_PKG.INSERT_ROW (
      X_ROWID                   => l_rowid,
      X_CLAIM_TYPE_ID           => l_claim_rec.claim_type_id,
      X_OBJECT_VERSION_NUMBER   => l_object_version_number,
      X_REQUEST_ID              => FND_GLOBAL.conc_request_id,
      X_CREATED_FROM            => NULL,
      X_CLAIM_CLASS             => l_claim_rec.claim_class,
      X_SET_OF_BOOKS_ID         => l_claim_rec.set_of_books_id,
      X_POST_TO_GL_FLAG         => l_claim_rec.post_to_gl_flag,
      X_START_DATE              => l_claim_rec.start_date,
      X_END_DATE                => l_claim_rec.end_date,
      X_CREATION_SIGN           => l_claim_rec.creation_sign,
      X_GL_ID_DED_ADJ           => l_claim_rec.gl_id_ded_adj,
      X_GL_ID_DED_ADJ_CLEARING  => l_claim_rec.gl_id_ded_adj_clearing,
      X_GL_ID_DED_CLEARING      => l_claim_rec.gl_id_ded_clearing,
      X_GL_ID_ACCR_PROMO_LIAB   => l_claim_rec.gl_id_accr_promo_liab,
      X_TRANSACTION_TYPE        => l_claim_rec.transaction_type,
      X_CM_TRX_TYPE_ID          => l_claim_rec.cm_trx_type_id,
      X_DM_TRX_TYPE_ID          => l_claim_rec.dm_trx_type_id,
      X_CB_TRX_TYPE_ID          => l_claim_rec.cb_trx_type_id,
      X_WO_REC_TRX_ID           => l_claim_rec.wo_rec_trx_id,
      X_ADJ_REC_TRX_ID          => l_claim_rec.adj_rec_trx_id,
      X_ATTRIBUTE_CATEGORY      => l_claim_rec.attribute_category,
      X_ATTRIBUTE1              => l_claim_rec.attribute1,
      X_ATTRIBUTE2              => l_claim_rec.attribute2,
      X_ATTRIBUTE3              => l_claim_rec.attribute3,
      X_ATTRIBUTE4              => l_claim_rec.attribute4,
      X_ATTRIBUTE5              => l_claim_rec.attribute5,
      X_ATTRIBUTE6              => l_claim_rec.attribute6,
      X_ATTRIBUTE7              => l_claim_rec.attribute7,
      X_ATTRIBUTE8              => l_claim_rec.attribute8,
      X_ATTRIBUTE9              => l_claim_rec.attribute9,
      X_ATTRIBUTE10             => l_claim_rec.attribute10,
      X_ATTRIBUTE11             => l_claim_rec.attribute11,
      X_ATTRIBUTE12             => l_claim_rec.attribute12,
      X_ATTRIBUTE13             => l_claim_rec.attribute13,
      X_ATTRIBUTE14             => l_claim_rec.attribute14,
      X_ATTRIBUTE15             => l_claim_rec.attribute15,
      X_NAME                    => l_claim_rec.name,
      X_DESCRIPTION             => l_claim_rec.description,
      X_CREATION_DATE           => SYSDATE,
      X_CREATED_BY              => NVL(FND_GLOBAL.user_id, -1),
      X_LAST_UPDATE_DATE        => SYSDATE,
      X_LAST_UPDATED_BY         => NVL(FND_GLOBAL.user_id, -1),
      X_LAST_UPDATE_LOGIN       => NVL(FND_GLOBAL.conc_login_id, -1),
      x_adjustment_type         => l_claim_rec.adjustment_type,
      X_ORDER_TYPE_ID          => l_claim_rec.order_type_id,
      X_NEG_WO_REC_TRX_ID      => l_claim_rec.neg_wo_rec_trx_id,
      X_GL_BALANCING_FLEX_VALUE      => l_claim_rec.gl_balancing_flex_value,
      X_ORG_ID                      => l_claim_rec.org_id  -- R12 Enhancement
    );

Line: 244


PROCEDURE Delete_Claim_Type(
   p_api_version       IN  NUMBER
  ,p_init_msg_list     IN  VARCHAR2 := FND_API.g_false
  ,p_commit            IN  VARCHAR2 := FND_API.g_false

  ,x_return_status     OUT NOCOPY VARCHAR2
  ,x_msg_count         OUT NOCOPY NUMBER
  ,x_msg_data          OUT NOCOPY VARCHAR2

  ,p_claim_type_id     IN  NUMBER
  ,p_claim_org_id      IN  NUMBER
  ,p_object_version    IN  NUMBER
)
IS

   l_api_version CONSTANT NUMBER       := 1.0;

Line: 260


   l_api_name    CONSTANT VARCHAR2(30) := 'Delete_Claim_Type';

Line: 267


   SELECT  COUNT(claim_type_id)
     FROM  ozf_claim_types_VL
     WHERE claim_type_id = cv_claim_type_id
     AND   object_version_number = cv_obj_ver_num;

Line: 273


   SELECT  claim_id
     FROM  ozf_claims
     WHERE claim_type_id = cv_claim_type_id;

Line: 278


   SELECT  utilization_id
     FROM  ozf_funds_utilized_vl
     WHERE adjustment_type_id = cv_adjustment_type_id;

Line: 283


   SELECT approval_detail_id
   FROM   ams_approval_details
   WHERE  approval_object_type = cv_claim_type_id
     AND  approval_object IN ('FUND','CLAM')
     AND  approval_type IN ('BUDGET','CLAIM');

Line: 291


   SAVEPOINT Delete_Claim_Type;

Line: 314


      OZF_Utility_PVT.debug_message(l_full_name ||': delete');

Line: 390


       OZF_claim_types_All_PKG.DELETE_ROW (
           X_CLAIM_TYPE_ID  => p_claim_type_id,
	   X_ORG_ID  => p_claim_org_id
       );

Line: 423


      ROLLBACK TO Delete_Claim_Type;

Line: 432


      ROLLBACK TO Delete_Claim_Type;

Line: 441


      ROLLBACK TO Delete_Claim_Type;

Line: 455


END Delete_Claim_Type;

Line: 465


PROCEDURE Update_Claim_Type(
   p_api_version       IN  NUMBER
  ,p_init_msg_list     IN  VARCHAR2  := FND_API.g_false
  ,p_commit            IN  VARCHAR2  := FND_API.g_false
  ,p_validation_level  IN  NUMBER    := FND_API.g_valid_level_full

  ,x_return_status     OUT NOCOPY VARCHAR2
  ,x_msg_count         OUT NOCOPY NUMBER
  ,x_msg_data          OUT NOCOPY VARCHAR2

  ,p_claim_rec         IN  claim_rec_type
  ,p_mode              IN  VARCHAR2 := 'UPDATE'
  ,x_object_version    OUT NOCOPY NUMBER
)
IS

   l_api_version CONSTANT NUMBER := 1.0;

Line: 482


   l_api_name    CONSTANT VARCHAR2(30) := 'Update_Claim_Type';

Line: 492


   SELECT  COUNT(claim_type_id)
     FROM  ozf_claim_types_VL
     WHERE claim_type_id = cv_claim_type_id
     AND   object_version_number = cv_obj_ver_num;

Line: 500


   SAVEPOINT Update_Claim_Type;

Line: 544


       FND_MESSAGE.set_name('OZF', 'OZF_ADJ_TYPE_NO_UPDATE');

Line: 556


         p_validation_mode => JTF_PLSQL_API.g_update,
         x_return_status   => l_return_status
      );

Line: 585


      OZF_Utility_PVT.debug_message(l_full_name ||': KISH update');

Line: 590


       OZF_claim_types_All_PKG.UPDATE_ROW (
          X_CLAIM_TYPE_ID          => l_claim_rec.claim_type_id,
          X_OBJECT_VERSION_NUMBER  => l_object_version,
          X_REQUEST_ID             => FND_GLOBAL.conc_request_id,
          X_CREATED_FROM           => l_claim_rec.created_from,
          X_CLAIM_CLASS            => l_claim_rec.claim_class,
          X_SET_OF_BOOKS_ID        => l_claim_rec.set_of_books_id,
          X_POST_TO_GL_FLAG        => l_claim_rec.post_to_gl_flag,
          X_START_DATE             => l_claim_rec.start_date,
          X_END_DATE               => l_claim_rec.end_date,
          X_CREATION_SIGN          => l_claim_rec.creation_sign,
          X_GL_ID_DED_ADJ          => l_claim_rec.gl_id_ded_adj,
          X_GL_ID_DED_ADJ_CLEARING => l_claim_rec.gl_id_ded_adj_clearing,
          X_GL_ID_DED_CLEARING     => l_claim_rec.gl_id_ded_clearing,
          X_GL_ID_ACCR_PROMO_LIAB  => l_claim_rec.gl_id_accr_promo_liab,
          X_TRANSACTION_TYPE       => l_claim_rec.transaction_type,
          X_CM_TRX_TYPE_ID         => l_claim_rec.cm_trx_type_id,
          X_DM_TRX_TYPE_ID         => l_claim_rec.dm_trx_type_id,
          X_CB_TRX_TYPE_ID         => l_claim_rec.cb_trx_type_id,
          X_WO_REC_TRX_ID          => l_claim_rec.wo_rec_trx_id,
          X_ADJ_REC_TRX_ID         => l_claim_rec.adj_rec_trx_id,
          X_ATTRIBUTE_CATEGORY     => l_claim_rec.attribute_category,
          X_ATTRIBUTE1             => l_claim_rec.attribute1,
          X_ATTRIBUTE2             => l_claim_rec.attribute2,
          X_ATTRIBUTE3             => l_claim_rec.attribute3,
          X_ATTRIBUTE4             => l_claim_rec.attribute4,
          X_ATTRIBUTE5             => l_claim_rec.attribute5,
          X_ATTRIBUTE6             => l_claim_rec.attribute6,
          X_ATTRIBUTE7             => l_claim_rec.attribute7,
          X_ATTRIBUTE8             => l_claim_rec.attribute8,
          X_ATTRIBUTE9             => l_claim_rec.attribute9,
          X_ATTRIBUTE10            => l_claim_rec.attribute10,
          X_ATTRIBUTE11            => l_claim_rec.attribute11,
          X_ATTRIBUTE12            => l_claim_rec.attribute12,
          X_ATTRIBUTE13            => l_claim_rec.attribute13,
          X_ATTRIBUTE14            => l_claim_rec.attribute14,
          X_ATTRIBUTE15            => l_claim_rec.attribute15,
          X_NAME                   => l_claim_rec.name,
          X_DESCRIPTION            => l_claim_rec.description,
          X_LAST_UPDATE_DATE       => SYSDATE,
          X_LAST_UPDATED_BY        => NVL(FND_GLOBAL.user_id,-1),
          X_LAST_UPDATE_LOGIN      => NVL(FND_GLOBAL.conc_login_id,-1),
          x_adjustment_type        => l_claim_rec.adjustment_type,
          X_ORDER_TYPE_ID         => l_claim_rec.order_type_id,
	  X_NEG_WO_REC_TRX_ID      => l_claim_rec.neg_wo_rec_trx_id,
	  X_GL_BALANCING_FLEX_VALUE  => l_claim_rec.gl_balancing_flex_value,
	  X_ORG_ID                  => l_claim_rec.org_id
       );

Line: 664


      ROLLBACK TO Update_Claim_Type;

Line: 673


      ROLLBACK TO Update_Claim_Type;

Line: 682


      ROLLBACK TO Update_Claim_Type;

Line: 696


END Update_Claim_Type;

Line: 982


      SELECT 1
      FROM oe_transaction_types_vl
      WHERE transaction_type_id = cv_id;

Line: 1235


   SELECT *
     FROM  ozf_claim_types_VL
     WHERE claim_type_id = p_claim_rec.claim_type_id;