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_CLAIMS_HISTORY_PVT SQL Statements

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

Line: 13


G_UPDATE_EVENT       CONSTANT VARCHAR2(30) := 'UPDATE';

Line: 63


SELECT * FROM ozf_claims_history_all
WHERE claim_history_id = p_id;

Line: 1022


        OZF_claims_history_PKG.Insert_Row(
          px_CLAIM_HISTORY_ID       => l_claim_history_id,
          px_OBJECT_VERSION_NUMBER  => l_object_version_number,
          p_LAST_UPDATE_DATE        => SYSDATE,
          p_LAST_UPDATED_BY         => FND_GLOBAL.USER_ID,
          p_CREATION_DATE           => SYSDATE,
          p_CREATED_BY              => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_LOGIN       => FND_GLOBAL.CONC_LOGIN_ID,
          p_REQUEST_ID              => p_CLAIMS_HISTORY_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => p_CLAIMS_HISTORY_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_UPDATE_DATE     => p_CLAIMS_HISTORY_rec.PROGRAM_UPDATE_DATE,
          p_PROGRAM_ID              => p_CLAIMS_HISTORY_rec.PROGRAM_ID,
          p_CREATED_FROM            => p_CLAIMS_HISTORY_rec.CREATED_FROM,
          p_BATCH_ID                => p_CLAIMS_HISTORY_rec.BATCH_ID,
          p_CLAIM_ID                => p_CLAIMS_HISTORY_rec.CLAIM_ID,
          p_CLAIM_NUMBER            => p_CLAIMS_HISTORY_rec.CLAIM_NUMBER,
          p_CLAIM_TYPE_ID           => p_CLAIMS_HISTORY_rec.CLAIM_TYPE_ID,
          p_CLAIM_CLASS             => p_CLAIMS_HISTORY_REC.CLAIM_CLASS,
	       p_CLAIM_DATE              => p_CLAIMS_HISTORY_rec.CLAIM_DATE,
          p_DUE_DATE                => p_CLAIMS_HISTORY_rec.DUE_DATE,
          p_OWNER_ID                => p_CLAIMS_HISTORY_rec.OWNER_ID,
          p_HISTORY_EVENT           => p_CLAIMS_HISTORY_rec.HISTORY_EVENT,
          p_HISTORY_EVENT_DATE      => p_CLAIMS_HISTORY_rec.HISTORY_EVENT_DATE,
          p_HISTORY_EVENT_DESCRIPTION => p_CLAIMS_HISTORY_rec.HISTORY_EVENT_DESCRIPTION,
          p_SPLIT_FROM_CLAIM_ID     => p_CLAIMS_HISTORY_rec.SPLIT_FROM_CLAIM_ID,
          p_duplicate_claim_id  => p_claims_history_rec.duplicate_claim_id,
	       p_SPLIT_DATE              => p_CLAIMS_HISTORY_rec.SPLIT_DATE,
          p_ROOT_CLAIM_ID           => p_claims_history_rec.ROOT_CLAIM_ID,
          p_AMOUNT                  => p_CLAIMS_HISTORY_rec.AMOUNT,
          p_AMOUNT_ADJUSTED         => p_CLAIMS_HISTORY_rec.AMOUNT_ADJUSTED,
          p_AMOUNT_REMAINING        => p_CLAIMS_HISTORY_rec.AMOUNT_REMAINING,
          p_AMOUNT_SETTLED          => p_CLAIMS_HISTORY_rec.AMOUNT_SETTLED,
          p_ACCTD_AMOUNT            => p_CLAIMS_HISTORY_rec.ACCTD_AMOUNT,
	       p_acctd_amount_remaining  => p_claims_history_rec.acctd_amount_remaining,
          p_acctd_AMOUNT_ADJUSTED   => p_CLAIMS_HISTORY_rec.acctd_AMOUNT_ADJUSTED,
          p_acctd_AMOUNT_SETTLED    => p_CLAIMS_HISTORY_rec.acctd_AMOUNT_SETTLED,
          p_tax_amount  => p_claims_history_rec.tax_amount,
          p_tax_code  => p_claims_history_rec.tax_code,
          p_tax_calculation_flag  => p_claims_history_rec.tax_calculation_flag,
          p_CURRENCY_CODE           => p_CLAIMS_HISTORY_rec.CURRENCY_CODE,
          p_EXCHANGE_RATE_TYPE      => p_CLAIMS_HISTORY_rec.EXCHANGE_RATE_TYPE,
          p_EXCHANGE_RATE_DATE      => p_CLAIMS_HISTORY_rec.EXCHANGE_RATE_DATE,
          p_EXCHANGE_RATE           => p_CLAIMS_HISTORY_rec.EXCHANGE_RATE,
          p_SET_OF_BOOKS_ID         => p_CLAIMS_HISTORY_rec.SET_OF_BOOKS_ID,
          p_ORIGINAL_CLAIM_DATE     => p_CLAIMS_HISTORY_rec.ORIGINAL_CLAIM_DATE,
          p_SOURCE_OBJECT_ID        => p_CLAIMS_HISTORY_rec.SOURCE_OBJECT_ID,
          p_SOURCE_OBJECT_CLASS     => p_CLAIMS_HISTORY_rec.SOURCE_OBJECT_CLASS,
          p_SOURCE_OBJECT_TYPE_ID   => p_CLAIMS_HISTORY_rec.SOURCE_OBJECT_TYPE_ID,
          p_SOURCE_OBJECT_NUMBER    => p_CLAIMS_HISTORY_rec.SOURCE_OBJECT_NUMBER,
          p_CUST_ACCOUNT_ID         => p_CLAIMS_HISTORY_rec.CUST_ACCOUNT_ID,
          p_CUST_BILLTO_ACCT_SITE_ID=> p_CLAIMS_HISTORY_rec.CUST_BILLTO_ACCT_SITE_ID,
          p_cust_shipto_acct_site_id  => p_claims_history_rec.cust_shipto_acct_site_id,
          p_LOCATION_ID              => p_CLAIMS_HISTORY_rec.LOCATION_ID,
          p_PAY_RELATED_ACCOUNT_FLAG => p_claims_history_rec.PAY_RELATED_ACCOUNT_FLAG,
          p_RELATED_CUST_ACCOUNT_ID  => p_claims_history_rec.RELATED_CUST_ACCOUNT_ID,
          p_RELATED_SITE_USE_ID      => p_claims_history_rec.RELATED_SITE_USE_ID,
          p_RELATIONSHIP_TYPE        => p_claims_history_rec.RELATIONSHIP_TYPE,
          p_VENDOR_ID                => p_claims_history_rec.VENDOR_ID,
          p_VENDOR_SITE_ID           => p_claims_history_rec.VENDOR_SITE_ID,
	       p_REASON_TYPE             => p_CLAIMS_HISTORY_rec.REASON_TYPE,
          p_REASON_CODE_ID          => p_CLAIMS_HISTORY_rec.REASON_CODE_ID,
          p_TASK_TEMPLATE_GROUP_ID  => p_claims_history_rec.TASK_TEMPLATE_GROUP_ID,
          p_STATUS_CODE             => p_CLAIMS_HISTORY_rec.STATUS_CODE,
          p_USER_STATUS_ID          => p_CLAIMS_HISTORY_rec.USER_STATUS_ID,
          p_SALES_REP_ID            => p_CLAIMS_HISTORY_rec.SALES_REP_ID,
          p_COLLECTOR_ID            => p_CLAIMS_HISTORY_rec.COLLECTOR_ID,
          p_CONTACT_ID              => p_CLAIMS_HISTORY_rec.CONTACT_ID,
          p_BROKER_ID               => p_CLAIMS_HISTORY_rec.BROKER_ID,
          p_TERRITORY_ID            => p_CLAIMS_HISTORY_rec.TERRITORY_ID,
          p_CUSTOMER_REF_DATE       => p_CLAIMS_HISTORY_rec.CUSTOMER_REF_DATE,
          p_CUSTOMER_REF_NUMBER     => p_CLAIMS_HISTORY_rec.CUSTOMER_REF_NUMBER,
          p_ASSIGNED_TO             => p_CLAIMS_HISTORY_rec.ASSIGNED_TO,
          p_RECEIPT_ID              => p_CLAIMS_HISTORY_rec.RECEIPT_ID,
          p_RECEIPT_NUMBER          => p_CLAIMS_HISTORY_rec.RECEIPT_NUMBER,
          p_DOC_SEQUENCE_ID         => p_CLAIMS_HISTORY_rec.DOC_SEQUENCE_ID,
          p_DOC_SEQUENCE_VALUE      => p_CLAIMS_HISTORY_rec.DOC_SEQUENCE_VALUE,
          p_GL_DATE                 => p_CLAIMS_HISTORY_rec.GL_DATE,
          p_PAYMENT_METHOD          => p_CLAIMS_HISTORY_rec.PAYMENT_METHOD,
          p_VOUCHER_ID              => p_CLAIMS_HISTORY_rec.VOUCHER_ID,
          p_VOUCHER_NUMBER          => p_CLAIMS_HISTORY_rec.VOUCHER_NUMBER,
          p_PAYMENT_REFERENCE_ID    => p_CLAIMS_HISTORY_rec.PAYMENT_REFERENCE_ID,
          p_PAYMENT_REFERENCE_NUMBER => p_CLAIMS_HISTORY_rec.PAYMENT_REFERENCE_NUMBER,
          p_PAYMENT_REFERENCE_DATE  => p_CLAIMS_HISTORY_rec.PAYMENT_REFERENCE_DATE,
          p_PAYMENT_STATUS          => p_CLAIMS_HISTORY_rec.PAYMENT_STATUS,
          p_APPROVED_FLAG           => p_CLAIMS_HISTORY_rec.APPROVED_FLAG,
          p_APPROVED_DATE           => p_CLAIMS_HISTORY_rec.APPROVED_DATE,
          p_APPROVED_BY             => p_CLAIMS_HISTORY_rec.APPROVED_BY,
          p_SETTLED_DATE            => p_CLAIMS_HISTORY_rec.SETTLED_DATE,
          p_SETTLED_BY              => p_CLAIMS_HISTORY_rec.SETTLED_BY,
          p_effective_date  => p_claims_history_rec.effective_date,
          p_CUSTOM_SETUP_ID         => p_claims_history_rec.CUSTOM_SETUP_ID,
          p_TASK_ID                 => p_claims_history_rec.TASK_ID,
          p_COUNTRY_ID              => p_claims_history_rec.COUNTRY_ID,
	       p_ORDER_TYPE_ID              => p_claims_history_rec.ORDER_TYPE_ID,
          p_COMMENTS                => p_CLAIMS_HISTORY_rec.COMMENTS,
          p_LETTER_ID               => p_CLAIMS_HISTORY_rec.LETTER_ID,
          p_LETTER_DATE             => p_CLAIMS_HISTORY_rec.LETTER_DATE,
          p_TASK_SOURCE_OBJECT_ID   => p_CLAIMS_HISTORY_rec.TASK_SOURCE_OBJECT_ID,
          p_TASK_SOURCE_OBJECT_TYPE_CODE => p_CLAIMS_HISTORY_rec.TASK_SOURCE_OBJECT_TYPE_CODE,
          p_ATTRIBUTE_CATEGORY      => p_CLAIMS_HISTORY_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1              => p_CLAIMS_HISTORY_rec.ATTRIBUTE1,
          p_ATTRIBUTE2              => p_CLAIMS_HISTORY_rec.ATTRIBUTE2,
          p_ATTRIBUTE3              => p_CLAIMS_HISTORY_rec.ATTRIBUTE3,
          p_ATTRIBUTE4              => p_CLAIMS_HISTORY_rec.ATTRIBUTE4,
          p_ATTRIBUTE5              => p_CLAIMS_HISTORY_rec.ATTRIBUTE5,
          p_ATTRIBUTE6              => p_CLAIMS_HISTORY_rec.ATTRIBUTE6,
          p_ATTRIBUTE7              => p_CLAIMS_HISTORY_rec.ATTRIBUTE7,
          p_ATTRIBUTE8              => p_CLAIMS_HISTORY_rec.ATTRIBUTE8,
          p_ATTRIBUTE9              => p_CLAIMS_HISTORY_rec.ATTRIBUTE9,
          p_ATTRIBUTE10             => p_CLAIMS_HISTORY_rec.ATTRIBUTE10,
          p_ATTRIBUTE11             => p_CLAIMS_HISTORY_rec.ATTRIBUTE11,
          p_ATTRIBUTE12             => p_CLAIMS_HISTORY_rec.ATTRIBUTE12,
          p_ATTRIBUTE13             => p_CLAIMS_HISTORY_rec.ATTRIBUTE13,
          p_ATTRIBUTE14             => p_CLAIMS_HISTORY_rec.ATTRIBUTE14,
          p_ATTRIBUTE15             => p_CLAIMS_HISTORY_rec.ATTRIBUTE15,
          p_DEDUCTION_ATTRIBUTE_CATEGORY  => p_claims_history_rec.DEDUCTION_ATTRIBUTE_CATEGORY,
          p_DEDUCTION_ATTRIBUTE1  => p_claims_history_rec.DEDUCTION_ATTRIBUTE1,
          p_DEDUCTION_ATTRIBUTE2  => p_claims_history_rec.DEDUCTION_ATTRIBUTE2,
          p_DEDUCTION_ATTRIBUTE3  => p_claims_history_rec.DEDUCTION_ATTRIBUTE3,
          p_DEDUCTION_ATTRIBUTE4  => p_claims_history_rec.DEDUCTION_ATTRIBUTE4,
          p_DEDUCTION_ATTRIBUTE5  => p_claims_history_rec.DEDUCTION_ATTRIBUTE5,
          p_DEDUCTION_ATTRIBUTE6  => p_claims_history_rec.DEDUCTION_ATTRIBUTE6,
          p_DEDUCTION_ATTRIBUTE7  => p_claims_history_rec.DEDUCTION_ATTRIBUTE7,
          p_DEDUCTION_ATTRIBUTE8  => p_claims_history_rec.DEDUCTION_ATTRIBUTE8,
          p_DEDUCTION_ATTRIBUTE9  => p_claims_history_rec.DEDUCTION_ATTRIBUTE9,
          p_DEDUCTION_ATTRIBUTE10  => p_claims_history_rec.DEDUCTION_ATTRIBUTE10,
          p_DEDUCTION_ATTRIBUTE11  => p_claims_history_rec.DEDUCTION_ATTRIBUTE11,
          p_DEDUCTION_ATTRIBUTE12  => p_claims_history_rec.DEDUCTION_ATTRIBUTE12,
          p_DEDUCTION_ATTRIBUTE13  => p_claims_history_rec.DEDUCTION_ATTRIBUTE13,
          p_DEDUCTION_ATTRIBUTE14  => p_claims_history_rec.DEDUCTION_ATTRIBUTE14,
          p_DEDUCTION_ATTRIBUTE15  => p_claims_history_rec.DEDUCTION_ATTRIBUTE15,
	       px_ORG_ID                 => l_org_id,
          p_WRITE_OFF_FLAG  => p_claims_history_rec.WRITE_OFF_FLAG,
          p_WRITE_OFF_THRESHOLD_AMOUNT  => p_claims_history_rec.WRITE_OFF_THRESHOLD_AMOUNT,
          p_UNDER_WRITE_OFF_THRESHOLD  => p_claims_history_rec.UNDER_WRITE_OFF_THRESHOLD,
          p_CUSTOMER_REASON  => p_claims_history_rec.CUSTOMER_REASON,
          p_SHIP_TO_CUST_ACCOUNT_ID         => p_CLAIMS_HISTORY_rec.SHIP_TO_CUST_ACCOUNT_ID,
          p_AMOUNT_APPLIED             => p_claims_history_rec.AMOUNT_APPLIED,              --BUG:2781186
          p_APPLIED_RECEIPT_ID         => p_claims_history_rec.APPLIED_RECEIPT_ID,          --BUG:2781186
          p_APPLIED_RECEIPT_NUMBER     => p_claims_history_rec.APPLIED_RECEIPT_NUMBER,      --BUG:2781186
          p_WO_REC_TRX_ID              => p_claims_history_rec.WO_REC_TRX_ID,
          p_GROUP_CLAIM_ID             => p_claims_history_rec.GROUP_CLAIM_ID,
          p_APPR_WF_ITEM_KEY           => p_claims_history_rec.APPR_WF_ITEM_KEY,
          p_CSTL_WF_ITEM_KEY           => p_claims_history_rec.CSTL_WF_ITEM_KEY,
          p_BATCH_TYPE                 => p_claims_history_rec.BATCH_TYPE

      );

Line: 1289


SELECT db_table_name, db_column_name, ak_attribute_code
FROM ams_column_rules
WHERE rule_type = 'HISTORY';

Line: 1298


l_select varchar2(500);

Line: 1318


    l_stmt :=          'SELECT count(claim_id) ';

Line: 1384


CURSOR  user_selected_columns_csr IS
SELECT  db_column_name, ak_attribute_code
FROM    ams_column_rules
WHERE   object_type = 'CLAM'
AND db_table_name = 'OZF_CLAIMS_ALL'
AND     rule_type = 'HISTORY';

Line: 1391


l_column_info user_selected_columns_csr%rowtype;

Line: 1394


SELECT claim_type_id,
       claim_date,
       due_date,
       task_template_group_id,
       reason_code_id,
       owner_id,
       sales_rep_id,
       broker_id,
       status_code,
       user_status_id,
       cust_account_id,
       cust_billto_acct_site_id,
       cust_shipto_acct_site_id,
       contact_id,
       customer_ref_number,
       customer_ref_date,
       amount,
       currency_code,
       exchange_rate_type,
       exchange_rate,
       exchange_rate_date,
       duplicate_claim_id,
       order_type_id,
       comments,
       effective_date,
       gl_date,
       payment_method,
       pay_related_account_flag,
       related_cust_account_id,
       related_site_use_id,
       relationship_type,
       vendor_id,
       vendor_site_id
FROM   ozf_claims_history_all
WHERE  claim_id = p_id
order by claim_history_id desc;

Line: 1434


SELECT claim_history_id
FROM   ozf_claims_history_all
WHERE  claim_id = p_id;

Line: 1497


   ELSIF (p_event = G_UPDATE_EVENT) THEN
   -- If it is an update event and the claim is in NEW status
   -- then no need to create/update the history record (uday)
     IF p_claim.status_code = 'NEW' THEN
        l_history_event := null;

Line: 1510


         OPEN user_selected_columns_csr;

Line: 1512


             FETCH user_selected_columns_csr INTO l_column_info;

Line: 1513


             EXIT WHEN user_selected_columns_csr%NOTFOUND;

Line: 1902


         CLOSE user_selected_columns_csr;

Line: 1970


SELECT custom_setup_id
FROM ams_custom_setups_vl
WHERE object_type = G_CLAIM_HIST_OBJ_TYPE
AND  activity_type_code = p_claim_class;

Line: 1976


SELECT *
FROM ozf_claims_all
WHERE claim_id = pid;

Line: 1982


SELECT *
FROM   ozf_claim_lines_all
WHERE  claim_id = p_id;

Line: 1999


SELECT ozf_claims_history_all_s.nextval
FROM dual;

Line: 2003


select history_event, history_event_description
from ozf_claims_all
where claim_id = pid;

Line: 2008


select count(*)
from ozf_claims_history
where claim_history_id =p_id;

Line: 2208


     UPDATE ozf_claims_all
     SET history_event = p_history_event,
         history_event_date = SYSDATE,
         history_event_description = p_history_event_description
     WHERE claim_id = p_claim_id;

Line: 2284


        l_claim_lines_hist_rec.select_cust_children_flag := l_claim_line_rec.select_cust_children_flag;

Line: 2351


PROCEDURE Delete_claims_history(
    P_Api_Version_Number         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_HISTORY_ID           IN  NUMBER,
    P_Object_Version_Number      IN   NUMBER
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_claims_history';

Line: 2369


SELECT object_version_number
FROM   ozf_claims_history_all
WHERE  claim_history_id = p_claim_history_id;

Line: 2375


      SAVEPOINT DELETE_CLAIMS_HISTORY_PVT;

Line: 2412


           OZF_claims_history_PKG.Delete_Row(
              p_CLAIM_HISTORY_ID  => p_CLAIM_HISTORY_ID);

Line: 2454


    ROLLBACK TO DELETE_CLAIMS_HISTORY_PVT;

Line: 2463


    ROLLBACK TO DELETE_CLAIMS_HISTORY_PVT;

Line: 2472


    ROLLBACK TO DELETE_CLAIMS_HISTORY_PVT;

Line: 2484


End Delete_claims_history;

Line: 2500


PROCEDURE Update_Claims_History(
    P_Api_Version_Number         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_CLAIMS_HISTORY_Rec         IN   CLAIMS_HISTORY_Rec_Type,
    X_Object_Version_Number      OUT NOCOPY  NUMBER
    )
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Update_Claims_History';

Line: 2523


select object_version_number
from ozf_claims_history_all
where claim_history_id = p_id;

Line: 2530


      SAVEPOINT UPDATE_CLAIMS_HISTORY_PVT;

Line: 2610


        OZF_claims_history_PKG.Update_Row(
          p_CLAIM_HISTORY_ID       => l_CLAIMS_HISTORY_rec.CLAIM_HISTORY_ID,
          p_OBJECT_VERSION_NUMBER  => l_CLAIMS_HISTORY_rec.OBJECT_VERSION_NUMBER +1 ,
          p_LAST_UPDATE_DATE       => SYSDATE,
          p_LAST_UPDATED_BY        => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_LOGIN      => FND_GLOBAL.CONC_LOGIN_ID,
          p_REQUEST_ID             => l_CLAIMS_HISTORY_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID => l_CLAIMS_HISTORY_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_UPDATE_DATE    => l_CLAIMS_HISTORY_rec.PROGRAM_UPDATE_DATE,
          p_PROGRAM_ID             => l_CLAIMS_HISTORY_rec.PROGRAM_ID,
          p_CREATED_FROM           => l_CLAIMS_HISTORY_rec.CREATED_FROM,
          p_BATCH_ID               => l_CLAIMS_HISTORY_rec.BATCH_ID,
          p_CLAIM_ID               => l_CLAIMS_HISTORY_rec.CLAIM_ID,
          p_CLAIM_NUMBER           => l_CLAIMS_HISTORY_rec.CLAIM_NUMBER,
          p_CLAIM_TYPE_ID          => l_CLAIMS_HISTORY_rec.CLAIM_TYPE_ID,
          p_CLAIM_CLASS            => l_CLAIMS_HISTORY_REC.CLAIM_CLASS,
          p_CLAIM_DATE             => l_CLAIMS_HISTORY_rec.CLAIM_DATE,
          p_DUE_DATE               => l_CLAIMS_HISTORY_rec.DUE_DATE,
          p_OWNER_ID               => l_CLAIMS_HISTORY_rec.OWNER_ID,
          p_HISTORY_EVENT          => l_CLAIMS_HISTORY_rec.HISTORY_EVENT,
          p_HISTORY_EVENT_DATE     => l_CLAIMS_HISTORY_rec.HISTORY_EVENT_DATE,
          p_HISTORY_EVENT_DESCRIPTION  => l_CLAIMS_HISTORY_rec.HISTORY_EVENT_DESCRIPTION,
          p_SPLIT_FROM_CLAIM_ID    => l_CLAIMS_HISTORY_rec.SPLIT_FROM_CLAIM_ID,
          p_duplicate_claim_id     => l_claims_history_rec.duplicate_claim_id,
          p_SPLIT_DATE             => l_CLAIMS_HISTORY_rec.SPLIT_DATE,
          p_ROOT_CLAIM_ID          => l_claims_history_rec.ROOT_CLAIM_ID,
          p_AMOUNT                 => l_CLAIMS_HISTORY_rec.AMOUNT,
          p_AMOUNT_ADJUSTED        => l_CLAIMS_HISTORY_rec.AMOUNT_ADJUSTED,
          p_AMOUNT_REMAINING       => l_CLAIMS_HISTORY_rec.AMOUNT_REMAINING,
          p_AMOUNT_SETTLED         => l_CLAIMS_HISTORY_rec.AMOUNT_SETTLED,
          p_ACCTD_AMOUNT           => l_CLAIMS_HISTORY_rec.ACCTD_AMOUNT,
          p_acctd_amount_remaining => l_claims_history_rec.acctd_amount_remaining,
          p_acctd_AMOUNT_ADJUSTED  => l_CLAIMS_HISTORY_rec.acctd_AMOUNT_ADJUSTED,
          p_acctd_AMOUNT_SETTLED   => l_CLAIMS_HISTORY_rec.acctd_AMOUNT_SETTLED,
          p_tax_amount             => l_claims_history_rec.tax_amount,
          p_tax_code               => l_claims_history_rec.tax_code,
          p_tax_calculation_flag   => l_claims_history_rec.tax_calculation_flag,
          p_CURRENCY_CODE          => l_CLAIMS_HISTORY_rec.CURRENCY_CODE,
          p_EXCHANGE_RATE_TYPE     => l_CLAIMS_HISTORY_rec.EXCHANGE_RATE_TYPE,
          p_EXCHANGE_RATE_DATE     => l_CLAIMS_HISTORY_rec.EXCHANGE_RATE_DATE,
          p_EXCHANGE_RATE          => l_CLAIMS_HISTORY_rec.EXCHANGE_RATE,
          p_SET_OF_BOOKS_ID        => l_CLAIMS_HISTORY_rec.SET_OF_BOOKS_ID,
          p_ORIGINAL_CLAIM_DATE    => l_CLAIMS_HISTORY_rec.ORIGINAL_CLAIM_DATE,
          p_SOURCE_OBJECT_ID       => l_CLAIMS_HISTORY_rec.SOURCE_OBJECT_ID,
          p_SOURCE_OBJECT_CLASS    => l_CLAIMS_HISTORY_rec.SOURCE_OBJECT_CLASS,
          p_SOURCE_OBJECT_TYPE_ID  => l_CLAIMS_HISTORY_rec.SOURCE_OBJECT_TYPE_ID,
          p_SOURCE_OBJECT_NUMBER   => l_CLAIMS_HISTORY_rec.SOURCE_OBJECT_NUMBER,
          p_CUST_ACCOUNT_ID        => l_CLAIMS_HISTORY_rec.CUST_ACCOUNT_ID,
          p_CUST_BILLTO_ACCT_SITE_ID  => l_CLAIMS_HISTORY_rec.CUST_BILLTO_ACCT_SITE_ID,
          p_cust_shipto_acct_site_id  => l_claims_history_rec.cust_shipto_acct_site_id,
          p_LOCATION_ID            => l_CLAIMS_HISTORY_rec.LOCATION_ID,
          p_PAY_RELATED_ACCOUNT_FLAG => l_claims_history_rec.PAY_RELATED_ACCOUNT_FLAG,
          p_RELATED_CUST_ACCOUNT_ID  => l_claims_history_rec.RELATED_CUST_ACCOUNT_ID,
          p_RELATED_SITE_USE_ID      => l_claims_history_rec.RELATED_SITE_USE_ID,
          p_RELATIONSHIP_TYPE        => l_claims_history_rec.RELATIONSHIP_TYPE,
          p_VENDOR_ID                => l_claims_history_rec.VENDOR_ID,
          p_VENDOR_SITE_ID           => l_claims_history_rec.VENDOR_SITE_ID,
          p_REASON_TYPE              => l_CLAIMS_HISTORY_rec.REASON_TYPE,
          p_REASON_CODE_ID           => l_CLAIMS_HISTORY_rec.REASON_CODE_ID,
          p_TASK_TEMPLATE_GROUP_ID   => l_claims_history_rec.TASK_TEMPLATE_GROUP_ID,
          p_STATUS_CODE              => l_CLAIMS_HISTORY_rec.STATUS_CODE,
          p_USER_STATUS_ID           => l_CLAIMS_HISTORY_rec.USER_STATUS_ID,
          p_SALES_REP_ID             => l_CLAIMS_HISTORY_rec.SALES_REP_ID,
          p_COLLECTOR_ID             => l_CLAIMS_HISTORY_rec.COLLECTOR_ID,
          p_CONTACT_ID               => l_CLAIMS_HISTORY_rec.CONTACT_ID,
          p_BROKER_ID                => l_CLAIMS_HISTORY_rec.BROKER_ID,
          p_TERRITORY_ID             => l_CLAIMS_HISTORY_rec.TERRITORY_ID,
          p_CUSTOMER_REF_DATE        => l_CLAIMS_HISTORY_rec.CUSTOMER_REF_DATE,
          p_CUSTOMER_REF_NUMBER      => l_CLAIMS_HISTORY_rec.CUSTOMER_REF_NUMBER,
          p_ASSIGNED_TO              => l_CLAIMS_HISTORY_rec.ASSIGNED_TO,
          p_RECEIPT_ID               => l_CLAIMS_HISTORY_rec.RECEIPT_ID,
          p_RECEIPT_NUMBER           => l_CLAIMS_HISTORY_rec.RECEIPT_NUMBER,
          p_DOC_SEQUENCE_ID          => l_CLAIMS_HISTORY_rec.DOC_SEQUENCE_ID,
          p_DOC_SEQUENCE_VALUE       => l_CLAIMS_HISTORY_rec.DOC_SEQUENCE_VALUE,
          p_GL_DATE                  => l_CLAIMS_HISTORY_rec.GL_DATE,
          p_PAYMENT_METHOD           => l_CLAIMS_HISTORY_rec.PAYMENT_METHOD,
          p_VOUCHER_ID               => l_CLAIMS_HISTORY_rec.VOUCHER_ID,
          p_VOUCHER_NUMBER           => l_CLAIMS_HISTORY_rec.VOUCHER_NUMBER,
          p_PAYMENT_REFERENCE_ID     => l_CLAIMS_HISTORY_rec.PAYMENT_REFERENCE_ID,
          p_PAYMENT_REFERENCE_NUMBER => l_CLAIMS_HISTORY_rec.PAYMENT_REFERENCE_NUMBER,
          p_PAYMENT_REFERENCE_DATE   => l_CLAIMS_HISTORY_rec.PAYMENT_REFERENCE_DATE,
          p_PAYMENT_STATUS           => l_CLAIMS_HISTORY_rec.PAYMENT_STATUS,
          p_APPROVED_FLAG            => l_CLAIMS_HISTORY_rec.APPROVED_FLAG,
          p_APPROVED_DATE            => l_CLAIMS_HISTORY_rec.APPROVED_DATE,
          p_APPROVED_BY              => l_CLAIMS_HISTORY_rec.APPROVED_BY,
          p_SETTLED_DATE             => l_CLAIMS_HISTORY_rec.SETTLED_DATE,
          p_SETTLED_BY               => l_CLAIMS_HISTORY_rec.SETTLED_BY,
          p_CUSTOM_SETUP_ID          => l_claims_history_rec.CUSTOM_SETUP_ID,
          p_effective_date           => l_claims_history_rec.effective_date,
          p_TASK_ID                  => l_claims_history_rec.TASK_ID,
          p_COUNTRY_ID               => l_claims_history_rec.COUNTRY_ID,
          p_ORDER_TYPE_ID               => l_claims_history_rec.ORDER_TYPE_ID,
          p_COMMENTS                 => l_CLAIMS_HISTORY_rec.COMMENTS,
          p_LETTER_ID                => l_CLAIMS_HISTORY_rec.LETTER_ID,
          p_LETTER_DATE              => l_CLAIMS_HISTORY_rec.LETTER_DATE,
          p_TASK_SOURCE_OBJECT_ID    => l_CLAIMS_HISTORY_rec.TASK_SOURCE_OBJECT_ID,
          p_TASK_SOURCE_OBJECT_TYPE_CODE  => l_CLAIMS_HISTORY_rec.TASK_SOURCE_OBJECT_TYPE_CODE,
          p_ATTRIBUTE_CATEGORY       => l_CLAIMS_HISTORY_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => l_CLAIMS_HISTORY_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => l_CLAIMS_HISTORY_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => l_CLAIMS_HISTORY_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => l_CLAIMS_HISTORY_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => l_CLAIMS_HISTORY_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => l_CLAIMS_HISTORY_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => l_CLAIMS_HISTORY_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => l_CLAIMS_HISTORY_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => l_CLAIMS_HISTORY_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => l_CLAIMS_HISTORY_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => l_CLAIMS_HISTORY_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => l_CLAIMS_HISTORY_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => l_CLAIMS_HISTORY_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => l_CLAIMS_HISTORY_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => l_CLAIMS_HISTORY_rec.ATTRIBUTE15,
          p_DEDUCTION_ATTRIBUTE_CATEGORY  => l_claims_history_rec.DEDUCTION_ATTRIBUTE_CATEGORY,
          p_DEDUCTION_ATTRIBUTE1  => l_claims_history_rec.DEDUCTION_ATTRIBUTE1,
          p_DEDUCTION_ATTRIBUTE2  => l_claims_history_rec.DEDUCTION_ATTRIBUTE2,
          p_DEDUCTION_ATTRIBUTE3  => l_claims_history_rec.DEDUCTION_ATTRIBUTE3,
          p_DEDUCTION_ATTRIBUTE4  => l_claims_history_rec.DEDUCTION_ATTRIBUTE4,
          p_DEDUCTION_ATTRIBUTE5  => l_claims_history_rec.DEDUCTION_ATTRIBUTE5,
          p_DEDUCTION_ATTRIBUTE6  => l_claims_history_rec.DEDUCTION_ATTRIBUTE6,
          p_DEDUCTION_ATTRIBUTE7  => l_claims_history_rec.DEDUCTION_ATTRIBUTE7,
          p_DEDUCTION_ATTRIBUTE8  => l_claims_history_rec.DEDUCTION_ATTRIBUTE8,
          p_DEDUCTION_ATTRIBUTE9  => l_claims_history_rec.DEDUCTION_ATTRIBUTE9,
          p_DEDUCTION_ATTRIBUTE10  => l_claims_history_rec.DEDUCTION_ATTRIBUTE10,
          p_DEDUCTION_ATTRIBUTE11  => l_claims_history_rec.DEDUCTION_ATTRIBUTE11,
          p_DEDUCTION_ATTRIBUTE12  => l_claims_history_rec.DEDUCTION_ATTRIBUTE12,
          p_DEDUCTION_ATTRIBUTE13  => l_claims_history_rec.DEDUCTION_ATTRIBUTE13,
          p_DEDUCTION_ATTRIBUTE14  => l_claims_history_rec.DEDUCTION_ATTRIBUTE14,
          p_DEDUCTION_ATTRIBUTE15  => l_claims_history_rec.DEDUCTION_ATTRIBUTE15,
          p_ORG_ID                 => l_CLAIMS_HISTORY_rec.ORG_ID,
	       p_WRITE_OFF_FLAG                => l_CLAIMS_HISTORY_rec.WRITE_OFF_FLAG,
	       p_WRITE_OFF_THRESHOLD_AMOUNT    => l_CLAIMS_HISTORY_rec.WRITE_OFF_THRESHOLD_AMOUNT,
	       p_UNDER_WRITE_OFF_THRESHOLD     => l_CLAIMS_HISTORY_rec.UNDER_WRITE_OFF_THRESHOLD,
	       p_CUSTOMER_REASON               => l_CLAIMS_HISTORY_rec.CUSTOMER_REASON,
          p_SHIP_TO_CUST_ACCOUNT_ID   => l_CLAIMS_HISTORY_rec.SHIP_TO_CUST_ACCOUNT_ID,
          p_AMOUNT_APPLIED => l_claims_history_rec.AMOUNT_APPLIED,                          --Bug:2781186
          p_APPLIED_RECEIPT_ID => l_claims_history_rec.APPLIED_RECEIPT_ID,                  --Bug:2781186
          p_APPLIED_RECEIPT_NUMBER => l_claims_history_rec.APPLIED_RECEIPT_NUMBER,           --Bug:2781186
          p_WO_REC_TRX_ID          => l_CLAIMS_HISTORY_rec.WO_REC_TRX_ID,
          p_GROUP_CLAIM_ID          => l_CLAIMS_HISTORY_rec.GROUP_CLAIM_ID,
          p_APPR_WF_ITEM_KEY          => l_CLAIMS_HISTORY_rec.APPR_WF_ITEM_KEY,
          p_CSTL_WF_ITEM_KEY          => l_CLAIMS_HISTORY_rec.CSTL_WF_ITEM_KEY,
          p_BATCH_TYPE          => l_CLAIMS_HISTORY_rec.BATCH_TYPE
          );

Line: 2784


    ROLLBACK TO UPDATE_CLAIMS_HISTORY_PVT;

Line: 2793


    ROLLBACK TO UPDATE_CLAIMS_HISTORY_PVT;

Line: 2802


    ROLLBACK TO UPDATE_CLAIMS_HISTORY_PVT;

Line: 2814


End Update_claims_history;