APPS.OZF_SPLIT_CLAIM_PVT SQL Statements

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

Line: 32

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

Line: 75

SELECT *
FROM   OZF_CLAIMS_ALL
WHERE  claim_id = p_id;

Line: 90

  SELECT user_or_role_id
  ,      arc_user_or_role_type
  ,      admin_flag
  ,      owner_flag
  FROM ams_act_access
  WHERE arc_act_access_to_object = 'CLAM'
  AND act_access_to_object_id = pv_parent_claim_id
  MINUS
  SELECT user_or_role_id
  ,      arc_user_or_role_type
  ,      admin_flag
  ,      owner_flag
  FROM ams_act_access
  WHERE arc_act_access_to_object = 'CLAM'
  AND act_access_to_object_id = pv_child_claim_id;

Line: 283

	OZF_CLAIM_LINE_PVT.Update_Claim_Line(
           p_api_version       => l_api_version
          ,p_init_msg_list     => FND_API.g_false
          ,p_commit            => FND_API.g_false
          ,p_validation_level  => FND_API.g_valid_level_full
          ,x_return_status     => l_return_status
          ,x_msg_count         => l_msg_count
          ,x_msg_data          => l_msg_data
          ,p_claim_line_rec    => l_claim_line
			 ,p_mode              => OZF_claim_Utility_pvt.G_AUTO_MODE
          ,x_object_version    => l_line_obj_num
       );

Line: 374

PROCEDURE update_child_claim (
    p_claim                  IN    child_claim_int_type
   ,p_line_tbl               IN    Simple_line_tbl_type
   ,x_return_status          OUT NOCOPY   VARCHAR2
   ,x_new_claim_amount       OUT NOCOPY   NUMBER
)
IS
l_api_name               CONSTANT VARCHAR2(30) := 'Update_Child_Claim';

Line: 395

SELECT object_version_number
FROM   ozf_claims_all
WHERE  claim_id = p_id;

Line: 400

SELECT status_code
FROM   ozf_claims_all
WHERE  claim_id = p_id;

Line: 408

SELECT NVL(SUM(claim_currency_amount), 0)
/* END FIX BUG : while calculating claim amount, line_sume_amount should set to 0 if it is null.*/
FROM   ozf_claim_lines_all
WHERE  claim_id = p_id;

Line: 437

	         -- Get the line amount before update
	         OPEN line_amount_sum_csr(p_claim.claim_id);

Line: 444

	    -- Here p_claim.amount is the old amount, since we don't update it on screen.
	    l_diff_amount := p_claim.amount - l_line_amount_sum;

Line: 454

	    OZF_claim_PVT.Update_Claim (
               p_api_version       => l_api_version
              ,p_init_msg_list     => FND_API.G_FALSE
              ,p_commit            => FND_API.G_FALSE
              ,p_validation_level  => FND_API.G_VALID_LEVEL_FULL
              ,x_return_status     => l_return_status
              ,x_msg_data          => l_msg_data
              ,x_msg_count         => l_msg_count
              ,p_claim             => l_child_claim
              ,p_event             => G_UPDATE_EVENT
				  ,p_mode              => OZF_claim_Utility_pvt.G_AUTO_MODE
              ,x_object_version_number  => l_object_version_number
            );

Line: 474

	    -- Now update the lines.
	    -- For each claim_line_id, update the claim_line
            FOR i in 1..p_line_tbl.COUNT LOOP
                -- build a record to update in claim lines table.
                OZF_CLAIM_LINE_PVT.Init_Claim_Line_Rec(x_claim_line_rec => l_claim_line);

Line: 483

               OZF_CLAIM_LINE_PVT.Update_Claim_Line(
                 p_api_version       => l_api_version
                ,p_init_msg_list     => FND_API.g_false
                ,p_commit            => FND_API.g_false
                ,p_validation_level  => FND_API.g_valid_level_full
                ,x_return_status     => l_return_status
                ,x_msg_count         => l_msg_count
                ,x_msg_data          => l_msg_data
                ,p_claim_line_rec    => l_claim_line
                ,p_mode              => OZF_claim_Utility_pvt.G_AUTO_MODE
                ,x_object_version    => l_line_obj_num
              );

Line: 541

END update_child_claim;

Line: 557

PROCEDURE update_parent_claim (
    p_claim                  IN    parent_claim_type
   ,p_mode                   IN VARCHAR2
   ,x_return_status          OUT NOCOPY   VARCHAR2
   )
IS
l_api_name               CONSTANT VARCHAR2(30) := 'Update_Parent_Claim';

Line: 576

SELECT object_version_number, status_code, amount_adjusted, amount_remaining, currency_code, reason_code_id
FROM   ozf_claims_all
WHERE  claim_id = p_id;

Line: 595

       ozf_utility_pvt.debug_message('start update parent');

Line: 647

         OZF_claim_PVT.Update_Claim (
           p_api_version       => l_api_version
          ,p_init_msg_list     => FND_API.G_FALSE
          ,p_commit            => FND_API.G_FALSE
          ,p_validation_level  => FND_API.G_VALID_LEVEL_FULL
          ,x_return_status     => l_return_status
          ,x_msg_data          => l_msg_data
          ,x_msg_count         => l_msg_count
          ,p_claim             => l_claim
          ,p_event             => G_NO_CHANGE_EVENT
          ,p_mode              => OZF_claim_Utility_pvt.G_AUTO_MODE
          ,x_object_version_number  => l_object_version_number
         );

Line: 697

END update_parent_claim;

Line: 727

SELECT amount_remaining
FROM   ozf_claims_all
WHERE  claim_id = p_id;

Line: 733

SELECT NVL(SUM(claim_currency_amount), 0)
FROM   ozf_claim_lines_all
WHERE  claim_id = p_id;

Line: 741

SELECT NVL(SUM(amount), 0)
FROM   ozf_claims_all
WHERE  split_from_claim_id = p_id;

Line: 747

SELECT claim_id
FROM   ozf_claims_all
WHERE  split_from_claim_id = p_id;

Line: 918

SELECT amount_remaining
FROM   ozf_claims_all
WHERE  claim_id = p_id;

Line: 924

SELECT NVL(SUM(claim_currency_amount), 0)
FROM   ozf_claim_lines_all
WHERE  claim_id = p_id;

Line: 930

SELECT Count(claim_line_id)
FROM   ozf_claim_lines_all
WHERE  claim_id = p_id;

Line: 936

SELECT earnings_associated_flag
FROM   ozf_claim_lines_all
WHERE  claim_id = p_id;

Line: 944

SELECT *
FROM ozf_claim_lines_all
where claim_id = p_id;

Line: 1010

		   ozf_utility_PVT.debug_message('delete claim line amount ' || l_claim_line.claim_line_id);

Line: 1013

		   delete from ozf_claim_lines_all
			where claim_line_id = l_claim_line.claim_line_id;

Line: 1018

		   ozf_utility_PVT.debug_message('update parent claim amount ' ||l_claim_line.claim_line_id);

Line: 1047

         OZF_CLAIM_LINE_PVT.Update_Claim_Line(
            p_api_version       => 1.0
           ,p_init_msg_list     => FND_API.g_false
           ,p_commit            => FND_API.g_false
           ,p_validation_level  => FND_API.g_valid_level_full
           ,x_return_status     => l_return_status
           ,x_msg_count         => l_msg_count
           ,x_msg_data          => l_msg_data
           ,p_claim_line_rec    => l_parent_line
           ,p_mode              => OZF_claim_Utility_pvt.G_AUTO_MODE
           ,x_object_version    => l_line_obj_num
         );

Line: 1066

			update ozf_claim_lines_all
			set claim_currency_amount = l_parent_amount_remaining - l_new_split_amount,
			    quantity = null
			where claim_line_id = l_claim_line.claim_line_id;

Line: 1161

			--update the l_child_claim_tbl record
			--   line_amount_sum := amount
			--   line_table := l_claim_line_id || ',1';

Line: 1236

SELECT claim_class
FROM ozf_claims_all
WHERE claim_id = p_claim_id;

Line: 1372

         l_line_tbl.delete;

Line: 1387

   update_parent_claim (
      p_claim   => l_parent_claim
     ,p_mode    => p_mode
     ,x_return_status  => l_return_status
   );

Line: 1490

PROCEDURE update_child_claim_tbl (
    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_data               OUT NOCOPY   VARCHAR2
   ,x_msg_count              OUT NOCOPY   NUMBER
   ,p_child_claim_tbl        IN    Child_Claim_tbl_type
	,p_mode                   IN    VARCHAR2
   )
IS
l_api_name               CONSTANT VARCHAR2(30) := 'Update_Child_Claim_tbl';

Line: 1523

   SAVEPOINT  Update_Child_Tbl_PVT;

Line: 1591

	update_child_claim (
             p_claim                  => l_child_claim
            ,p_line_tbl               => l_line_tbl
            ,x_return_status          => l_return_status
            ,x_new_claim_amount       => l_new_child_claim_amount
         );

Line: 1607

	    l_line_tbl.delete;

Line: 1619

   update_parent_claim (
       p_claim   => l_parent_claim
      ,p_mode    => p_mode
      ,x_return_status  => l_return_status
   );

Line: 1672

      ROLLBACK TO  Update_Child_Tbl_PVT;

Line: 1681

      ROLLBACK TO  Update_Child_Tbl_PVT;

Line: 1690

      ROLLBACK TO  Update_Child_Tbl_PVT;

Line: 1701

END update_child_claim_tbl;