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

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

Line: 5


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

Line: 265


PROCEDURE UPDATE_CTR_GRP_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2,
    p_ctr_grp_id                 IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT  NOCOPY NUMBER
  ) IS
    l_enable_flag varchar2(20);

Line: 284


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

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

Line: 330


PROCEDURE UPDATE_CTR_GRP_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2,
    p_ctr_grp_id                 IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT  NOCOPY NUMBER
  ) IS
    l_enable_flag varchar2(20);

Line: 349


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

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

Line: 395


PROCEDURE UPDATE_COUNTER_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2,
    p_ctr_id                     IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT  NOCOPY NUMBER
  ) IS
    l_enable_flag varchar2(20);

Line: 414


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

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

Line: 459


PROCEDURE UPDATE_COUNTER_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2,
    p_ctr_id                     IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT  NOCOPY NUMBER
  ) IS
    l_enable_flag varchar2(20);

Line: 478


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

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

Line: 523


PROCEDURE UPDATE_CTR_PROP_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2,
    p_ctr_prop_id                IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT  NOCOPY NUMBER
  ) IS
    l_enable_flag varchar2(20);

Line: 542


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

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

Line: 587


PROCEDURE UPDATE_CTR_PROP_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2,
    p_ctr_prop_id                IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT  NOCOPY NUMBER
  ) IS
    l_enable_flag varchar2(20);

Line: 606


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

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

Line: 651


PROCEDURE DELETE_COUNTER_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2,
    p_ctr_id			 IN   NUMBER
  ) IS
    l_enable_flag varchar2(20);

Line: 667


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

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

Line: 709


PROCEDURE DELETE_CTR_PROP_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT  NOCOPY VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY NUMBER,
    X_Msg_Data                   OUT  NOCOPY VARCHAR2,
    p_ctr_prop_id		 IN   NUMBER
  ) IS
    l_enable_flag varchar2(20);

Line: 725


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

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

Line: 767


PROCEDURE DELETE_COUNTER_INSTANCE_PRE (
    p_api_version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_SOURCE_OBJECT_ID           IN   NUMBER,
    p_SOURCE_OBJECT_CODE         IN   VARCHAR2,
    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: 784


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

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