The following lines contain the word 'select', 'insert', 'update' or 'delete':
select null
from jtf_task_temp_groups_vl
where task_template_group_id = p_task_template_group_id;
select null
from jtf_task_temp_groups_vl
where template_group_name = p_task_template_group_name;
select null
from jtf_task_temp_groups_vl
where template_group_name = p_task_template_group_name
and task_template_group_id <> p_task_template_group_id;
select null
from jtf_objects_vl
where object_code = p_src_obj_typ
and trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
and trunc(nvl(end_date_active, sysdate));
Procedure UPDATE_TASK_TEMPLATE_GROUP
(
P_API_VERSION IN NUMBER,
P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
P_COMMIT IN VARCHAR2 default fnd_api.g_false,
P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
P_TASK_TEMPLATE_GROUP_ID IN NUMBER,
P_TEMPLATE_GROUP_NAME IN VARCHAR2,
P_SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,
P_START_DATE_ACTIVE IN DATE,
P_END_DATE_ACTIVE IN DATE,
P_DESCRIPTION IN VARCHAR2,
P_ATTRIBUTE1 IN VARCHAR2,
P_ATTRIBUTE2 IN VARCHAR2,
P_ATTRIBUTE3 IN VARCHAR2,
P_ATTRIBUTE4 IN VARCHAR2,
P_ATTRIBUTE5 IN VARCHAR2,
P_ATTRIBUTE6 IN VARCHAR2,
P_ATTRIBUTE7 IN VARCHAR2,
P_ATTRIBUTE8 IN VARCHAR2,
P_ATTRIBUTE9 IN VARCHAR2,
P_ATTRIBUTE10 IN VARCHAR2,
P_ATTRIBUTE11 IN VARCHAR2,
P_ATTRIBUTE12 IN VARCHAR2,
P_ATTRIBUTE13 IN VARCHAR2,
P_ATTRIBUTE14 IN VARCHAR2,
P_ATTRIBUTE15 IN VARCHAR2,
P_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2,
X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
p_application_id IN NUMBER default null
) is
l_api_version constant number := 1.0;
l_api_name constant varchar2(30) := 'UPDATE_TASK_TEMPLATE_GROUP' ;
savepoint update_task_template_group;
jtf_task_temp_group_pvt.update_task_template_group
(
P_COMMIT,
P_TASK_TEMPLATE_GROUP_ID,
P_TEMPLATE_GROUP_NAME,
P_SOURCE_OBJECT_TYPE_CODE,
P_START_DATE_ACTIVE,
P_END_DATE_ACTIVE,
P_DESCRIPTION,
P_ATTRIBUTE1,
P_ATTRIBUTE2,
P_ATTRIBUTE3,
P_ATTRIBUTE4,
P_ATTRIBUTE5,
P_ATTRIBUTE6,
P_ATTRIBUTE7,
P_ATTRIBUTE8,
P_ATTRIBUTE9,
P_ATTRIBUTE10,
P_ATTRIBUTE11,
P_ATTRIBUTE12,
P_ATTRIBUTE13,
P_ATTRIBUTE14,
P_ATTRIBUTE15,
P_ATTRIBUTE_CATEGORY,
X_RETURN_STATUS,
X_MSG_COUNT,
X_MSG_DATA,
X_OBJECT_VERSION_NUMBER,
P_APPLICATION_ID
);
ROLLBACK TO update_task_template_group;
ROLLBACK TO update_task_template_group;
ROLLBACK TO update_task_template_group;
end UPDATE_TASK_TEMPLATE_GROUP;
Procedure DELETE_TASK_TEMPLATE_GROUP
(
P_API_VERSION IN NUMBER,
P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
P_COMMIT IN VARCHAR2 default fnd_api.g_false,
P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
P_TASK_TEMPLATE_GROUP_ID IN NUMBER,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2,
X_OBJECT_VERSION_NUMBER IN NUMBER
) is
l_api_version constant number := 1.0;
l_api_name constant varchar2(30) := 'DELETE_TASK_TEMPLATE_GROUP' ;
savepoint delete_task_template_group;
jtf_task_temp_group_pvt.delete_task_template_group
(
P_COMMIT,
P_TASK_TEMPLATE_GROUP_ID,
X_RETURN_STATUS,
X_MSG_COUNT,
X_MSG_DATA
);
ROLLBACK TO delete_task_template_group;
ROLLBACK TO delete_task_template_group;
ROLLBACK TO delete_task_template_group;
end delete_task_template_group;