The following lines contain the word 'select', 'insert', 'update' or 'delete':
v_select VARCHAR2(6000);
SELECT jtf_task_temp_groups_s.nextval
INTO v_task_template_group_id
FROM dual;
jtf_task_temp_groups_pkg.insert_row (
v_rowid,
v_task_template_group_id,
p_source_object_type_code,
p_start_date_active,
p_end_date_active,
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,
p_template_group_name,
p_description,
SYSDATE,
fnd_global.user_id,
SYSDATE,
fnd_global.user_id,
fnd_global.login_id,
p_application_id
);
PROCEDURE update_task_template_group (
p_commit IN VARCHAR2,
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_name VARCHAR2(30) := 'UPDATE_TASK_TEMPLATE_GROUP';
SAVEPOINT update_template_group_pvt;
jtf_task_temp_groups_pkg.update_row (
p_task_template_group_id,
x_object_version_number,
p_source_object_type_code,
p_start_date_active,
p_end_date_active,
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,
p_template_group_name,
p_description,
SYSDATE,
fnd_global.user_id,
fnd_global.login_id,
p_application_id
);
ROLLBACK TO update_template_group_pvt;
ROLLBACK TO update_template_group_pvt;
ROLLBACK TO update_template_group_pvt;
END update_task_template_group;
PROCEDURE delete_task_template_group (
p_commit IN VARCHAR2,
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
)
IS
l_api_name VARCHAR2(30) := 'DELETE_TASK_TEMPLATE_GROUP';
SAVEPOINT delete_template_group_pvt;
jtf_task_temp_groups_pkg.delete_row (p_task_template_group_id);
ROLLBACK TO delete_template_group_pvt;
ROLLBACK TO delete_template_group_pvt;
ROLLBACK TO delete_template_group_pvt;
END delete_task_template_group;
v_select := 'select TASK_TEMPLATE_GROUP_ID,' ||
'TEMPLATE_GROUP_NAME,' ||
'SOURCE_OBJECT_TYPE_CODE,' ||
'START_DATE_ACTIVE,' ||
'END_DATE_ACTIVE,' ||
'DESCRIPTION,' ||
'ATTRIBUTE1,' ||
'ATTRIBUTE2,' ||
'ATTRIBUTE3,' ||
'ATTRIBUTE4,' ||
'ATTRIBUTE5,' ||
'ATTRIBUTE6,' ||
'ATTRIBUTE7,' ||
'ATTRIBUTE8,' ||
'ATTRIBUTE9,' ||
'ATTRIBUTE10,' ||
'ATTRIBUTE11,' ||
'ATTRIBUTE12,' ||
'ATTRIBUTE13,' ||
'ATTRIBUTE14,' ||
'ATTRIBUTE15,' ||
'ATTRIBUTE_CATEGORY,' ||
'object_version_number ,' ||
'APPLICATION_ID ' ||
'from jtf_task_temp_groups_vl ';
v_select := v_select || ' where ' || v_where;
v_select := v_select || ' order by ';
v_select := v_select ||
v_comma ||
p_sort_data (v_index).field_name ||
' ';
v_select := v_select || 'asc ';
v_select := v_select || 'desc ';
x_task_template_group.DELETE;
v_tbl.DELETE;
dump_long_line ('v_sel:', v_select);
DBMS_SQL.parse (v_cursor_id, v_select, DBMS_SQL.v7);