APPS.JTF_HOOK_DATA_PUB SQL Statements

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

Line: 10

PROCEDURE JTF_HOOK_DATA_PUB_INSERT (
  p_api_version_number	IN	NUMBER,
  p_init_msg_list	IN	VARCHAR2 	:= FND_API.G_FALSE,
  p_commit		IN      VARCHAR		:= FND_API.G_FALSE,

  p_hook_data		IN 	HOOK_DATA_REC_TYPE,

  x_return_status	OUT	VARCHAR2,
  x_msg_count		OUT	NUMBER,
  x_msg_data		OUT	VARCHAR2
)
AS
	--******** local variable for standards **********
     	l_api_name		CONSTANT VARCHAR2(30)	:= 'JTF_HOOK_DATA_PUB_INSERT';

Line: 31

	CURSOR C IS SELECT JTF_USER_HOOKS_S.NEXTVAL FROM sys.dual;

Line: 37

      SAVEPOINT	JTF_HOOK_DATA_PUB_INSERT;

Line: 57

   SELECT count(*) into l_hook_id
   FROM JTF_HOOKS_DATA
   WHERE product_code = p_hook_data.p_ProductCode
   AND package_name   = p_hook_data.p_PackageName
   AND api_name       = p_hook_data.p_ApiName
   AND HOOK_TYPE      = p_hook_data.p_HookType
   AND HOOK_PACKAGE   = p_hook_data.p_HookPackage
   AND HOOK_API       = p_hook_data.p_HookApi;

Line: 79

   INSERT INTO JTF_HOOKS_DATA (	HOOK_ID,
				PRODUCT_CODE,
				PACKAGE_NAME,
				API_NAME,
				EXECUTE_FLAG,
				PROCESSING_TYPE,
				HOOK_TYPE,
				HOOK_PACKAGE,
				HOOK_API,
				EXECUTION_ORDER,
				CREATED_BY,
				CREATION_DATE,
				LAST_UPDATED_BY,
				LAST_UPDATE_DATE,
				LAST_UPDATE_LOGIN )

			      VALUES (  l_hook_id,
					p_hook_data.p_ProductCode,
					p_hook_data.p_PackageName,
					p_hook_data.p_ApiName,
                                        p_hook_data.p_ExecuteFlag,
					p_hook_data.p_ProcessingType,
					p_hook_data.p_HookType,
					p_hook_data.p_HookPackage,
                                        p_hook_data.p_HookApi,
					l_exe_order,
					G_USER_ID, SYSDATE, G_USER_ID, SYSDATE, G_LOGIN_ID );

Line: 127

	  ROLLBACK TO JTF_HOOK_DATA_PUB_INSERT;

Line: 136

	  ROLLBACK TO JTF_HOOK_DATA_PUB_INSERT;

Line: 145

	  ROLLBACK TO JTF_HOOK_DATA_PUB_INSERT;

Line: 157

END JTF_HOOK_DATA_PUB_INSERT;