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

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

Line: 101


    x_pvt_TASK_PART_rec.LAST_UPDATED_BY := P_TASK_PART_Rec.LAST_UPDATED_BY;

Line: 102


    x_pvt_TASK_PART_rec.LAST_UPDATE_DATE := P_TASK_PART_Rec.LAST_UPDATE_DATE;

Line: 103


    x_pvt_TASK_PART_rec.LAST_UPDATE_LOGIN := P_TASK_PART_Rec.LAST_UPDATE_LOGIN;

Line: 374


PROCEDURE Update_task_part(
    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_TASK_PART_Rec     IN    TASK_PART_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_task_part';

Line: 391


      SAVEPOINT UPDATE_TASK_PART_PUB;

Line: 436


      IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Update_task_part','B','C'))
      THEN
          AS_task_part_CUHK.Update_task_part_Pre(
                  p_api_version_number   =>  1.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_TASK_PART_Rec      =>  P_TASK_PART_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: 459


      IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Update_task_part','B','V'))
      THEN
          AS_task_part_VUHK.Update_task_part_Pre(
                  p_api_version_number   =>  1.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_TASK_PART_Rec      =>  P_TASK_PART_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: 481


    CSP_task_part_PVT.Update_task_part(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    P_TASK_PART_Rec  =>  l_pvt_TASK_PART_Rec ,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 525


      IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Update_task_part','A','V'))
      THEN
          AS_task_part_VUHK.Update_task_part_Post(
                  p_api_version_number   =>  1.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_TASK_PART_Rec      =>  P_TASK_PART_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: 548


      IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Update_task_part','A','C'))
      THEN
          AS_task_part_CUHK.Update_task_part_Pre(
                  p_api_version_number   =>  1.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_TASK_PART_Rec      =>  P_TASK_PART_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: 603


End Update_task_part;

Line: 608


PROCEDURE Delete_task_part(
    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_TASK_PART_Rec     IN TASK_PART_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_task_part';

Line: 625


      SAVEPOINT DELETE_TASK_PART_PUB;

Line: 666


    CSP_task_part_PVT.Delete_task_part(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => p_Validation_Level,
    P_TASK_PART_Rec  => l_pvt_TASK_PART_Rec,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 679


      IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Delete_task_part','B','C'))
      THEN
          AS_task_part_CUHK.Delete_task_part_Pre(
                  p_api_version_number   =>  1.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_TASK_PART_Rec      =>  P_TASK_PART_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: 702


      IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Delete_task_part','B','V'))
      THEN
          AS_task_part_VUHK.Delete_task_part_Pre(
                  p_api_version_number   =>  1.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_TASK_PART_Rec      =>  P_TASK_PART_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: 759


      IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Delete_task_part','A','V'))
      THEN
          AS_task_part_VUHK.Delete_task_part_Post(
                  p_api_version_number   =>  1.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_TASK_PART_Rec      =>  P_TASK_PART_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: 782


      IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Delete_task_part','A','C'))
      THEN
          AS_task_part_CUHK.Delete_task_part_Pre(
                  p_api_version_number   =>  1.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_TASK_PART_Rec      =>  P_TASK_PART_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: 837


End Delete_task_part;