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

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

Line: 185


PROCEDURE Update_timeframe(
    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,
    P_Check_Access_Flag          IN   VARCHAR2   := FND_API.G_FALSE,
    P_Admin_Flag                 IN   VARCHAR2   := FND_API.G_FALSE,
    P_Admin_Group_Id             IN   NUMBER,
    P_Identity_Salesforce_Id     IN   NUMBER,
    P_profile_tbl                IN   AS_UTILITY_PUB.PROFILE_TBL_TYPE,
    P_timeframe_Rec     IN    timeframe_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

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

Line: 207


      SAVEPOINT UPDATE_TIMEFRAME_PUB;

Line: 250


    AML_timeframe_PVT.Update_timeframe(
        P_Api_Version_Number         => 2.0,
        P_Init_Msg_List              => FND_API.G_FALSE,
        P_Commit                     => p_commit,
        P_Validation_Level           => P_Validation_Level,
        P_Check_Access_Flag          => P_Check_Access_Flag,
        P_Admin_Flag                 => P_Admin_Flag,
        P_Admin_Group_Id             => P_Admin_Group_Id,
        P_Identity_Salesforce_Id     => P_Identity_Salesforce_Id,
        P_Profile_Tbl                => P_Profile_tbl,
        P_timeframe_Rec  =>  l_pvt_timeframe_Rec ,
        X_Return_Status              => x_return_status,
        X_Msg_Count                  => x_msg_count,
        X_Msg_Data                   => x_msg_data);

Line: 309


      IF(JTF_USR_HKS.Ok_to_execute('AS_timeframe_PUB', 'Update_timeframe','A','V'))
      THEN
          AS_timeframe_VUHK.Update_timeframe_Post(
                  p_api_version_number   =>  2.0,
                  p_validation_level     =>  p_validation_level,
                  p_commit               =>  FND_API.G_FALSE,
                  p_profile_tbl          =>  p_profile_tbl,
                  p_check_access_flag    =>  p_check_access_flag,
                  p_admin_flag           =>  p_admin_flag,
                  p_admin_group_id       =>  p_admin_group_id,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_timeframe_Rec      =>  P_timeframe_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 332


      IF(JTF_USR_HKS.Ok_to_execute('AS_timeframe_PUB', 'Update_timeframe','A','C'))
      THEN
          AS_timeframe_CUHK.Update_timeframe_Pre(
                  p_api_version_number   =>  2.0,
                  p_validation_level     =>  p_validation_level,
                  p_commit               =>  FND_API.G_FALSE,
                  p_profile_tbl          =>  p_profile_tbl,
                  p_check_access_flag    =>  p_check_access_flag,
                  p_admin_flag           =>  p_admin_flag,
                  p_admin_group_id       =>  p_admin_group_id,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_timeframe_Rec      =>  P_timeframe_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 387


End Update_timeframe;

Line: 392


PROCEDURE Delete_timeframe(
    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,
    P_Check_Access_Flag          IN   VARCHAR2   := FND_API.G_FALSE,
    P_Admin_Flag                 IN   VARCHAR2   := FND_API.G_FALSE,
    P_Admin_Group_Id             IN   NUMBER,
    P_Identity_Salesforce_Id     IN   NUMBER,
    P_Profile_Tbl                IN   AS_UTILITY_PUB.PROFILE_TBL_TYPE,
    P_timeframe_Rec     IN timeframe_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

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

Line: 414


      SAVEPOINT DELETE_TIMEFRAME_PUB;

Line: 457


    AML_timeframe_PVT.Delete_timeframe(
        P_Api_Version_Number         => 2.0,
        P_Init_Msg_List              => FND_API.G_FALSE,
        P_Commit                     => p_commit,
        P_Validation_Level           => p_Validation_Level,
        P_Check_Access_Flag          => P_Check_Access_Flag,
        P_Admin_Flag                 => P_Admin_Flag,
        P_Admin_Group_Id             => P_Admin_Group_Id,
        P_Identity_Salesforce_Id     => P_Identity_Salesforce_Id,
        P_Profile_Tbl                => P_Profile_tbl,
        P_timeframe_Rec  => l_pvt_timeframe_Rec,
        X_Return_Status              => x_return_status,
        X_Msg_Count                  => x_msg_count,
        X_Msg_Data                   => x_msg_data);

Line: 475


      IF(JTF_USR_HKS.Ok_to_execute('AS_timeframe_PUB', 'Delete_timeframe','B','C'))
      THEN
          AS_timeframe_CUHK.Delete_timeframe_Pre(
                  p_api_version_number   =>  2.0,
                  p_validation_level     =>  p_validation_level,
                  p_commit               =>  FND_API.G_FALSE,
                  p_profile_tbl          =>  p_profile_tbl,
                  p_check_access_flag    =>  p_check_access_flag,
                  p_admin_flag           =>  p_admin_flag,
                  p_admin_group_id       =>  p_admin_group_id,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_timeframe_Rec      =>  P_timeframe_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 498


      IF(JTF_USR_HKS.Ok_to_execute('AS_timeframe_PUB', 'Delete_timeframe','B','V'))
      THEN
          AS_timeframe_VUHK.Delete_timeframe_Pre(
                  p_api_version_number   =>  2.0,
                  p_validation_level     =>  p_validation_level,
                  p_commit               =>  FND_API.G_FALSE,
                  p_profile_tbl          =>  p_profile_tbl,
                  p_check_access_flag    =>  p_check_access_flag,
                  p_admin_flag           =>  p_admin_flag,
                  p_admin_group_id       =>  p_admin_group_id,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_timeframe_Rec      =>  P_timeframe_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 565


      IF(JTF_USR_HKS.Ok_to_execute('AS_timeframe_PUB', 'Delete_timeframe','A','V'))
      THEN
          AS_timeframe_VUHK.Delete_timeframe_Post(
                  p_api_version_number   =>  2.0,
                  p_validation_level     =>  p_validation_level,
                  p_commit               =>  FND_API.G_FALSE,
                  p_profile_tbl          =>  p_profile_tbl,
                  p_check_access_flag    =>  p_check_access_flag,
                  p_admin_flag           =>  p_admin_flag,
                  p_admin_group_id       =>  p_admin_group_id,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_timeframe_Rec      =>  P_timeframe_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 588


      IF(JTF_USR_HKS.Ok_to_execute('AS_timeframe_PUB', 'Delete_timeframe','A','C'))
      THEN
          AS_timeframe_CUHK.Delete_timeframe_Pre(
                  p_api_version_number   =>  2.0,
                  p_validation_level     =>  p_validation_level,
                  p_commit               =>  FND_API.G_FALSE,
                  p_profile_tbl          =>  p_profile_tbl,
                  p_check_access_flag    =>  p_check_access_flag,
                  p_admin_flag           =>  p_admin_flag,
                  p_admin_group_id       =>  p_admin_group_id,
                  p_identity_salesforce_id => p_identity_salesforce_id,
                  P_timeframe_Rec      =>  P_timeframe_Rec,
          -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
                  x_return_status        =>  x_return_status,
                  x_msg_count            =>  x_msg_count,
                  x_msg_data             =>  x_msg_data);

Line: 643


End Delete_timeframe;