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

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

Line: 48


  SELECT OZF_CLAIM_LINES_HIST_ALL_s.NEXTVAL
  FROM dual;

Line: 52


  SELECT 1
  FROM OZF_CLAIM_LINES_HIST_ALL
  WHERE CLAIM_LINE_HISTORY_ID = l_id;

Line: 100


	l_claim_line_hist_rec.last_update_date := SYSDATE;

Line: 101


	l_claim_line_hist_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 152


    OZF_CLAIM_LINES_HIST_PKG.Insert_Row(
          px_claim_line_history_id     => l_claim_line_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                 => FND_GLOBAL.conc_request_id,
          p_program_application_id     => FND_GLOBAL.prog_appl_id,
          p_program_update_date        => SYSDATE,
          p_program_id                 => FND_GLOBAL.conc_program_id,
          p_created_from               => p_claim_line_hist_rec.created_from,
          p_claim_history_id           => p_claim_line_hist_rec.claim_history_id,
          p_claim_id                   => p_claim_line_hist_rec.claim_id,
          p_claim_line_id              => p_claim_line_hist_rec.claim_line_id,
          p_line_number                => p_claim_line_hist_rec.line_number,
          p_split_from_claim_line_id   => p_claim_line_hist_rec.split_from_claim_line_id,
          p_amount                     => p_claim_line_hist_rec.amount,
          p_acctd_amount               => p_claim_line_hist_rec.acctd_amount,
          p_currency_code              => p_claim_line_hist_rec.currency_code,
          p_exchange_rate_type         => p_claim_line_hist_rec.exchange_rate_type,
          p_exchange_rate_date         => p_claim_line_hist_rec.exchange_rate_date,
          p_exchange_rate              => p_claim_line_hist_rec.exchange_rate,
          p_set_of_books_id            => p_claim_line_hist_rec.set_of_books_id,
          p_valid_flag                 => p_claim_line_hist_rec.valid_flag,
          p_source_object_id           => p_claim_line_hist_rec.source_object_id,
          p_source_object_class        => p_claim_line_hist_rec.source_object_class,
          p_source_object_type_id      => p_claim_line_hist_rec.source_object_type_id,
	       p_source_object_line_id      => p_claim_line_hist_rec.source_object_line_id,
          p_plan_id                    => p_claim_line_hist_rec.plan_id,
          p_offer_id                   => p_claim_line_hist_rec.offer_id,
          p_payment_method             => p_claim_line_hist_rec.payment_method,
          p_payment_reference_id       => p_claim_line_hist_rec.payment_reference_id,
          p_payment_reference_number   => p_claim_line_hist_rec.payment_reference_number,
          p_payment_reference_date     => p_claim_line_hist_rec.payment_reference_date,
          p_voucher_id                 => p_claim_line_hist_rec.voucher_id,
          p_voucher_number             => p_claim_line_hist_rec.voucher_number,
          p_payment_status             => p_claim_line_hist_rec.payment_status,
          p_approved_flag              => p_claim_line_hist_rec.approved_flag,
          p_approved_date              => p_claim_line_hist_rec.approved_date,
          p_approved_by                => p_claim_line_hist_rec.approved_by,
          p_settled_date               => p_claim_line_hist_rec.settled_date,
          p_settled_by                 => p_claim_line_hist_rec.settled_by,
          p_performance_complete_flag  => p_claim_line_hist_rec.performance_complete_flag,
          p_performance_attached_flag  => p_claim_line_hist_rec.performance_attached_flag,
          p_attribute_category         => p_claim_line_hist_rec.attribute_category,
          p_attribute1                 => p_claim_line_hist_rec.attribute1,
          p_attribute2                 => p_claim_line_hist_rec.attribute2,
          p_attribute3                 => p_claim_line_hist_rec.attribute3,
          p_attribute4                 => p_claim_line_hist_rec.attribute4,
          p_attribute5                 => p_claim_line_hist_rec.attribute5,
          p_attribute6                 => p_claim_line_hist_rec.attribute6,
          p_attribute7                 => p_claim_line_hist_rec.attribute7,
          p_attribute8                 => p_claim_line_hist_rec.attribute8,
          p_attribute9                 => p_claim_line_hist_rec.attribute9,
          p_attribute10                => p_claim_line_hist_rec.attribute10,
          p_attribute11                => p_claim_line_hist_rec.attribute11,
          p_attribute12                => p_claim_line_hist_rec.attribute12,
          p_attribute13                => p_claim_line_hist_rec.attribute13,
          p_attribute14                => p_claim_line_hist_rec.attribute14,
          p_attribute15                => p_claim_line_hist_rec.attribute15,
          px_org_id                    => l_org_id,
          p_utilization_id             => p_claim_line_hist_rec.utilization_id,
          p_claim_currency_amount      => p_claim_line_hist_rec.claim_currency_amount,
          p_item_id                    => p_claim_line_hist_rec.item_id,
          p_item_description           => p_claim_line_hist_rec.item_description,
          p_quantity                   => p_claim_line_hist_rec.quantity,
          p_quantity_uom               => p_claim_line_hist_rec.quantity_uom,
          p_rate                       => p_claim_line_hist_rec.rate,
          p_activity_type              => p_claim_line_hist_rec.activity_type,
          p_activity_id                => p_claim_line_hist_rec.activity_id,
          p_earnings_associated_flag   => p_claim_line_hist_rec.earnings_associated_flag,
          p_comments                   => p_claim_line_hist_rec.comments,
          p_related_cust_account_id    => p_claim_line_hist_rec.related_cust_account_id,
          p_relationship_type          => p_claim_line_hist_rec.relationship_type,
          p_tax_code                   => p_claim_line_hist_rec.tax_code,
          p_select_cust_children_flag  => p_claim_line_hist_rec.select_cust_children_flag,
          p_buy_group_cust_account_id  => p_claim_line_hist_rec.buy_group_cust_account_id,
          p_credit_to                  => p_claim_line_hist_rec.credit_to,
          p_sale_date                  => p_claim_line_hist_rec.sale_date,
          p_item_type                  => p_claim_line_hist_rec.item_type,
          p_tax_amount                 => p_claim_line_hist_rec.tax_amount,
          p_claim_curr_tax_amount      => p_claim_line_hist_rec.claim_curr_tax_amount,
          p_activity_line_id           => p_claim_line_hist_rec.activity_line_id,
          p_offer_type                 => p_claim_line_hist_rec.offer_type,
          p_prorate_earnings_flag      => p_claim_line_hist_rec.prorate_earnings_flag,
          p_earnings_end_date          => p_claim_line_hist_rec.earnings_end_date

    );

Line: 309


PROCEDURE Update_Claim_Line_Hist(
    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_line_hist_rec        IN   claim_line_hist_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
)
IS
/*
CURSOR c_get_claim_line_hist(claim_line_history_id NUMBER) IS
    SELECT *
    FROM  OZF_CLAIM_LINES_HIST_ALL
    -- Hint: Developer need to provide Where clause
*/
l_api_name                 CONSTANT VARCHAR2(30) := 'Update_Claim_Line_Hist';

Line: 340


  SELECT object_version_number
  FROM ozf_claim_lines_hist_all
  WHERE claim_line_history_id = cv_claim_line_hist_id;

Line: 346


  SAVEPOINT UPDATE_Claim_Line_Hist_PVT;

Line: 419


     OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

Line: 424


    OZF_CLAIM_LINES_HIST_PKG.Update_Row(
          p_claim_line_history_id        => p_claim_line_hist_rec.claim_line_history_id,
          p_object_version_number        => p_claim_line_hist_rec.object_version_number,
          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                   => p_claim_line_hist_rec.request_id,
          p_program_application_id       => p_claim_line_hist_rec.program_application_id,
          p_program_update_date          => p_claim_line_hist_rec.program_update_date,
          p_program_id                   => p_claim_line_hist_rec.program_id,
          p_created_from                 => p_claim_line_hist_rec.created_from,
          p_claim_history_id             => p_claim_line_hist_rec.claim_history_id,
          p_claim_id                     => p_claim_line_hist_rec.claim_id,
          p_claim_line_id                => p_claim_line_hist_rec.claim_line_id,
          p_line_number                  => p_claim_line_hist_rec.line_number,
          p_split_from_claim_line_id     => p_claim_line_hist_rec.split_from_claim_line_id,
          p_amount                       => p_claim_line_hist_rec.amount,
          p_acctd_amount                 => p_claim_line_hist_rec.acctd_amount,
          p_currency_code                => p_claim_line_hist_rec.currency_code,
          p_exchange_rate_type           => p_claim_line_hist_rec.exchange_rate_type,
          p_exchange_rate_date           => p_claim_line_hist_rec.exchange_rate_date,
          p_exchange_rate                => p_claim_line_hist_rec.exchange_rate,
          p_set_of_books_id              => p_claim_line_hist_rec.set_of_books_id,
          p_valid_flag                   => p_claim_line_hist_rec.valid_flag,
          p_source_object_id             => p_claim_line_hist_rec.source_object_id,
          p_source_object_class          => p_claim_line_hist_rec.source_object_class,
          p_source_object_type_id        => p_claim_line_hist_rec.source_object_type_id,
	  p_source_object_line_id        => p_claim_line_hist_rec.source_object_line_id,
          p_plan_id                      => p_claim_line_hist_rec.plan_id,
          p_offer_id                     => p_claim_line_hist_rec.offer_id,
          p_payment_method               => p_claim_line_hist_rec.payment_method,
          p_payment_reference_id         => p_claim_line_hist_rec.payment_reference_id,
          p_payment_reference_number     => p_claim_line_hist_rec.payment_reference_number,
          p_payment_reference_date       => p_claim_line_hist_rec.payment_reference_date,
          p_voucher_id                   => p_claim_line_hist_rec.voucher_id,
          p_voucher_number               => p_claim_line_hist_rec.voucher_number,
          p_payment_status               => p_claim_line_hist_rec.payment_status,
          p_approved_flag                => p_claim_line_hist_rec.approved_flag,
          p_approved_date                => p_claim_line_hist_rec.approved_date,
          p_approved_by                  => p_claim_line_hist_rec.approved_by,
          p_settled_date                 => p_claim_line_hist_rec.settled_date,
          p_settled_by                   => p_claim_line_hist_rec.settled_by,
          p_performance_complete_flag    => p_claim_line_hist_rec.performance_complete_flag,
          p_performance_attached_flag    => p_claim_line_hist_rec.performance_attached_flag,
          p_attribute_category           => p_claim_line_hist_rec.attribute_category,
          p_attribute1                   => p_claim_line_hist_rec.attribute1,
          p_attribute2                   => p_claim_line_hist_rec.attribute2,
          p_attribute3                   => p_claim_line_hist_rec.attribute3,
          p_attribute4                   => p_claim_line_hist_rec.attribute4,
          p_attribute5                   => p_claim_line_hist_rec.attribute5,
          p_attribute6                   => p_claim_line_hist_rec.attribute6,
          p_attribute7                   => p_claim_line_hist_rec.attribute7,
          p_attribute8                   => p_claim_line_hist_rec.attribute8,
          p_attribute9                   => p_claim_line_hist_rec.attribute9,
          p_attribute10                  => p_claim_line_hist_rec.attribute10,
          p_attribute11                  => p_claim_line_hist_rec.attribute11,
          p_attribute12                  => p_claim_line_hist_rec.attribute12,
          p_attribute13                  => p_claim_line_hist_rec.attribute13,
          p_attribute14                  => p_claim_line_hist_rec.attribute14,
          p_attribute15                  => p_claim_line_hist_rec.attribute15,
          p_org_id                       => p_claim_line_hist_rec.org_id,
          p_utilization_id               => p_claim_line_hist_rec.utilization_id,
          p_claim_currency_amount        => p_claim_line_hist_rec.claim_currency_amount,
          p_item_id                      => p_claim_line_hist_rec.item_id,
          p_item_description             => p_claim_line_hist_rec.item_description,
          p_quantity                     => p_claim_line_hist_rec.quantity,
          p_quantity_uom                 => p_claim_line_hist_rec.quantity_uom,
          p_rate                         => p_claim_line_hist_rec.rate,
          p_activity_type                => p_claim_line_hist_rec.activity_type,
          p_activity_id                  => p_claim_line_hist_rec.activity_id,
          p_earnings_associated_flag     => p_claim_line_hist_rec.earnings_associated_flag,
          p_comments                     => p_claim_line_hist_rec.comments,
          p_related_cust_account_id      => p_claim_line_hist_rec.related_cust_account_id,
          p_relationship_type            => p_claim_line_hist_rec.relationship_type,
          p_tax_code                     => p_claim_line_hist_rec.tax_code,
          p_select_cust_children_flag    => p_claim_line_hist_rec.select_cust_children_flag,
          p_buy_group_cust_account_id    => p_claim_line_hist_rec.buy_group_cust_account_id,
          p_credit_to                    => p_claim_line_hist_rec.credit_to,
          p_sale_date                  => p_claim_line_hist_rec.sale_date,
          p_item_type                  => p_claim_line_hist_rec.item_type,
          p_tax_amount                 => p_claim_line_hist_rec.tax_amount,
          p_claim_curr_tax_amount      => p_claim_line_hist_rec.claim_curr_tax_amount,
          p_activity_line_id           => p_claim_line_hist_rec.activity_line_id,
          p_offer_type                 => p_claim_line_hist_rec.offer_type,
          p_prorate_earnings_flag      => p_claim_line_hist_rec.prorate_earnings_flag,
          p_earnings_end_date          => p_claim_line_hist_rec.earnings_end_date
    );

Line: 542


    ROLLBACK TO UPDATE_Claim_Line_Hist_PVT;

Line: 552


    ROLLBACK TO UPDATE_Claim_Line_Hist_PVT;

Line: 562


    ROLLBACK TO UPDATE_Claim_Line_Hist_PVT;

Line: 574


END Update_Claim_Line_Hist;

Line: 577


PROCEDURE Delete_Claim_Line_Hist(
    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_line_history_id      IN   NUMBER,
    p_object_version_number      IN   NUMBER
)
IS
l_api_name                  CONSTANT VARCHAR2(30) := 'Delete_Claim_Line_Hist';

Line: 594


  SELECT object_version_number
  FROM ozf_claim_lines_hist_all
  WHERE claim_line_history_id = cv_line_hist_id;

Line: 600


  SAVEPOINT DELETE_Claim_Line_Hist_PVT;

Line: 634


        OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 638


      OZF_CLAIM_LINES_HIST_PKG.Delete_Row(
          p_claim_line_history_id  => p_claim_line_history_id
      );

Line: 679


    ROLLBACK TO DELETE_Claim_Line_Hist_PVT;

Line: 689


     ROLLBACK TO DELETE_Claim_Line_Hist_PVT;

Line: 699


    ROLLBACK TO DELETE_Claim_Line_Hist_PVT;

Line: 711


End Delete_Claim_Line_Hist;

Line: 732


  SELECT claim_line_history_id
  FROM ozf_claim_lines_hist_all
  WHERE claim_line_history_id = p_claim_line_history_id
  AND object_version_number = p_object_version
  FOR UPDATE NOWAIT;

Line: 886


    IF p_claim_line_hist_rec.last_update_date = FND_API.g_miss_date OR
       p_claim_line_hist_rec.last_update_date IS NULL THEN
      OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );

Line: 893


    IF p_claim_line_hist_rec.last_updated_by = FND_API.g_miss_num OR
       p_claim_line_hist_rec.last_updated_by IS NULL THEN
      OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );

Line: 967


    IF p_claim_line_hist_rec.last_update_date IS NULL THEN
      OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );

Line: 973


    IF p_claim_line_hist_rec.last_updated_by IS NULL THEN
      OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );

Line: 1114


  SELECT *
  FROM ozf_claim_lines_hist
  WHERE claim_line_history_id = p_claim_line_hist_rec.claim_line_history_id;

Line: 1144


  IF p_claim_line_hist_rec.last_update_date = FND_API.g_miss_date THEN
    x_complete_rec.last_update_date := NULL;

Line: 1147


  IF p_claim_line_hist_rec.last_update_date IS NULL THEN
    x_complete_rec.last_update_date := l_claim_line_hist_rec.last_update_date;

Line: 1152


  IF p_claim_line_hist_rec.last_updated_by = FND_API.g_miss_num THEN
    x_complete_rec.last_updated_by := NULL;

Line: 1155


  IF p_claim_line_hist_rec.last_updated_by IS NULL THEN
    x_complete_rec.last_updated_by := l_claim_line_hist_rec.last_updated_by;

Line: 1176


  IF p_claim_line_hist_rec.last_update_login = FND_API.g_miss_num THEN
    x_complete_rec.last_update_login := NULL;

Line: 1179


  IF p_claim_line_hist_rec.last_update_login IS NULL THEN
    x_complete_rec.last_update_login := l_claim_line_hist_rec.last_update_login;

Line: 1200


  IF p_claim_line_hist_rec.program_update_date = FND_API.g_miss_date THEN
    x_complete_rec.program_update_date := NULL;

Line: 1203


  IF p_claim_line_hist_rec.program_update_date IS NULL THEN
    x_complete_rec.program_update_date := l_claim_line_hist_rec.program_update_date;

Line: 1736


  IF p_claim_line_hist_rec.select_cust_children_flag = FND_API.g_miss_char THEN
    x_complete_rec.select_cust_children_flag := NULL;

Line: 1739


  IF p_claim_line_hist_rec.select_cust_children_flag IS NULL THEN
    x_complete_rec.select_cust_children_flag := l_claim_line_hist_rec.select_cust_children_flag;

Line: 1868


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