APPS.OZF_TASK_GROUP_PVT SQL Statements

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

Line: 64

SELECT ozf_reasons_s.nextval FROM DUAL;

Line: 153

	INSERT INTO ozf_reasons (
		reason_type_id,
		object_version_number,
		last_update_date,
		last_updated_by,
		creation_date,
		created_by,
		last_update_login,
		active_flag,
		reason_type,
		task_template_group_id
	)
	VALUES (
		l_reason_type_id,
		l_object_version_number,
		SYSDATE,
		NVL(FND_GLOBAL.user_id, -1),
		SYSDATE,
		NVL(FND_GLOBAL.user_id, -1),
		NVL(FND_GLOBAL.conc_login_id, -1),
		l_active_flag,
		l_task_group.reason_type,
		l_task_template_group_id
	);

Line: 247

PROCEDURE  Update_task_group (
    p_api_version            IN    NUMBER
   ,p_init_msg_list          IN    VARCHAR2 := FND_API.G_FALSE
   ,p_commit                 IN    VARCHAR2 := FND_API.G_FALSE
   ,p_validation_level       IN    NUMBER   := FND_API.G_VALID_LEVEL_FULL

   ,x_return_status          OUT  NOCOPY VARCHAR2
   ,x_msg_data               OUT NOCOPY  VARCHAR2
   ,x_msg_count              OUT NOCOPY  NUMBER

   ,p_task_group          	     IN    task_group_rec_type
   ,x_object_version_number  OUT  NOCOPY NUMBER
)
IS
l_api_name          CONSTANT VARCHAR2(30) := 'Update_task_group';

Line: 278

select reason_type, object_version_number
from   ozf_reasons
where  task_template_group_id = cv_temp_group_id;

Line: 285

	SAVEPOINT  Update_task_group_PVT;

Line: 312

			p_validation_mode   => JTF_PLSQL_API.g_update,
			x_return_status     => l_return_status
		);

Line: 333

	  JTF_TASK_TEMP_GROUP_PUB.UPDATE_TASK_TEMPLATE_GROUP
  	  (
		P_API_VERSION => p_api_version,
		P_INIT_MSG_LIST => FND_API.G_FALSE,
		P_COMMIT => FND_API.G_FALSE,
		P_VALIDATE_LEVEL => p_validation_level,
 		P_TASK_TEMPLATE_GROUP_ID => l_task_group.task_template_group_id,
 		P_TEMPLATE_GROUP_NAME => l_task_group.template_group_name,
    		P_SOURCE_OBJECT_TYPE_CODE => l_task_group.source_object_type_code,
		P_START_DATE_ACTIVE => l_task_group.start_date_active,
		P_END_DATE_ACTIVE => l_task_group.end_date_active,
		P_DESCRIPTION => l_task_group.description,
		P_ATTRIBUTE1 => l_task_group.attribute1,
		P_ATTRIBUTE2 => l_task_group.attribute2,
		P_ATTRIBUTE3 => l_task_group.attribute3,
		P_ATTRIBUTE4 => l_task_group.attribute4,
		P_ATTRIBUTE5 => l_task_group.attribute5,
		P_ATTRIBUTE6 => l_task_group.attribute6,
		P_ATTRIBUTE7 => l_task_group.attribute7,
		P_ATTRIBUTE8 => l_task_group.attribute8,
		P_ATTRIBUTE9 => l_task_group.attribute9,
		P_ATTRIBUTE10 => l_task_group.attribute10,
		P_ATTRIBUTE11 => l_task_group.attribute11,
		P_ATTRIBUTE12 => l_task_group.attribute12,
		P_ATTRIBUTE13 => l_task_group.attribute13,
		P_ATTRIBUTE14 => l_task_group.attribute14,
		P_ATTRIBUTE15 => l_task_group.attribute15,
		P_ATTRIBUTE_CATEGORY => l_task_group.attribute_category,
		X_RETURN_STATUS => x_return_status,
		X_MSG_COUNT => x_msg_count,
  		X_MSG_DATA => x_msg_data,
    		X_OBJECT_VERSION_NUMBER => l_object_version_number
	  );

Line: 388

	-- Update the reason type if changed
	IF l_reason_type <> l_task_group.reason_type  THEN
	 UPDATE ozf_reasons
	 SET    REASON_TYPE = l_task_group.reason_type
	 ,      LAST_UPDATE_DATE = sysdate
	 ,      LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id, -1)
	 ,      OBJECT_VERSION_NUMBER = l_object_version_number + 1
	 WHERE  TASK_TEMPLATE_GROUP_ID = l_task_group.task_template_group_id;

Line: 417

		ROLLBACK TO  Update_task_group_PVT;

Line: 426

		ROLLBACK TO  Update_task_group_PVT;

Line: 435

		ROLLBACK TO  Update_task_group_PVT;

Line: 448

END Update_task_group;

Line: 463

PROCEDURE  Delete_task_group (
    p_api_version            IN    NUMBER
   ,p_init_msg_list          IN    VARCHAR2 := FND_API.G_FALSE
   ,p_commit                 IN    VARCHAR2 := FND_API.G_FALSE
   ,p_validation_level       IN    NUMBER   := FND_API.G_VALID_LEVEL_FULL

   ,x_return_status          OUT  NOCOPY VARCHAR2
   ,x_msg_data               OUT  NOCOPY VARCHAR2
   ,x_msg_count              OUT NOCOPY  NUMBER

   ,p_task_template_group_id  	     IN    NUMBER
   ,p_object_version_number  IN    NUMBER
)
IS
l_api_name          CONSTANT VARCHAR2(30) := 'Delete_task_group';

Line: 492

select task_template_group_id
from   ozf_claims_all
where  task_template_group_id = p_id;

Line: 499

	SAVEPOINT  Delete_task_group_PVT;

Line: 538

	  JTF_TASK_TEMP_GROUP_PUB.DELETE_TASK_TEMPLATE_GROUP
	  (
		P_API_VERSION => p_api_version,
		P_INIT_MSG_LIST => FND_API.G_FALSE,
		P_COMMIT => FND_API.G_FALSE,
		P_VALIDATE_LEVEL => p_validation_level,
 		P_TASK_TEMPLATE_GROUP_ID => p_task_template_group_id,
		X_RETURN_STATUS => x_return_status,
		X_MSG_COUNT => x_msg_count,
  		X_MSG_DATA => x_msg_data,
    		X_OBJECT_VERSION_NUMBER => l_object_version_number
	  );

Line: 556

	-- CHECK Check to see if this should be deleted or made inactive
	DELETE FROM ozf_reasons
	WHERE  task_template_group_id = p_task_template_group_id;

Line: 578

		ROLLBACK TO  Delete_task_group_PVT;

Line: 587

		ROLLBACK TO  Delete_task_group_PVT;

Line: 596

		ROLLBACK TO  Delete_task_group_PVT;

Line: 609

END Delete_task_group;

Line: 665

select reason_type
from   ozf_reasons
where  task_template_group_id = cv_temp_group_id;

Line: 886

			p_validation_mode   => JTF_PLSQL_API.g_update,
			x_return_status     => l_return_status
		);

Line: 1232

SELECT * FROM JTF_TASK_TEMP_GROUPS_VL
WHERE TASK_TEMPLATE_GROUP_ID = cv_task_template_group_id;