APPS.JTM_CTR_CAPTURE_READING_VUHK SQL Statements

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

Line: 4

     Select HOOK_PACKAGE, HOOK_API , EXECUTE_FLAG, PRODUCT_CODE
	 from JTF_HOOKS_DATA
	 Where package_name = 'JTM_CTR_CAPTURE_READING_PUB' and
	 upper(api_name) = upper(p_api_name) and
	 processing_type = p_processing_type and
         execute_flag = 'Y' and
	 hook_type = 'V';

Line: 72

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_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
    l_enable_flag varchar2(20);

Line: 90

   FOR Csr1 in Get_hook_info('B', 'UPDATE_COUNTER_READING') LOOP

      /* user execute flag */
      l_enable_flag := Csr1.EXECUTE_FLAG;

Line: 131

END UPDATE_COUNTER_READING_PRE;

Line: 133

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_COUNTER_GRP_LOG_ID         IN   NUMBER,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
   )IS
    l_enable_flag varchar2(20);

Line: 150

   FOR Csr1 in Get_hook_info('B', 'UPDATE_COUNTER_READING') LOOP

      /* user execute flag */
      l_enable_flag := Csr1.EXECUTE_FLAG;

Line: 190

END UPDATE_COUNTER_READING_PRE;

Line: 193

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_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
    l_enable_flag varchar2(20);

Line: 211

   FOR Csr1 in Get_hook_info('A', 'UPDATE_COUNTER_READING') LOOP

      /* user execute flag */
      l_enable_flag := Csr1.EXECUTE_FLAG;

Line: 252

END UPDATE_COUNTER_READING_POST;

Line: 254

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_COUNTER_GRP_LOG_ID         IN   NUMBER,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
   )IS
    l_enable_flag varchar2(20);

Line: 271

   FOR Csr1 in Get_hook_info('A', 'UPDATE_COUNTER_READING') LOOP

      /* user execute flag */
      l_enable_flag := Csr1.EXECUTE_FLAG;

Line: 311

END UPDATE_COUNTER_READING_POST;