DBA Data[Home] [Help]

APPS.CS_CTR_CAPTURE_READING_VUHK SQL Statements

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

Line: 148

PROCEDURE UPDATE_COUNTER_READING_PRE(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_validation_level           IN   NUMBER,
    p_CTR_GRP_LOG_ID             IN   NUMBER,
    p_CTR_RDG_Tbl                IN   CS_CTR_CAPTURE_READING_PUB.CTR_RDG_Tbl_Type  := CS_CTR_CAPTURE_READING_PUB.G_MISS_CTR_RDG_TBL,
    p_PROP_RDG_Tbl               IN   CS_CTR_CAPTURE_READING_PUB.PROP_RDG_Tbl_Type  := CS_CTR_CAPTURE_READING_PUB.G_MISS_PROP_RDG_TBL,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
  )
IS
--NEEDED
  l_JTM_enable_prof_value varchar2(255);
Line: 168

           ' ''UPDATE_COUNTER_READING_PRE'', ' ||
           ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
Line: 182

           ' ''UPDATE_COUNTER_READING_PRE'', ' ||
           ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
Line: 199

     ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_PRE' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
Line: 233

END UPDATE_COUNTER_READING_PRE;
Line: 236

PROCEDURE UPDATE_COUNTER_READING_POST(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_validation_level           IN   NUMBER,
    p_CTR_GRP_LOG_ID             IN   NUMBER,
    p_CTR_RDG_Tbl                IN   CS_CTR_CAPTURE_READING_PUB.CTR_RDG_Tbl_Type  := CS_CTR_CAPTURE_READING_PUB.G_MISS_CTR_RDG_TBL,
    p_PROP_RDG_Tbl               IN   CS_CTR_CAPTURE_READING_PUB.PROP_RDG_Tbl_Type  := CS_CTR_CAPTURE_READING_PUB.G_MISS_PROP_RDG_TBL,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
  )
IS
  l_JTM_enable_prof_value varchar2(255);
Line: 255

           ' ''UPDATE_COUNTER_READING_POST'', ' ||
           ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
Line: 269

           ' ''UPDATE_COUNTER_READING_POST'', ' ||
           ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
Line: 286

     ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_POST' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
Line: 320

END UPDATE_COUNTER_READING_POST;
Line: 425

PROCEDURE UPDATE_COUNTER_READING_PRE (
    p_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_validation_level           IN   NUMBER,
    p_CTR_RDG_Rec                IN   CS_CTR_CAPTURE_READING_PUB.CTR_RDG_Rec_Type,
    p_COUNTER_GRP_LOG_ID         IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
   )
IS
--NEEDED
  l_JTM_enable_prof_value varchar2(255);
Line: 445

           ' ''UPDATE_COUNTER_READING_PRE'', ' ||
           ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
Line: 459

           ' ''UPDATE_COUNTER_READING_PRE'', ' ||
           ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
Line: 477

     ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_PRE' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
Line: 512

END UPDATE_COUNTER_READING_PRE;
Line: 514

PROCEDURE UPDATE_COUNTER_READING_POST (
    p_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_validation_level           IN   NUMBER,
    p_CTR_RDG_Rec                IN   CS_CTR_CAPTURE_READING_PUB.CTR_RDG_Rec_Type,
    p_COUNTER_GRP_LOG_ID         IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
   )
IS
--NEEDED
  l_JTM_enable_prof_value varchar2(255);
Line: 534

           ' ''UPDATE_COUNTER_READING_POST'', ' ||
           ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
Line: 548

           ' ''UPDATE_COUNTER_READING_POST'', ' ||
           ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
Line: 565

     ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_POST' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
Line: 600

END UPDATE_COUNTER_READING_POST;
Line: 740

      p_READING_UPDATED         IN   VARCHAR2,
      X_Return_Status           OUT  NOCOPY VARCHAR2,
      X_Msg_Count               OUT  NOCOPY NUMBER,
      X_Msg_Data                OUT  NOCOPY VARCHAR2
     )
IS
BEGIN
X_Return_Status := FND_API.G_RET_STS_SUCCESS;
Line: 756

      p_READING_UPDATED         IN   VARCHAR2,
      X_Return_Status           OUT  NOCOPY VARCHAR2,
      X_Msg_Count               OUT  NOCOPY NUMBER,
      X_Msg_Data                OUT  NOCOPY VARCHAR2
     )
IS
BEGIN
X_Return_Status := FND_API.G_RET_STS_SUCCESS;
Line: 766

PROCEDURE UPDATE_CTR_PROP_READING_PRE (
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2,
    p_commit                     IN   VARCHAR2,
    p_validation_level           IN   NUMBER,
    p_PROP_RDG_Rec               IN   CS_CTR_CAPTURE_READING_PUB.PROP_RDG_Rec_Type,
    p_COUNTER_GRP_LOG_ID         IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2
    )
IS
BEGIN
X_Return_Status := FND_API.G_RET_STS_SUCCESS;
Line: 781

END UPDATE_CTR_PROP_READING_PRE;
Line: 783

PROCEDURE UPDATE_CTR_PROP_READING_POST (
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2,
    p_commit                     IN   VARCHAR2,
    p_validation_level           IN   NUMBER,
    p_PROP_RDG_Rec               IN   CS_CTR_CAPTURE_READING_PUB.PROP_RDG_Rec_Type,
    p_COUNTER_GRP_LOG_ID         IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2
    )
IS
BEGIN
X_Return_Status := FND_API.G_RET_STS_SUCCESS;
Line: 798

END UPDATE_CTR_PROP_READING_POST;