[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT task_template_group_id
FROM jtf_task_temp_groups_b
WHERE task_template_group_id = p_task_template_group_id
AND trunc(NVL (end_date_active, SYSDATE)) >= trunc(SYSDATE)
AND trunc(NVL (start_date_active, SYSDATE)) <= trunc(SYSDATE);
SELECT task_template_id,
task_number,
DECODE (
task_template_record.task_name,
NULL, task_name,
FND_API.G_MISS_CHAR, NULL,
task_template_record.task_name
) task_name,
DECODE (
task_template_record.description,
NULL, description,
FND_API.G_MISS_CHAR, NULL,
task_template_record.description
) description,
DECODE (
task_template_record.task_type_id,
NULL, task_type_id,
FND_API.G_MISS_CHAR, NULL,
task_template_record.task_type_id
) task_type_id,
DECODE (
task_template_record.task_status_id,
NULL, task_status_id,
FND_API.G_MISS_CHAR, NULL,
task_template_record.task_status_id
) task_status_id,
DECODE (
task_template_record.task_priority_id,
NULL, task_priority_id,
FND_API.G_MISS_CHAR, NULL,
task_template_record.task_priority_id
) task_priority_id,
DECODE (
task_template_record.duration,
NULL, duration,
FND_API.G_MISS_CHAR, NULL,
task_template_record.duration
) duration,
DECODE (
task_template_record.duration_uom,
NULL, duration_uom,
FND_API.G_MISS_CHAR, NULL,
task_template_record.duration_uom
) duration_uom,
DECODE (
task_template_record.planned_effort,
NULL, planned_effort,
FND_API.G_MISS_CHAR, NULL,
task_template_record.planned_effort
) planned_effort,
DECODE (
task_template_record.planned_effort_uom,
NULL, planned_effort_uom,
FND_API.G_MISS_CHAR, NULL,
task_template_record.planned_effort_uom
) planned_effort_uom,
DECODE (
task_template_record.private_flag,
NULL, private_flag,
FND_API.G_MISS_CHAR, NULL,
task_template_record.private_flag
) private_flag,
publish_flag,
DECODE (
task_template_record.restrict_closure_flag,
NULL, restrict_closure_flag,
FND_API.G_MISS_CHAR, NULL,
task_template_record.restrict_closure_flag
) restrict_closure_flag,
multi_booked_flag,
milestone_flag,
holiday_flag,
billable_flag,
notification_flag,
notification_period,
notification_period_uom,
recurrence_rule_id,
alarm_start,
alarm_start_uom,
alarm_on,
alarm_count,
alarm_interval,
alarm_interval_uom,
task_template_record.palm_flag palm_flag,
task_template_record.wince_flag wince_flag,
task_template_record.laptop_flag laptop_flag,
task_template_record.device1_flag device1_flag,
task_template_record.device2_flag device2_flag,
task_template_record.device3_flag device3_flag,
task_template_record.timezone_id timezone_id,
DECODE (
task_template_record.attribute1,
NULL, attribute1,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute1
) attribute1,
DECODE (
task_template_record.attribute2,
NULL, attribute2,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute2
) attribute2,
DECODE (
task_template_record.attribute3,
NULL, attribute3,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute3
) attribute3,
DECODE (
task_template_record.attribute4,
NULL, attribute4,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute4
) attribute4,
DECODE (
task_template_record.attribute5,
NULL, attribute5,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute5
) attribute5,
DECODE (
task_template_record.attribute6,
NULL, attribute6,
task_template_record.attribute6
) attribute6,
DECODE (
task_template_record.attribute7,
NULL, attribute7,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute7
) attribute7,
DECODE (
task_template_record.attribute8,
NULL, attribute8,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute8
) attribute8,
DECODE (
task_template_record.attribute9,
NULL, attribute9,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute9
) attribute9,
DECODE (
task_template_record.attribute10,
NULL, attribute10,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute10
) attribute10,
DECODE (
task_template_record.attribute11,
NULL, attribute11,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute11
) attribute11,
DECODE (
task_template_record.attribute12,
NULL, attribute12,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute12
) attribute12,
DECODE (
task_template_record.attribute13,
NULL, attribute13,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute13
) attribute13,
DECODE (
task_template_record.attribute14,
NULL, attribute14,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute14
) attribute14,
DECODE (
task_template_record.attribute15,
NULL, attribute15,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute15
) attribute15,
DECODE (
task_template_record.attribute_category,
NULL, attribute_category,
FND_API.G_MISS_CHAR, NULL,
task_template_record.attribute_category
) attribute_category,
DECODE (
task_template_record.task_confirmation_status,
NULL,task_confirmation_status,
jtf_task_utl.G_MISS_CHAR, NULL,
task_template_record.task_confirmation_status
) task_confirmation_status
FROM jtf_task_templates_vl
WHERE task_group_id = p_task_template_group_id
AND task_template_id = task_template_record.task_template_id;
Select object_version_number From JTF_TASKS_VL
Where task_id=p_task_id;
p_date_selected => p_task_template_info.p_date_selected,
p_show_on_calendar => p_task_template_info.show_on_calendar,
p_template_id => l_task_template_rec.task_template_id,
p_template_group_id => p_task_template_group_info.task_template_group_id,
p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
p_abort_workflow => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
p_task_split_flag => NULL,
p_reference_flag => NULL,
p_child_position => NULL,
p_child_sequence_num => NULL,
p_location_id => p_task_template_group_info.location_id
);
SELECT task_template_id,
task_number,
task_name,
description,
task_type_id,
task_status_id,
task_priority_id,
duration,
duration_uom,
planned_effort,
planned_effort_uom,
private_flag,
publish_flag,
restrict_closure_flag,
multi_booked_flag,
milestone_flag,
holiday_flag,
billable_flag,
notification_flag,
notification_period,
notification_period_uom,
recurrence_rule_id,
alarm_start,
alarm_start_uom,
alarm_on,
alarm_count,
alarm_interval,
alarm_interval_uom,
p_task_template_group_info.owner_type_code,
p_task_template_group_info.owner_id,
p_task_template_group_info.owner_territory_id, -- Added by SBARAT on 28/10/2005 for bug# 4597321
p_task_template_group_info.source_object_id,
p_task_template_group_info.source_object_name,
p_task_template_group_info.cust_account_id,
p_task_template_group_info.customer_id,
p_task_template_group_info.address_id,
p_task_template_group_info.assigned_by_id,
p_task_template_group_info.actual_start_date,
p_task_template_group_info.actual_end_date,
p_task_template_group_info.planned_start_date,
p_task_template_group_info.planned_end_date,
p_task_template_group_info.scheduled_start_date,
p_task_template_group_info.scheduled_end_date,
p_task_template_group_info.palm_flag palm_flag,
p_task_template_group_info.wince_flag wince_flag,
p_task_template_group_info.laptop_flag laptop_flag,
p_task_template_group_info.device1_flag device1_flag,
p_task_template_group_info.device2_flag device2_flag,
p_task_template_group_info.device3_flag device3_flag,
p_task_template_group_info.parent_task_id, -- Added by SBARAT on 11/07/2005 for bug# 4376274
p_task_template_group_info.timezone_id timezone_id,
p_task_template_group_info.percentage_complete,
p_task_template_group_info.actual_effort,
p_task_template_group_info.actual_effort_uom,
p_task_template_group_info.reason_code,
p_task_template_group_info.bound_mode_code,
p_task_template_group_info.soft_bound_flag,
p_task_template_group_info.workflow_process_id,
p_task_template_group_info.costs,
p_task_template_group_info.currency_code,
p_task_template_group_info.date_selected,
p_task_template_group_info.show_on_calendar,
DECODE (
p_task_template_group_info.attribute1,
NULL, attribute1,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute1
) attribute1,
DECODE (
p_task_template_group_info.attribute2,
NULL, attribute2,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute2
) attribute2,
DECODE (
p_task_template_group_info.attribute3,
NULL, attribute3,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute3
) attribute3,
DECODE (
p_task_template_group_info.attribute4,
NULL, attribute4,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute4
) attribute4,
DECODE (
p_task_template_group_info.attribute5,
NULL, attribute5,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute5
) attribute5,
DECODE (
p_task_template_group_info.attribute6,
NULL, attribute6,
p_task_template_group_info.attribute6
) attribute6,
DECODE (
p_task_template_group_info.attribute7,
NULL, attribute7,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute7
) attribute7,
DECODE (
p_task_template_group_info.attribute8,
NULL, attribute8,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute8
) attribute8,
DECODE (
p_task_template_group_info.attribute9,
NULL, attribute9,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute9
) attribute9,
DECODE (
p_task_template_group_info.attribute10,
NULL, attribute10,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute10
) attribute10,
DECODE (
p_task_template_group_info.attribute11,
NULL, attribute11,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute11
) attribute11,
DECODE (
p_task_template_group_info.attribute12,
NULL, attribute12,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute12
) attribute12,
DECODE (
p_task_template_group_info.attribute13,
NULL, attribute13,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute13
) attribute13,
DECODE (
p_task_template_group_info.attribute14,
NULL, attribute14,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute14
) attribute14,
DECODE (
p_task_template_group_info.attribute15,
NULL, attribute15,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute15
) attribute15,
DECODE (
p_task_template_group_info.attribute_category,
NULL, attribute_category,
FND_API.G_MISS_CHAR, NULL,
p_task_template_group_info.attribute_category
) attribute_category,
decode (
task_confirmation_status,
null, 'N',
task_confirmation_status
) task_confirmation_status
FROM jtf_task_templates_vl
WHERE task_group_id = p_task_template_group_info.task_template_group_id
AND nvl(deleted_flag,'N') <> 'Y'
ORDER BY task_template_id;
Select object_version_number From JTF_TASKS_VL
Where task_id=p_task_id;
p_date_selected => task_template_rec.date_selected,
p_show_on_calendar => task_template_rec.show_on_calendar,
p_template_id => task_template_rec.task_template_id,
p_template_group_id => p_task_template_group_info.task_template_group_id,
p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
p_abort_workflow => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
p_task_split_flag => NULL,
p_reference_flag => NULL,
p_child_position => NULL,
p_child_sequence_num => NULL,
p_location_id => p_task_template_group_info.location_id
);
SELECT resource_type_code,
required_units,
task_type_id,
task_id,
enabled_flag,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_category
FROM jtf_task_rsc_reqs
WHERE task_id = p_task_template_id;
SELECT occurs_which,
day_of_week,
date_of_month,
occurs_month,
occurs_uom,
occurs_every,
occurs_number,
start_date_active,
end_date_active
FROM jtf_task_recur_rules
WHERE recurrence_rule_id = p_recurrence_rule_id;