APPS.OZF_TASK_TEMPLATE_PVT SQL Statements

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

Line: 169

PROCEDURE  Update_TaskTemplate (
    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          IN    ozf_task_template_tbl_type
   ,x_object_version_number  OUT  NOCOPY ozf_number_tbl_type
)
IS
l_api_name          CONSTANT VARCHAR2(30) := 'Update_TaskTemplate';

Line: 197

	SAVEPOINT  Update_TaskTemplate_PVT;

Line: 225

	    JTF_TASK_TEMPLATES_PUB.UPDATE_TASK
	    (
		P_API_VERSION => p_api_version,
		P_INIT_MSG_LIST => FND_API.G_FALSE,
		P_COMMIT => FND_API.G_FALSE,
		P_OBJECT_VERSION_NUMBER => x_object_version_number(i),
		P_TASK_ID => p_task_template(i).task_template_id,
		P_TASK_NUMBER => p_task_template(i).task_number,
		P_TASK_GROUP_ID => p_task_template(i).reason_code_id,
		P_TASK_NAME => p_task_template(i).task_name,
		P_TASK_TYPE_ID => p_task_template(i).task_type_id,
		P_DESCRIPTION => p_task_template(i).description,
		P_TASK_STATUS_ID => p_task_template(i).task_status_id,
		P_TASK_PRIORITY_ID => p_task_template(i).task_priority_id,
		P_DURATION => p_task_template(i).duration,
		P_DURATION_UOM => p_task_template(i).duration_uom,
		X_RETURN_STATUS => x_return_status,
		X_MSG_COUNT => x_msg_count,
  		X_MSG_DATA => x_msg_data
	    );

Line: 269

		ROLLBACK TO  Update_TaskTemplate_PVT;

Line: 278

		ROLLBACK TO  Update_TaskTemplate_PVT;

Line: 287

		ROLLBACK TO  Update_TaskTemplate_PVT;

Line: 300

END Update_TaskTemplate;

Line: 315

PROCEDURE  Delete_TaskTemplate (
    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_id       IN    ozf_number_tbl_type
   ,p_object_version_number  IN    ozf_number_tbl_type
   )
IS
l_api_name          CONSTANT VARCHAR2(30) := 'Delete_TaskTemplate';

Line: 343

	SAVEPOINT  Delete_TaskTemplate_PVT;

Line: 375

	    JTF_TASK_TEMPLATES_PUB.DELETE_TASK
	    (
		P_API_VERSION => p_api_version,
		P_INIT_MSG_LIST => FND_API.G_FALSE,
		P_COMMIT => FND_API.G_FALSE,
		P_OBJECT_VERSION_NUMBER => p_object_version_number(i),
		P_TASK_ID => p_task_template_id(i),
		X_RETURN_STATUS => x_return_status,
		X_MSG_COUNT => x_msg_count,
  		X_MSG_DATA => x_msg_data
	    );

Line: 411

		ROLLBACK TO  Delete_TaskTemplate_PVT;

Line: 420

		ROLLBACK TO  Delete_TaskTemplate_PVT;

Line: 429

		ROLLBACK TO  Delete_TaskTemplate_PVT;

Line: 442

END Delete_TaskTemplate;

Line: 485

SELECT  JTT.TASK_TEMPLATE_ID
, 	JTT.TASK_NAME
, 	JTT.DESCRIPTION
, 	JTT.TASK_GROUP_ID
,	JTG.TEMPLATE_GROUP_NAME
, 	JTT.TASK_NUMBER
, 	JTT.TASK_TYPE_ID
,	JTY.NAME
, 	JTT.TASK_STATUS_ID
,	JTS.NAME
, 	JTT.TASK_PRIORITY_ID
,	JTP.NAME
, 	JTT.DURATION
, 	JTT.DURATION_UOM
, 	JTT.OBJECT_VERSION_NUMBER
, 	JTT.ATTRIBUTE_CATEGORY
, 	JTT.ATTRIBUTE1
, 	JTT.ATTRIBUTE2
, 	JTT.ATTRIBUTE3
, 	JTT.ATTRIBUTE4
, 	JTT.ATTRIBUTE5
, 	JTT.ATTRIBUTE6
, 	JTT.ATTRIBUTE7
, 	JTT.ATTRIBUTE8
, 	JTT.ATTRIBUTE9
, 	JTT.ATTRIBUTE10
, 	JTT.ATTRIBUTE11
, 	JTT.ATTRIBUTE12
, 	JTT.ATTRIBUTE13
, 	JTT.ATTRIBUTE14
, 	JTT.ATTRIBUTE15
FROM 	JTF_TASK_TEMPLATES_VL JTT
,	JTF_TASK_TEMP_GROUPS_VL JTG
,	JTF_TASK_TYPES_VL JTY
,	JTF_TASK_STATUSES_VL JTS
,	JTF_TASK_PRIORITIES_VL JTP
WHERE	JTT.TASK_GROUP_ID = cv_task_group_id
AND	JTT.TASK_GROUP_ID = JTG.TASK_TEMPLATE_GROUP_ID
AND	JTT.TASK_TYPE_ID = JTY.TASK_TYPE_ID
AND	JTT.TASK_STATUS_ID = JTS.TASK_STATUS_ID
AND	JTT.TASK_PRIORITY_ID = JTP.TASK_PRIORITY_ID;

Line: 673

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

Line: 831

SELECT  JTT.TASK_TEMPLATE_ID
,       JTT.TASK_NAME
,       JTT.DESCRIPTION
,       JTT.TASK_GROUP_ID
,       JTG.TEMPLATE_GROUP_NAME
,       JTT.TASK_NUMBER
,       JTT.TASK_TYPE_ID
,       JTY.NAME
,       JTT.TASK_STATUS_ID
,       JTS.NAME
,       JTT.TASK_PRIORITY_ID
,       JTP.NAME
,       JTT.DURATION
,       JTT.DURATION_UOM
,       JTT.OBJECT_VERSION_NUMBER
,       JTT.ATTRIBUTE_CATEGORY
,       JTT.ATTRIBUTE1
,       JTT.ATTRIBUTE2
,       JTT.ATTRIBUTE3
,       JTT.ATTRIBUTE4
,       JTT.ATTRIBUTE5
,       JTT.ATTRIBUTE6
,       JTT.ATTRIBUTE7
,       JTT.ATTRIBUTE8
,       JTT.ATTRIBUTE9
,       JTT.ATTRIBUTE10
,       JTT.ATTRIBUTE11
,       JTT.ATTRIBUTE12
,       JTT.ATTRIBUTE13
,       JTT.ATTRIBUTE14
,       JTT.ATTRIBUTE15
FROM    JTF_TASK_TEMPLATES_VL JTT
,       JTF_TASK_TEMP_GROUPS_VL JTG
,       JTF_TASK_TYPES_VL JTY
,       JTF_TASK_STATUSES_VL JTS
,       JTF_TASK_PRIORITIES_VL JTP
WHERE   JTT.TASK_TEMPLATE_ID = cv_task_template_id
AND     JTT.TASK_GROUP_ID = JTG.TASK_TEMPLATE_GROUP_ID
AND     JTT.TASK_TYPE_ID = JTY.TASK_TYPE_ID
AND     JTT.TASK_STATUS_ID = JTS.TASK_STATUS_ID
AND     JTT.TASK_PRIORITY_ID = JTP.TASK_PRIORITY_ID;