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

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

Line: 93


   l_pvt_claim_rec.last_update_date:=l_claim_rec.last_update_date;

Line: 94


   l_pvt_claim_rec.last_updated_by:=l_claim_rec.last_updated_by;

Line: 97


   l_pvt_claim_rec.last_update_login:=l_claim_rec.last_update_login;

Line: 100


   l_pvt_claim_rec.program_update_date:=l_claim_rec.program_update_date;

Line: 418


     l_pvt_claim_line_tbl(i).last_update_date            := l_claim_line_tbl(i).last_update_date;

Line: 419


     l_pvt_claim_line_tbl(i).last_updated_by             := l_claim_line_tbl(i).last_updated_by ;

Line: 422


     l_pvt_claim_line_tbl(i).last_update_login           := l_claim_line_tbl(i).last_update_login;

Line: 425


     l_pvt_claim_line_tbl(i).program_update_date         := l_claim_line_tbl(i).program_update_date ;

Line: 490


     l_pvt_claim_line_tbl(i).update_from_tbl_flag        := l_claim_line_tbl(i).update_from_tbl_flag;

Line: 598


PROCEDURE Update_Claim(
   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_rec                  IN    claim_rec_type,
   p_claim_line_tbl             IN    claim_line_tbl_type,
   x_object_version_number      OUT NOCOPY   NUMBER
)
IS
   L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Claim';

Line: 624


SELECT source_object_class
FROM ozf_claims_all
WHERE claim_id = p_claim_id;

Line: 632


   SAVEPOINT SAVE_UPDATE_CLAIM_PUB;

Line: 660


   l_pvt_claim_rec.last_update_date:=l_claim_rec.last_update_date;

Line: 661


   l_pvt_claim_rec.last_updated_by:=l_claim_rec.last_updated_by;

Line: 664


   l_pvt_claim_rec.last_update_login:=l_claim_rec.last_update_login;

Line: 667


   l_pvt_claim_rec.program_update_date:=l_claim_rec.program_update_date;

Line: 798


   OZF_Claim_PVT.Update_Claim(
   p_api_version      => p_api_version_number,
   p_init_msg_list    => FND_API.G_FALSE,
   p_commit           => FND_API.G_FALSE,
   P_Validation_Level   => p_Validation_Level,
   x_return_status              => x_return_status,
   x_msg_count                  => x_msg_count,
   x_msg_data                   => x_msg_data,
   p_claim                      => l_pvt_claim_rec,
   p_event                      => 'UPDATE',
   p_mode                       => OZF_claim_Utility_pvt.G_AUTO_MODE,
   x_object_version_number      => x_object_version_number );

Line: 812


      OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR UPDATE CLAIM =>'||X_RETURN_STATUS);

Line: 844


	   Update_Claim_Line_Tbl(
	    p_api_version      => p_api_version_number
	   ,p_init_msg_list    => FND_API.G_FALSE
	   ,p_commit           => FND_API.G_FALSE
	   ,P_Validation_Level   => p_Validation_Level
	   ,x_return_status          => x_return_status
	   ,x_msg_data               => x_msg_data
	   ,x_msg_count              => x_msg_count
	   ,p_claim_line_tbl         => l_claim_line_tbl
	   ,p_change_object_version  => FND_API.g_false
	   ,x_error_index            => x_error_index);

Line: 858


      OZF_UTILITY_PVT.DEBUG_MESSAGE('Return Status for Update claim line =>'||x_return_status);

Line: 882


   ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;

Line: 891


   ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;

Line: 900


   ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;

Line: 909


   ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;

Line: 921


End Update_Claim;

Line: 938


PROCEDURE Update_Claim_Line_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_claim_line_tbl         IN    claim_line_tbl_type
   ,p_change_object_version  IN    VARCHAR2 := FND_API.g_false
   ,x_error_index            OUT NOCOPY   NUMBER
)
IS
   L_API_NAME               CONSTANT VARCHAR2(30) := 'Update_Claim_Line';

Line: 959


   SAVEPOINT Update_Claim_Line_Tbl;

Line: 993


     IF l_claim_line_tbl(i).last_update_date is null then
        l_pvt_claim_line_tbl(i).last_update_date    := FND_API.G_MISS_DATE;

Line: 996


        l_pvt_claim_line_tbl(i).last_update_date    :=l_claim_line_tbl(i).last_update_date;

Line: 999


     IF l_claim_line_tbl(i).last_updated_by is null then
        l_pvt_claim_line_tbl(i).last_updated_by    := FND_API.G_MISS_NUM;

Line: 1002


        l_pvt_claim_line_tbl(i).last_updated_by    :=l_claim_line_tbl(i).last_updated_by;

Line: 1017


     IF l_claim_line_tbl(i).last_update_login is null then
        l_pvt_claim_line_tbl(i).last_update_login    := FND_API.G_MISS_NUM;

Line: 1020


        l_pvt_claim_line_tbl(i).last_update_login    :=l_claim_line_tbl(i).last_update_login;

Line: 1035


     IF l_claim_line_tbl(i).program_update_date is null then
        l_pvt_claim_line_tbl(i).program_update_date    := FND_API.G_MISS_DATE;

Line: 1038


        l_pvt_claim_line_tbl(i).program_update_date    :=l_claim_line_tbl(i).program_update_date;

Line: 1425


     IF l_claim_line_tbl(i).update_from_tbl_flag is null then
        l_pvt_claim_line_tbl(i).update_from_tbl_flag   := FND_API.G_MISS_CHAR;

Line: 1428


        l_pvt_claim_line_tbl(i).update_from_tbl_flag   :=l_claim_line_tbl(i).update_from_tbl_flag;

Line: 1494


   Ozf_Claim_Line_Pvt.Update_Claim_line_Tbl(
    p_api_version        => p_api_version
   ,p_init_msg_list      => FND_API.G_FALSE
   ,p_commit             => FND_API.G_FALSE
   ,P_Validation_Level   => p_Validation_Level
   ,x_return_status          =>   x_return_status
   ,x_msg_data               =>   x_msg_data
   ,x_msg_count              =>   x_msg_count
   ,p_claim_line_tbl         =>   l_pvt_claim_line_tbl
   ,p_change_object_version  =>   FND_API.g_false
   ,x_error_index            =>   l_error_index );

Line: 1506


      OZF_UTILITY_PVT.DEBUG_MESSAGE('sTATUS FOR Update claim line =>'||x_return_status);

Line: 1529


   ROLLBACK TO Update_Claim_Line_Tbl;

Line: 1538


   ROLLBACK TO Update_Claim_Line_Tbl;

Line: 1547


   ROLLBACK TO Update_Claim_Line_Tbl;

Line: 1556


   ROLLBACK TO Update_Claim_Line_Tbl;

Line: 1568


End Update_Claim_Line_tbl;

Line: 1569


/*End of Update Claim Line*/
---------------------------------------------------------------------
-- PROCEDURE
--   delete_claim
--
-- PURPOSE
--    This procedure deletes claim record when Claim_Id and Object Version Number are provided.
--
-- PARAMETERS
--
--    x_msg_count
--    x_object_version_number
--    x_return_status
--    p_claim_id
--    p_object_version_number
-- NOTES
---------------------------------------------------------------------
PROCEDURE Delete_Claim(
   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_id                   IN  NUMBER,
   p_object_version_number      IN   NUMBER
)
IS
   L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Claim';

Line: 1604


   SAVEPOINT DELETE_Claim_PUB;

Line: 1627


   OZF_Claim_PVT.Delete_Claim(
    p_api_version_number     => p_api_version_number,
    p_init_msg_list          => FND_API.G_FALSE,
    p_commit                 => FND_API.G_FALSE,
    p_object_id              => l_claim_id,
    p_object_version_number  => l_object_version_number,
    x_return_status          => x_return_status,
    x_msg_count              => x_msg_count,
    x_msg_data               => x_msg_data
    );

Line: 1639


      OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR DELETE_CLAIM =>'||X_RETURN_STATUS);

Line: 1659


   ROLLBACK TO DELETE_Claim_PUB;

Line: 1668


   ROLLBACK TO DELETE_Claim_PUB;

Line: 1677


   ROLLBACK TO DELETE_Claim_PUB;

Line: 1686


   ROLLBACK TO DELETE_Claim_PUB;

Line: 1698


   End Delete_Claim;

Line: 1716


PROCEDURE Delete_Claim_Line_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_claim_line_tbl         IN    claim_line_tbl_type
   ,p_change_object_version  IN    VARCHAR2 := FND_API.g_false
   ,x_error_index            OUT NOCOPY   NUMBER)
IS
   L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Claim_Line';

Line: 1735


   SAVEPOINT DELETE_Claim_Line_PUB;

Line: 1767


   OZF_Claim_Line_PVT.Delete_Claim_Line_Tbl(
    p_api_version        => p_api_version
   ,p_init_msg_list      => FND_API.G_FALSE
   ,p_commit             => FND_API.G_FALSE
   ,P_Validation_Level   => p_Validation_Level
   ,x_return_status         =>    x_return_status
   ,x_msg_data              =>    x_msg_data
   ,x_msg_count             =>    x_msg_count
   ,p_claim_line_tbl        =>    l_pvt_claim_line_tbl
   ,p_change_object_version =>    FND_API.g_false
   ,x_error_index           =>    l_error_index);

Line: 1779


      OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR DELETE_CLAIM_Line_Tbl =>'||X_RETURN_STATUS);

Line: 1806


   ROLLBACK TO DELETE_Claim_Line_PUB;

Line: 1816


   ROLLBACK TO DELETE_Claim_Line_PUB;

Line: 1825


   ROLLBACK TO DELETE_Claim_Line_PUB;

Line: 1834


   ROLLBACK TO DELETE_Claim_PUB;

Line: 1846


End Delete_Claim_Line_Tbl;

Line: 1847


/* End of Delete claim line*/

---------------------------------------------------------------------
-- PROCEDURE
--   asso_accruals_to_claim
--
-- PURPOSE
--    This procedure associates accruals based on the given fund
--    utilization criteria.
--
-- PARAMETERS
--    p_api_version
--    p_init_msg_list
--    p_commit
--    p_validation_level
--    p_claim_id
--    p_funds_util_flt
--    x_return_status
--    x_msg_count
--    x_msg_data
-- NOTES
---------------------------------------------------------------------
PROCEDURE Asso_Accruals_To_Claim(
    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_claim_id               IN    NUMBER
   ,p_funds_util_flt         IN    funds_util_flt_type
)
IS
l_api_version                CONSTANT NUMBER       := 1.0;

Line: 1931


   l_funds_util_flt.select_cust_children_flag   := p_funds_util_flt.select_cust_children_flag;

Line: 2291


   l_funds_util_flt.select_cust_children_flag   := p_funds_util_flt.select_cust_children_flag;

Line: 2522


   l_funds_util_flt.select_cust_children_flag   := p_funds_util_flt.select_cust_children_flag;