APPS.JTM_ITEM_INSTANCE_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_ITEM_INSTANCE_PUB' and
	 upper(api_name) = upper(p_api_name) and
	 processing_type = p_processing_type and
         execute_flag = 'Y' and
	 hook_type = 'V';

Line: 74

PROCEDURE update_item_instance_pre
 (
     p_api_version           IN     NUMBER
    ,p_commit                IN     VARCHAR2
    ,p_init_msg_list         IN     VARCHAR2
    ,p_validation_level      IN     NUMBER
    ,p_instance_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: 92

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

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

Line: 132

END UPDATE_ITEM_INSTANCE_PRE;

Line: 134

PROCEDURE update_item_instance_post
 (
     p_api_version           IN     NUMBER
    ,p_commit                IN     VARCHAR2
    ,p_init_msg_list         IN     VARCHAR2
    ,p_validation_level      IN     NUMBER
    ,p_instance_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: 152

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

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

Line: 192

END UPDATE_ITEM_INSTANCE_POST;