APPS.JTF_USR_HKS SQL Statements

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

Line: 22

		Select EXECUTE_FLAG
		into	l_execute
		from
		JTF_USER_HOOKS
		Where
 		pkg_name = p_pkg_name	and
		api_name = p_api_name	and
		processing_type = p_process_type	and
		user_hook_type = p_user_hook_type;

Line: 74

	Select bind_name, bind_value, data_type
	From	JTF_BIND_DATA
	Where 	bind_data_id = l_bind_data_id  And
		bind_type    = 'W';

Line: 190

	Select bind_name, bind_value, data_type
	From	JTF_BIND_DATA
	Where 	bind_data_id = l_bind_data_id  And
		bind_type    = 'W';

Line: 355

		select  bus_obj_sql, nvl(msg_mode,1) , bus_obj_name
		into  l_msg_SQL, l_msg_mode, l_bus_obj_name
		from  JTF_MESSAGE_OBJECTS
		where
			PRODUCT_CODE   =  p_prod_code  and
			BUS_OBJ_CODE   =  p_bus_obj_code  and
			ACTION_CODE    =  p_action_code and
			ACTIVE_FLAG    =  'Y';

Line: 441

		select  bus_obj_sql ,nvl(msg_mode,1) , bus_obj_name
		into  l_msg_SQL, l_msg_mode, l_bus_obj_name
		from  JTF_MESSAGE_OBJECTS
		where
			PRODUCT_CODE   =  p_prod_code  and
			BUS_OBJ_CODE   =  p_bus_obj_code  and
			ACTION_CODE    =  p_action_code and
			ACTIVE_FLAG    =  'Y';

Line: 514

		select  bus_obj_sql ,nvl(msg_mode,1) , bus_obj_name
		into  l_msg_SQL, l_msg_mode, l_bus_obj_name
		from  JTF_MESSAGE_OBJECTS
		where
			PRODUCT_CODE   =  p_prod_code  and
			BUS_OBJ_CODE   =  p_bus_obj_code  and
			ACTION_CODE    =  p_action_code and
			ACTIVE_FLAG    =  'Y';

Line: 532

  	select jtf_msg_id_s.nextval
	into x_msg_id
	from dual;

Line: 575

		        	  delete from JTF_SYNC_REPLY_MSG
		        	  where msg_id = x_msg_id
		        	  returning reply_msg into x_reply_msg;

Line: 624

  	select jtf_msg_id_s.nextval
	into x_msg_id
	from dual;

Line: 670

	        	  delete from JTF_SYNC_REPLY_MSG
	        	  where msg_id = x_msg_id
	        	  returning reply_msg into x_reply_msg;

Line: 721

	Insert into JTF_BIND_DATA(
				   bind_data_id,
				   bind_name,
				   bind_value,
				   bind_type,
				   data_type   )
		   	Values  (
				   p_bind_data_id,
				   p_bind_name,
				   p_bind_value,
				   p_bind_type,
				   p_data_type  );

Line: 742

	Delete from JTF_BIND_DATA
	Where  BIND_DATA_ID  = p_Bind_Data_Id  And
	       BIND_TYPE     = p_bind_type ;

Line: 758

	Select JTF_USER_HOOKS_S.NEXTVAL
	into l_hk_id
	from Dual;

Line: 773

	Select JTF_MSG_OBJ_S.NEXTVAL
	into l_bo_id
	from Dual;

Line: 868

	Select bind_name, bind_value
	From	JTF_BIND_DATA
	Where 	bind_data_id = v_bind_data_id  And
		bind_type    = 'S';

Line: 877

		select  bus_obj_sql, nvl(msg_mode,1), bus_obj_name
		into  l_msg_SQL, l_msg_mode, l_bus_obj_name
		from  JTF_MESSAGE_OBJECTS
		where
			PRODUCT_CODE   =  p_prod_code  and
			BUS_OBJ_CODE   =  p_bus_obj_code  and
			ACTION_CODE    =  p_action_code and
			ACTIVE_FLAG    =  'Y';

Line: 898

			select  HEADER_DTD  into  l_hdr_DTD
			from  JTF_HEADER_DTD
			where
				ACTIVE_FLAG    =  'Y';