[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
v_select VARCHAR2(6000);
, p_date_selected IN VARCHAR2 DEFAULT NULL
, p_category_id IN NUMBER DEFAULT NULL
, p_show_on_calendar IN VARCHAR2 DEFAULT NULL
, p_owner_status_id IN NUMBER DEFAULT NULL
, p_template_id IN NUMBER DEFAULT NULL
, p_template_group_id IN NUMBER DEFAULT NULL
) IS
l_api_version CONSTANT NUMBER := 1.0;
, p_date_selected => p_date_selected
, p_category_id => p_category_id
, p_show_on_calendar => p_show_on_calendar
, p_owner_status_id => p_owner_status_id
, p_template_id => p_template_id
, p_template_group_id => p_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_entity => g_entity
, p_free_busy_type => NULL
, p_task_confirmation_status => 'N'
, p_task_confirmation_counter => NULL
, p_task_split_flag => NULL
, p_reference_flag => NULL
, p_child_position => NULL
, p_child_sequence_num => NULL
);
, p_date_selected IN VARCHAR2 DEFAULT NULL
, p_category_id IN NUMBER DEFAULT NULL
, p_show_on_calendar IN VARCHAR2 DEFAULT NULL
, p_owner_status_id IN NUMBER DEFAULT NULL
, p_template_id IN NUMBER DEFAULT NULL
, p_template_group_id IN NUMBER DEFAULT NULL
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
) IS
l_api_version CONSTANT NUMBER := 1.0;
, p_date_selected => p_date_selected
, p_category_id => p_category_id
, p_show_on_calendar => p_show_on_calendar
, p_owner_status_id => p_owner_status_id
, p_template_id => p_template_id
, p_template_group_id => p_template_group_id
, p_enable_workflow => p_enable_workflow
, p_abort_workflow => p_abort_workflow
, p_entity => g_entity
, p_free_busy_type => NULL
, p_task_confirmation_status => 'N'
, p_task_confirmation_counter => NULL
, p_task_split_flag => NULL
, p_reference_flag => NULL
, p_child_position => NULL
, p_child_sequence_num => NULL
);
, p_date_selected IN VARCHAR2 DEFAULT NULL
, p_category_id IN NUMBER DEFAULT NULL
, p_show_on_calendar IN VARCHAR2 DEFAULT NULL
, p_owner_status_id IN NUMBER DEFAULT NULL
, p_template_id IN NUMBER DEFAULT NULL
, p_template_group_id IN NUMBER DEFAULT NULL
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
, p_entity IN VARCHAR2
, p_free_busy_type IN VARCHAR2
) IS
l_api_version CONSTANT NUMBER := 1.0;
, p_date_selected => p_date_selected
, p_category_id => p_category_id
, p_show_on_calendar => p_show_on_calendar
, p_owner_status_id => p_owner_status_id
, p_template_id => p_template_id
, p_template_group_id => p_template_group_id
, p_enable_workflow => p_enable_workflow
, p_abort_workflow => p_abort_workflow
, p_entity => p_entity
, p_free_busy_type => p_free_busy_type
, p_task_confirmation_status => 'N'
, p_task_confirmation_counter => NULL
, p_task_split_flag => NULL
, p_reference_flag => NULL
, p_child_position => NULL
, p_child_sequence_num => NULL
);
, p_date_selected IN VARCHAR2 DEFAULT NULL
, p_category_id IN NUMBER DEFAULT NULL
, p_show_on_calendar IN VARCHAR2 DEFAULT NULL
, p_owner_status_id IN NUMBER DEFAULT NULL
, p_template_id IN NUMBER DEFAULT NULL
, p_template_group_id IN NUMBER DEFAULT NULL
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
, p_entity IN VARCHAR2
, p_free_busy_type IN VARCHAR2
, p_task_confirmation_status IN VARCHAR2
, p_task_confirmation_counter IN NUMBER
, p_task_split_flag IN VARCHAR2
, p_reference_flag IN VARCHAR2 DEFAULT NULL
, p_child_position IN VARCHAR2 DEFAULT NULL
, p_child_sequence_num IN NUMBER DEFAULT NULL
) IS
l_api_version CONSTANT NUMBER := 1.0;
, p_date_selected => p_date_selected
, p_category_id => p_category_id
, p_show_on_calendar => p_show_on_calendar
, p_owner_status_id => p_owner_status_id
, p_template_id => p_template_id
, p_template_group_id => p_template_group_id
, p_enable_workflow => p_enable_workflow
, p_abort_workflow => p_abort_workflow
, p_entity => p_entity
, p_free_busy_type => p_free_busy_type
, p_task_confirmation_status => p_task_confirmation_status
, p_task_confirmation_counter => p_task_confirmation_counter
, p_task_split_flag => p_task_split_flag
, p_reference_flag => p_reference_flag
, p_child_position => p_child_position
, p_child_sequence_num => p_child_sequence_num
, p_location_id => NULL
);
, p_date_selected IN VARCHAR2 DEFAULT NULL
, p_category_id IN NUMBER DEFAULT NULL
, p_show_on_calendar IN VARCHAR2 DEFAULT NULL
, p_owner_status_id IN NUMBER DEFAULT NULL
, p_template_id IN NUMBER DEFAULT NULL
, p_template_group_id IN NUMBER DEFAULT NULL
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
, p_entity IN VARCHAR2
, p_free_busy_type IN VARCHAR2
, p_task_confirmation_status IN VARCHAR2
, p_task_confirmation_counter IN NUMBER
, p_task_split_flag IN VARCHAR2
, p_reference_flag IN VARCHAR2 DEFAULT NULL
, p_child_position IN VARCHAR2 DEFAULT NULL
, p_child_sequence_num IN NUMBER DEFAULT NULL
, p_location_id IN NUMBER
, p_copied_from_task_id IN NUMBER DEFAULT NULL
) IS
l_api_version CONSTANT NUMBER := 1.0;
l_date_selected jtf_tasks_b.date_selected%TYPE;
SELECT resource_type_code, required_units, enabled_flag
FROM jtf_task_rsc_reqs
WHERE task_type_id = l_task_type_id;
SELECT 'Y'
FROM jtf_tasks_b
WHERE task_id = p_task_id;
SELECT jtf_task_number_s.NEXTVAL
INTO l_task_number
FROM DUAL;
SELECT jtf_tasks_s.NEXTVAL
INTO x_task_id
FROM DUAL;
SELECT jtf_task_number_s.NEXTVAL
INTO l_task_number
FROM DUAL;
, p_date_selected => p_date_selected
, p_planned_start_date => l_planned_start_date
, p_planned_end_date => l_planned_end_date
, p_scheduled_start_date => l_scheduled_start_date
, p_scheduled_end_date => l_scheduled_end_date
, p_actual_start_date => l_actual_start_date
, p_actual_end_date => l_actual_end_date
, x_show_on_calendar => l_show_on_calendar
, x_date_selected => l_date_selected
, x_calendar_start_date => l_calendar_start_date
, x_calendar_end_date => l_calendar_end_date
, x_return_status => x_return_status
, p_task_status_id => l_task_status_id-- Enhancement 2683868: new parameter
, p_creation_date => SYSDATE -- Enhancement 2683868: new parameter
);
IF p_date_selected IS NULL OR p_date_selected = fnd_api.g_miss_char THEN
IF l_date_selected = 'P' THEN
l_planned_start_date := l_calendar_start_date;
ELSIF l_date_selected = 'S' THEN
l_scheduled_start_date := l_calendar_start_date;
ELSIF l_date_selected = 'A' THEN
l_actual_start_date := l_calendar_start_date;
jtf_tasks_pub.p_task_user_hooks.date_selected := l_date_selected;
jtf_tasks_pkg.insert_row(
x_rowid => l_rowid
, x_task_id => x_task_id
, x_source_object_id => l_source_object_id
, x_source_object_name => l_source_object_name
, x_duration => l_duration
, x_duration_uom => l_duration_uom
, x_planned_effort => l_planned_effort
, x_planned_effort_uom => l_planned_effort_uom
, x_actual_effort => l_actual_effort
, x_actual_effort_uom => l_actual_effort_uom
, x_percentage_complete => l_percentage_complete
, x_reason_code => l_reason_code
, x_private_flag => p_private_flag
, x_publish_flag => p_publish_flag
, x_restrict_closure_flag => p_restrict_closure_flag
, x_multi_booked_flag => p_multi_booked_flag
, x_milestone_flag => p_milestone_flag
, x_holiday_flag => p_holiday_flag
, x_billable_flag => p_billable_flag
, x_bound_mode_code => p_bound_mode_code
, x_soft_bound_flag => p_soft_bound_flag
, x_workflow_process_id => p_workflow_process_id
, x_costs => p_costs
, x_currency_code => p_currency_code
, x_notification_flag => p_notification_flag
, x_notification_period => p_notification_period
, x_notification_period_uom => p_notification_period_uom
, x_parent_task_id => p_parent_task_id
, x_recurrence_rule_id => NULL
, x_alarm_start => p_alarm_start
, x_alarm_start_uom => p_alarm_start_uom
, x_alarm_on => p_alarm_on
, x_alarm_count => p_alarm_count
, x_alarm_fired_count => NULL
, x_alarm_interval => p_alarm_interval
, x_alarm_interval_uom => p_alarm_interval_uom
, x_deleted_flag => 'N'
, x_palm_flag => p_palm_flag
, x_wince_flag => p_wince_flag
, x_laptop_flag => p_laptop_flag
, x_device1_flag => p_device1_flag
, x_device2_flag => p_device2_flag
, x_device3_flag => p_device3_flag
, x_attribute1 => p_attribute1
, x_attribute2 => p_attribute2
, x_attribute3 => p_attribute3
, x_attribute4 => p_attribute4
, x_attribute5 => p_attribute5
, x_attribute6 => p_attribute6
, x_attribute7 => p_attribute7
, x_attribute8 => p_attribute8
, x_attribute9 => p_attribute9
, x_attribute10 => p_attribute10
, x_attribute11 => p_attribute11
, x_attribute12 => p_attribute12
, x_attribute13 => p_attribute13
, x_attribute14 => p_attribute14
, x_attribute15 => p_attribute15
, x_attribute_category => p_attribute_category
, x_task_number => l_task_number
, x_task_type_id => l_task_type_id
, x_task_status_id => l_task_status_id
, x_task_priority_id => l_task_priority_id
, x_owner_id => l_owner_id
, x_owner_type_code => l_owner_type_code
, x_owner_territory_id => p_owner_territory_id
, x_assigned_by_id => p_assigned_by_id
, x_cust_account_id => p_cust_account_id
, x_customer_id => p_customer_id
, x_address_id => p_address_id
, x_planned_start_date => l_planned_start_date
, x_planned_end_date => l_planned_end_date
, x_scheduled_start_date => l_scheduled_start_date
, x_scheduled_end_date => l_scheduled_end_date
, x_actual_start_date => l_actual_start_date
, x_actual_end_date => l_actual_end_date
, x_source_object_type_code => l_source_object_type_code
, x_timezone_id => p_timezone_id
, x_task_name => p_task_name
, x_description => p_description
, x_creation_date => SYSDATE
, x_created_by => jtf_task_utl.created_by
, x_last_update_date => SYSDATE
, x_last_updated_by => jtf_task_utl.updated_by
, x_last_update_login => jtf_task_utl.login_id
, x_escalation_level => p_escalation_level
, x_calendar_start_date => l_calendar_start_date
, x_calendar_end_date => l_calendar_end_date
, x_date_selected => l_date_selected
, x_template_id => p_template_id
, x_template_group_id => p_template_group_id
, x_open_flag => jtf_task_utl_ext.get_open_flag(l_task_status_id) -- Enhancement# 2666995
, x_entity => l_entity -- enh# 3535354
, x_task_confirmation_status => l_task_confirmation_status
, x_task_confirmation_counter => p_task_confirmation_counter
, x_task_split_flag => p_task_split_flag
, x_child_position => p_child_position
, x_child_sequence_num => p_child_sequence_num
, x_location_id => p_location_id
);
PROCEDURE update_task(
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_object_version_number IN OUT NOCOPY NUMBER
, p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
, ---- hz_party_sites
p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
, p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
, p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
, p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
) IS
BEGIN
SAVEPOINT update_task_pvt1;
update_task(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => fnd_api.g_false
, -- FALSE
p_object_version_number => p_object_version_number
, p_task_id => p_task_id
, p_task_name => p_task_name
, p_task_type_id => p_task_type_id
, p_description => p_description
, p_task_status_id => p_task_status_id
, p_task_priority_id => p_task_priority_id
, p_owner_type_code => p_owner_type_code
, p_owner_id => p_owner_id
, p_owner_territory_id => p_owner_territory_id
, p_assigned_by_id => p_assigned_by_id
, p_customer_id => p_customer_id
, p_cust_account_id => p_cust_account_id
, p_address_id => p_address_id
, p_planned_start_date => p_planned_start_date
, p_planned_end_date => p_planned_end_date
, p_scheduled_start_date => p_scheduled_start_date
, p_scheduled_end_date => p_scheduled_end_date
, p_actual_start_date => p_actual_start_date
, p_actual_end_date => p_actual_end_date
, p_timezone_id => p_timezone_id
, p_source_object_type_code => p_source_object_type_code
, p_source_object_id => p_source_object_id
, p_source_object_name => p_source_object_name
, p_duration => p_duration
, p_duration_uom => p_duration_uom
, p_planned_effort => p_planned_effort
, p_planned_effort_uom => p_planned_effort_uom
, p_actual_effort => p_actual_effort
, p_actual_effort_uom => p_actual_effort_uom
, p_percentage_complete => p_percentage_complete
, p_reason_code => p_reason_code
, p_private_flag => p_private_flag
, p_publish_flag => p_publish_flag
, p_restrict_closure_flag => p_restrict_closure_flag
, p_multi_booked_flag => p_multi_booked_flag
, p_milestone_flag => p_milestone_flag
, p_holiday_flag => p_holiday_flag
, p_billable_flag => p_billable_flag
, p_bound_mode_code => p_bound_mode_code
, p_soft_bound_flag => p_soft_bound_flag
, p_workflow_process_id => p_workflow_process_id
, p_notification_flag => p_notification_flag
, p_notification_period => p_notification_period
, p_notification_period_uom => p_notification_period_uom
, p_parent_task_id => p_parent_task_id
, p_alarm_start => p_alarm_start
, p_alarm_start_uom => p_alarm_start_uom
, p_alarm_on => p_alarm_on
, p_alarm_count => p_alarm_count
, p_alarm_fired_count => p_alarm_fired_count
, p_alarm_interval => p_alarm_interval
, p_alarm_interval_uom => p_alarm_interval_uom
, p_palm_flag => p_palm_flag
, p_wince_flag => p_wince_flag
, p_laptop_flag => p_laptop_flag
, p_device1_flag => p_device1_flag
, p_device2_flag => p_device2_flag
, p_device3_flag => p_device3_flag
, p_costs => p_costs
, p_currency_code => p_currency_code
, p_escalation_level => p_escalation_level
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_attribute1 => p_attribute1
, p_attribute2 => p_attribute2
, p_attribute3 => p_attribute3
, p_attribute4 => p_attribute4
, p_attribute5 => p_attribute5
, p_attribute6 => p_attribute6
, p_attribute7 => p_attribute7
, p_attribute8 => p_attribute8
, p_attribute9 => p_attribute9
, p_attribute10 => p_attribute10
, p_attribute11 => p_attribute11
, p_attribute12 => p_attribute12
, p_attribute13 => p_attribute13
, p_attribute14 => p_attribute14
, p_attribute15 => p_attribute15
, p_attribute_category => p_attribute_category
, p_date_selected => p_date_selected
, p_category_id => p_category_id
, p_show_on_calendar => p_show_on_calendar
, p_owner_status_id => p_owner_status_id
, p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
, p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
, p_change_mode => jtf_task_repeat_appt_pvt.g_one
, p_free_busy_type => jtf_task_utl.g_miss_char
);
ROLLBACK TO update_task_pvt1;
ROLLBACK TO update_task_pvt1;
PROCEDURE update_task(
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_object_version_number IN OUT NOCOPY NUMBER
, p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
, ---- hz_party_sites
p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
, p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
, p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
, p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
) IS
BEGIN
SAVEPOINT update_task_pvt2;
update_task(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => fnd_api.g_false
, -- FALSE
p_object_version_number => p_object_version_number
, p_task_id => p_task_id
, p_task_name => p_task_name
, p_task_type_id => p_task_type_id
, p_description => p_description
, p_task_status_id => p_task_status_id
, p_task_priority_id => p_task_priority_id
, p_owner_type_code => p_owner_type_code
, p_owner_id => p_owner_id
, p_owner_territory_id => p_owner_territory_id
, p_assigned_by_id => p_assigned_by_id
, p_customer_id => p_customer_id
, p_cust_account_id => p_cust_account_id
, p_address_id => p_address_id
, p_planned_start_date => p_planned_start_date
, p_planned_end_date => p_planned_end_date
, p_scheduled_start_date => p_scheduled_start_date
, p_scheduled_end_date => p_scheduled_end_date
, p_actual_start_date => p_actual_start_date
, p_actual_end_date => p_actual_end_date
, p_timezone_id => p_timezone_id
, p_source_object_type_code => p_source_object_type_code
, p_source_object_id => p_source_object_id
, p_source_object_name => p_source_object_name
, p_duration => p_duration
, p_duration_uom => p_duration_uom
, p_planned_effort => p_planned_effort
, p_planned_effort_uom => p_planned_effort_uom
, p_actual_effort => p_actual_effort
, p_actual_effort_uom => p_actual_effort_uom
, p_percentage_complete => p_percentage_complete
, p_reason_code => p_reason_code
, p_private_flag => p_private_flag
, p_publish_flag => p_publish_flag
, p_restrict_closure_flag => p_restrict_closure_flag
, p_multi_booked_flag => p_multi_booked_flag
, p_milestone_flag => p_milestone_flag
, p_holiday_flag => p_holiday_flag
, p_billable_flag => p_billable_flag
, p_bound_mode_code => p_bound_mode_code
, p_soft_bound_flag => p_soft_bound_flag
, p_workflow_process_id => p_workflow_process_id
, p_notification_flag => p_notification_flag
, p_notification_period => p_notification_period
, p_notification_period_uom => p_notification_period_uom
, p_parent_task_id => p_parent_task_id
, p_alarm_start => p_alarm_start
, p_alarm_start_uom => p_alarm_start_uom
, p_alarm_on => p_alarm_on
, p_alarm_count => p_alarm_count
, p_alarm_fired_count => p_alarm_fired_count
, p_alarm_interval => p_alarm_interval
, p_alarm_interval_uom => p_alarm_interval_uom
, p_palm_flag => p_palm_flag
, p_wince_flag => p_wince_flag
, p_laptop_flag => p_laptop_flag
, p_device1_flag => p_device1_flag
, p_device2_flag => p_device2_flag
, p_device3_flag => p_device3_flag
, p_costs => p_costs
, p_currency_code => p_currency_code
, p_escalation_level => p_escalation_level
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_attribute1 => p_attribute1
, p_attribute2 => p_attribute2
, p_attribute3 => p_attribute3
, p_attribute4 => p_attribute4
, p_attribute5 => p_attribute5
, p_attribute6 => p_attribute6
, p_attribute7 => p_attribute7
, p_attribute8 => p_attribute8
, p_attribute9 => p_attribute9
, p_attribute10 => p_attribute10
, p_attribute11 => p_attribute11
, p_attribute12 => p_attribute12
, p_attribute13 => p_attribute13
, p_attribute14 => p_attribute14
, p_attribute15 => p_attribute15
, p_attribute_category => p_attribute_category
, p_date_selected => p_date_selected
, p_category_id => p_category_id
, p_show_on_calendar => p_show_on_calendar
, p_owner_status_id => p_owner_status_id
, p_enable_workflow => p_enable_workflow
, p_abort_workflow => p_abort_workflow
, p_change_mode => jtf_task_repeat_appt_pvt.g_one
, p_free_busy_type => jtf_task_utl.g_miss_char
);
ROLLBACK TO update_task_pvt2;
ROLLBACK TO update_task_pvt2;
PROCEDURE update_task(
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_object_version_number IN OUT NOCOPY NUMBER
, p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
, ---- hz_party_sites
p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
, p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
, p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
, p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
, p_change_mode IN VARCHAR2
) IS
BEGIN
SAVEPOINT update_task_pvt3;
update_task(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => fnd_api.g_false
, -- FALSE
p_object_version_number => p_object_version_number
, p_task_id => p_task_id
, p_task_name => p_task_name
, p_task_type_id => p_task_type_id
, p_description => p_description
, p_task_status_id => p_task_status_id
, p_task_priority_id => p_task_priority_id
, p_owner_type_code => p_owner_type_code
, p_owner_id => p_owner_id
, p_owner_territory_id => p_owner_territory_id
, p_assigned_by_id => p_assigned_by_id
, p_customer_id => p_customer_id
, p_cust_account_id => p_cust_account_id
, p_address_id => p_address_id
, p_planned_start_date => p_planned_start_date
, p_planned_end_date => p_planned_end_date
, p_scheduled_start_date => p_scheduled_start_date
, p_scheduled_end_date => p_scheduled_end_date
, p_actual_start_date => p_actual_start_date
, p_actual_end_date => p_actual_end_date
, p_timezone_id => p_timezone_id
, p_source_object_type_code => p_source_object_type_code
, p_source_object_id => p_source_object_id
, p_source_object_name => p_source_object_name
, p_duration => p_duration
, p_duration_uom => p_duration_uom
, p_planned_effort => p_planned_effort
, p_planned_effort_uom => p_planned_effort_uom
, p_actual_effort => p_actual_effort
, p_actual_effort_uom => p_actual_effort_uom
, p_percentage_complete => p_percentage_complete
, p_reason_code => p_reason_code
, p_private_flag => p_private_flag
, p_publish_flag => p_publish_flag
, p_restrict_closure_flag => p_restrict_closure_flag
, p_multi_booked_flag => p_multi_booked_flag
, p_milestone_flag => p_milestone_flag
, p_holiday_flag => p_holiday_flag
, p_billable_flag => p_billable_flag
, p_bound_mode_code => p_bound_mode_code
, p_soft_bound_flag => p_soft_bound_flag
, p_workflow_process_id => p_workflow_process_id
, p_notification_flag => p_notification_flag
, p_notification_period => p_notification_period
, p_notification_period_uom => p_notification_period_uom
, p_parent_task_id => p_parent_task_id
, p_alarm_start => p_alarm_start
, p_alarm_start_uom => p_alarm_start_uom
, p_alarm_on => p_alarm_on
, p_alarm_count => p_alarm_count
, p_alarm_fired_count => p_alarm_fired_count
, p_alarm_interval => p_alarm_interval
, p_alarm_interval_uom => p_alarm_interval_uom
, p_palm_flag => p_palm_flag
, p_wince_flag => p_wince_flag
, p_laptop_flag => p_laptop_flag
, p_device1_flag => p_device1_flag
, p_device2_flag => p_device2_flag
, p_device3_flag => p_device3_flag
, p_costs => p_costs
, p_currency_code => p_currency_code
, p_escalation_level => p_escalation_level
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_attribute1 => p_attribute1
, p_attribute2 => p_attribute2
, p_attribute3 => p_attribute3
, p_attribute4 => p_attribute4
, p_attribute5 => p_attribute5
, p_attribute6 => p_attribute6
, p_attribute7 => p_attribute7
, p_attribute8 => p_attribute8
, p_attribute9 => p_attribute9
, p_attribute10 => p_attribute10
, p_attribute11 => p_attribute11
, p_attribute12 => p_attribute12
, p_attribute13 => p_attribute13
, p_attribute14 => p_attribute14
, p_attribute15 => p_attribute15
, p_attribute_category => p_attribute_category
, p_date_selected => p_date_selected
, p_category_id => p_category_id
, p_show_on_calendar => p_show_on_calendar
, p_owner_status_id => p_owner_status_id
, p_enable_workflow => p_enable_workflow
, p_abort_workflow => p_abort_workflow
, p_change_mode => p_change_mode
, p_free_busy_type => jtf_task_utl.g_miss_char
);
ROLLBACK TO update_task_pvt3;
ROLLBACK TO update_task_pvt3;
PROCEDURE update_task(
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_object_version_number IN OUT NOCOPY NUMBER
, p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
, ---- hz_party_sites
p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
, p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
, p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
, p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
, p_change_mode IN VARCHAR2
, p_free_busy_type IN VARCHAR2
) IS
BEGIN
SAVEPOINT update_task_pvt4;
update_task(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => fnd_api.g_false
, -- FALSE
p_object_version_number => p_object_version_number
, p_task_id => p_task_id
, p_task_name => p_task_name
, p_task_type_id => p_task_type_id
, p_description => p_description
, p_task_status_id => p_task_status_id
, p_task_priority_id => p_task_priority_id
, p_owner_type_code => p_owner_type_code
, p_owner_id => p_owner_id
, p_owner_territory_id => p_owner_territory_id
, p_assigned_by_id => p_assigned_by_id
, p_customer_id => p_customer_id
, p_cust_account_id => p_cust_account_id
, p_address_id => p_address_id
, p_planned_start_date => p_planned_start_date
, p_planned_end_date => p_planned_end_date
, p_scheduled_start_date => p_scheduled_start_date
, p_scheduled_end_date => p_scheduled_end_date
, p_actual_start_date => p_actual_start_date
, p_actual_end_date => p_actual_end_date
, p_timezone_id => p_timezone_id
, p_source_object_type_code => p_source_object_type_code
, p_source_object_id => p_source_object_id
, p_source_object_name => p_source_object_name
, p_duration => p_duration
, p_duration_uom => p_duration_uom
, p_planned_effort => p_planned_effort
, p_planned_effort_uom => p_planned_effort_uom
, p_actual_effort => p_actual_effort
, p_actual_effort_uom => p_actual_effort_uom
, p_percentage_complete => p_percentage_complete
, p_reason_code => p_reason_code
, p_private_flag => p_private_flag
, p_publish_flag => p_publish_flag
, p_restrict_closure_flag => p_restrict_closure_flag
, p_multi_booked_flag => p_multi_booked_flag
, p_milestone_flag => p_milestone_flag
, p_holiday_flag => p_holiday_flag
, p_billable_flag => p_billable_flag
, p_bound_mode_code => p_bound_mode_code
, p_soft_bound_flag => p_soft_bound_flag
, p_workflow_process_id => p_workflow_process_id
, p_notification_flag => p_notification_flag
, p_notification_period => p_notification_period
, p_notification_period_uom => p_notification_period_uom
, p_parent_task_id => p_parent_task_id
, p_alarm_start => p_alarm_start
, p_alarm_start_uom => p_alarm_start_uom
, p_alarm_on => p_alarm_on
, p_alarm_count => p_alarm_count
, p_alarm_fired_count => p_alarm_fired_count
, p_alarm_interval => p_alarm_interval
, p_alarm_interval_uom => p_alarm_interval_uom
, p_palm_flag => p_palm_flag
, p_wince_flag => p_wince_flag
, p_laptop_flag => p_laptop_flag
, p_device1_flag => p_device1_flag
, p_device2_flag => p_device2_flag
, p_device3_flag => p_device3_flag
, p_costs => p_costs
, p_currency_code => p_currency_code
, p_escalation_level => p_escalation_level
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_attribute1 => p_attribute1
, p_attribute2 => p_attribute2
, p_attribute3 => p_attribute3
, p_attribute4 => p_attribute4
, p_attribute5 => p_attribute5
, p_attribute6 => p_attribute6
, p_attribute7 => p_attribute7
, p_attribute8 => p_attribute8
, p_attribute9 => p_attribute9
, p_attribute10 => p_attribute10
, p_attribute11 => p_attribute11
, p_attribute12 => p_attribute12
, p_attribute13 => p_attribute13
, p_attribute14 => p_attribute14
, p_attribute15 => p_attribute15
, p_attribute_category => p_attribute_category
, p_date_selected => p_date_selected
, p_category_id => p_category_id
, p_show_on_calendar => p_show_on_calendar
, p_owner_status_id => p_owner_status_id
, p_enable_workflow => p_enable_workflow
, p_abort_workflow => p_abort_workflow
, p_change_mode => p_change_mode
, p_free_busy_type => p_free_busy_type
, --Bug# 3606783.
p_task_confirmation_status => jtf_task_utl.g_miss_char
, p_task_confirmation_counter => jtf_task_utl.g_miss_number
, p_task_split_flag => jtf_task_utl.g_miss_char
, p_child_position => jtf_task_utl.g_miss_char
, p_child_sequence_num => jtf_task_utl.g_miss_number
);
ROLLBACK TO update_task_pvt4;
ROLLBACK TO update_task_pvt4;
PROCEDURE update_task(
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_object_version_number IN OUT NOCOPY NUMBER
, p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
, ---- hz_party_sites
p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
, p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
, p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
, p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
, p_change_mode IN VARCHAR2
, p_free_busy_type IN VARCHAR2
, p_task_confirmation_status IN VARCHAR2
, p_task_confirmation_counter IN NUMBER
, p_task_split_flag IN VARCHAR2
, p_child_position IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_child_sequence_num IN NUMBER DEFAULT jtf_task_utl.g_miss_number
) IS
BEGIN
SAVEPOINT update_task_pvt5;
update_task(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => fnd_api.g_false
, p_object_version_number => p_object_version_number
, p_task_id => p_task_id
, p_task_name => p_task_name
, p_task_type_id => p_task_type_id
, p_description => p_description
, p_task_status_id => p_task_status_id
, p_task_priority_id => p_task_priority_id
, p_owner_type_code => p_owner_type_code
, p_owner_id => p_owner_id
, p_owner_territory_id => p_owner_territory_id
, p_assigned_by_id => p_assigned_by_id
, p_customer_id => p_customer_id
, p_cust_account_id => p_cust_account_id
, p_address_id => p_address_id
, ---- hz_party_sites
p_planned_start_date => p_planned_start_date
, p_planned_end_date => p_planned_end_date
, p_scheduled_start_date => p_scheduled_start_date
, p_scheduled_end_date => p_scheduled_end_date
, p_actual_start_date => p_actual_start_date
, p_actual_end_date => p_actual_end_date
, p_timezone_id => p_timezone_id
, p_source_object_type_code => p_source_object_type_code
, p_source_object_id => p_source_object_id
, p_source_object_name => p_source_object_name
, p_duration => p_duration
, p_duration_uom => p_duration_uom
, p_planned_effort => p_planned_effort
, p_planned_effort_uom => p_planned_effort_uom
, p_actual_effort => p_actual_effort
, p_actual_effort_uom => p_actual_effort_uom
, p_percentage_complete => p_percentage_complete
, p_reason_code => p_reason_code
, p_private_flag => p_private_flag
, p_publish_flag => p_publish_flag
, p_restrict_closure_flag => p_restrict_closure_flag
, p_multi_booked_flag => p_multi_booked_flag
, p_milestone_flag => p_milestone_flag
, p_holiday_flag => p_holiday_flag
, p_billable_flag => p_billable_flag
, p_bound_mode_code => p_bound_mode_code
, p_soft_bound_flag => p_soft_bound_flag
, p_workflow_process_id => p_workflow_process_id
, p_notification_flag => p_notification_flag
, p_notification_period => p_notification_period
, p_notification_period_uom => p_notification_period_uom
, p_parent_task_id => p_parent_task_id
, p_alarm_start => p_alarm_start
, p_alarm_start_uom => p_alarm_start_uom
, p_alarm_on => p_alarm_on
, p_alarm_count => p_alarm_count
, p_alarm_fired_count => p_alarm_fired_count
, p_alarm_interval => p_alarm_interval
, p_alarm_interval_uom => p_alarm_interval_uom
, p_palm_flag => p_palm_flag
, p_wince_flag => p_wince_flag
, p_laptop_flag => p_laptop_flag
, p_device1_flag => p_device1_flag
, p_device2_flag => p_device2_flag
, p_device3_flag => p_device3_flag
, p_costs => p_costs
, p_currency_code => p_currency_code
, p_escalation_level => p_escalation_level
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_attribute1 => p_attribute1
, p_attribute2 => p_attribute2
, p_attribute3 => p_attribute3
, p_attribute4 => p_attribute4
, p_attribute5 => p_attribute5
, p_attribute6 => p_attribute6
, p_attribute7 => p_attribute7
, p_attribute8 => p_attribute8
, p_attribute9 => p_attribute9
, p_attribute10 => p_attribute10
, p_attribute11 => p_attribute11
, p_attribute12 => p_attribute12
, p_attribute13 => p_attribute13
, p_attribute14 => p_attribute14
, p_attribute15 => p_attribute15
, p_attribute_category => p_attribute_category
, p_date_selected => p_date_selected
, p_category_id => p_category_id
, p_show_on_calendar => p_show_on_calendar
, p_owner_status_id => p_owner_status_id
, p_enable_workflow => p_enable_workflow
, p_abort_workflow => p_abort_workflow
, p_change_mode => p_change_mode
, p_free_busy_type => p_free_busy_type
, p_task_confirmation_status => p_task_confirmation_status
, p_task_confirmation_counter => p_task_confirmation_counter
, p_task_split_flag => p_task_split_flag
, p_child_position => p_child_position
, p_child_sequence_num => p_child_sequence_num
, p_location_id => NULL
);
ROLLBACK TO update_task_pvt5;
ROLLBACK TO update_task_pvt5;
PROCEDURE update_task(
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_object_version_number IN OUT NOCOPY NUMBER
, p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
, p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
, p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
, p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
, p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
, p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
, p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
, p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
, p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
, p_change_mode IN VARCHAR2
, p_free_busy_type IN VARCHAR2
, p_task_confirmation_status IN VARCHAR2
, p_task_confirmation_counter IN NUMBER
, p_task_split_flag IN VARCHAR2
, p_child_position IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_child_sequence_num IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_location_id IN NUMBER
) IS
l_task_id jtf_tasks_b.task_id%TYPE;
l_date_selected jtf_tasks_b.date_selected%TYPE;
SELECT task_number
, recurrence_rule_id
, DECODE(p_task_name, fnd_api.g_miss_char, task_name, p_task_name) task_name
, DECODE(p_task_type_id, fnd_api.g_miss_num, task_type_id, p_task_type_id) task_type_id
, DECODE(p_description, fnd_api.g_miss_char, description, p_description) description
, DECODE(p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id)
task_status_id
, DECODE(p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id)
task_priority_id
, DECODE(p_owner_type_code, fnd_api.g_miss_char, owner_type_code, p_owner_type_code)
owner_type_code
, DECODE(p_owner_id, fnd_api.g_miss_num, owner_id, p_owner_id) owner_id
, DECODE(
p_owner_territory_id
, fnd_api.g_miss_num, owner_territory_id
, p_owner_territory_id
) owner_territory_id
, DECODE(p_assigned_by_id, fnd_api.g_miss_num, assigned_by_id, p_assigned_by_id)
assigned_by_id
, DECODE(p_customer_id, fnd_api.g_miss_num, customer_id, p_customer_id) customer_id
, DECODE(p_cust_account_id, fnd_api.g_miss_num, cust_account_id, p_cust_account_id)
cust_account_id
, DECODE(p_address_id, fnd_api.g_miss_num, address_id, p_address_id) address_id
, DECODE(
p_planned_start_date
, fnd_api.g_miss_date, planned_start_date
, p_planned_start_date
) planned_start_date
, DECODE(p_planned_end_date, fnd_api.g_miss_date, planned_end_date, p_planned_end_date)
planned_end_date
, DECODE(
p_scheduled_start_date
, fnd_api.g_miss_date, scheduled_start_date
, p_scheduled_start_date
) scheduled_start_date
, DECODE(
p_scheduled_end_date
, fnd_api.g_miss_date, scheduled_end_date
, p_scheduled_end_date
) scheduled_end_date
, DECODE(
p_actual_start_date
, fnd_api.g_miss_date, actual_start_date
, p_actual_start_date
) actual_start_date
, DECODE(p_actual_end_date, fnd_api.g_miss_date, actual_end_date, p_actual_end_date)
actual_end_date
, DECODE(p_timezone_id, fnd_api.g_miss_num, timezone_id, p_timezone_id) timezone_id
, DECODE(
p_workflow_process_id
, fnd_api.g_miss_num, workflow_process_id
, p_workflow_process_id
) workflow_process_id
,
---
--- handle NULL like g_miss_value for these three parameters, to fix bug #2002639
---
DECODE(
p_source_object_type_code
, fnd_api.g_miss_char, source_object_type_code
, NULL, source_object_type_code
, p_source_object_type_code
) source_object_type_code
, DECODE(
p_source_object_id
, fnd_api.g_miss_num, source_object_id
, NULL, source_object_id
, p_source_object_id
) source_object_id
,
---
--- to fix bug #2224949
---
DECODE(
p_source_object_name
, fnd_api.g_miss_char, source_object_name
, NULL, source_object_name
, jtf_task_utl.check_truncation(p_source_object_name)
) source_object_name
, DECODE(p_duration, fnd_api.g_miss_num, DURATION, p_duration) DURATION
, DECODE(p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom
, DECODE(p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort)
planned_effort
, DECODE(
p_planned_effort_uom
, fnd_api.g_miss_char, planned_effort_uom
, p_planned_effort_uom
) planned_effort_uom
, DECODE(p_actual_effort, fnd_api.g_miss_num, actual_effort, p_actual_effort)
actual_effort
, DECODE(
p_actual_effort_uom
, fnd_api.g_miss_char, actual_effort_uom
, p_actual_effort_uom
) actual_effort_uom
, DECODE(
p_percentage_complete
, fnd_api.g_miss_num, percentage_complete
, p_percentage_complete
) percentage_complete
, DECODE(p_reason_code, fnd_api.g_miss_char, reason_code, p_reason_code) reason_code
, DECODE(p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag
, DECODE(p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag
, DECODE(
p_restrict_closure_flag
, fnd_api.g_miss_char, restrict_closure_flag
, p_restrict_closure_flag
) restrict_closure_flag
, DECODE(
p_multi_booked_flag
, fnd_api.g_miss_char, multi_booked_flag
, p_multi_booked_flag
) multi_booked_flag
, DECODE(p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag)
milestone_flag
, DECODE(p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag
, DECODE(p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag)
billable_flag
, DECODE(p_bound_mode_code, fnd_api.g_miss_char, bound_mode_code, p_bound_mode_code)
bound_mode_code
, DECODE(p_soft_bound_flag, fnd_api.g_miss_char, soft_bound_flag, p_soft_bound_flag)
soft_bound_flag
, DECODE(
p_notification_flag
, fnd_api.g_miss_char, notification_flag
, p_notification_flag
) notification_flag
, DECODE(
p_notification_period
, fnd_api.g_miss_num, notification_period
, p_notification_period
) notification_period
, DECODE(
p_notification_period_uom
, fnd_api.g_miss_char, notification_period_uom
, p_notification_period_uom
) notification_period_uom
, DECODE(p_parent_task_id, fnd_api.g_miss_num, parent_task_id, p_parent_task_id)
parent_task_id
, DECODE(p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start
, DECODE(p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom)
alarm_start_uom
, DECODE(p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on
, DECODE(p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count
, DECODE(
p_alarm_fired_count
, fnd_api.g_miss_num, alarm_fired_count
, p_alarm_fired_count
) alarm_fired_count
, DECODE(p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval)
alarm_interval
, DECODE(
p_alarm_interval_uom
, fnd_api.g_miss_char, alarm_interval_uom
, p_alarm_interval_uom
) alarm_interval_uom
, DECODE(p_palm_flag, fnd_api.g_miss_char, palm_flag, p_palm_flag) palm_flag
, DECODE(p_wince_flag, fnd_api.g_miss_char, wince_flag, p_wince_flag) wince_flag
, DECODE(p_laptop_flag, fnd_api.g_miss_char, laptop_flag, p_laptop_flag) laptop_flag
, DECODE(p_device1_flag, fnd_api.g_miss_char, device1_flag, p_device1_flag) device1_flag
, DECODE(p_device2_flag, fnd_api.g_miss_char, device2_flag, p_device2_flag) device2_flag
, DECODE(p_device3_flag, fnd_api.g_miss_char, device3_flag, p_device3_flag) device3_flag
, DECODE(p_costs, fnd_api.g_miss_num, costs, p_costs) costs
, DECODE(p_currency_code, fnd_api.g_miss_char, currency_code, p_currency_code)
currency_code
, DECODE(p_escalation_level, fnd_api.g_miss_char, escalation_level, p_escalation_level)
escalation_level
, DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1
, DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2
, DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3
, DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4
, DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5
, DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6
, DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7
, DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8
, DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9
, DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10
, DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11
, DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12
, DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13
, DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14
, DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15
, DECODE(
p_attribute_category
, fnd_api.g_miss_char, attribute_category
, p_attribute_category
) attribute_category
, calendar_start_date
, calendar_end_date
, DURATION duration_orig
, -- XY Story #140
DECODE(p_date_selected, fnd_api.g_miss_char, date_selected, p_date_selected)
date_selected
, creation_date
, DECODE(
p_task_confirmation_status
, jtf_task_utl.g_miss_char, task_confirmation_status
, p_task_confirmation_status
) task_confirmation_status
, DECODE(
p_task_confirmation_counter
, jtf_task_utl.g_miss_number, task_confirmation_counter
, p_task_confirmation_counter
) task_confirmation_counter
, DECODE(
p_task_split_flag
, jtf_task_utl.g_miss_char, task_split_flag
, p_task_split_flag
) task_split_flag
, DECODE(p_child_position, jtf_task_utl.g_miss_char, child_position, p_child_position)
child_position
, DECODE(
p_child_sequence_num
, jtf_task_utl.g_miss_number, child_sequence_num
, p_child_sequence_num
) child_sequence_num
, DECODE(p_location_id, fnd_api.g_miss_num, location_id, p_location_id) location_id
FROM jtf_tasks_vl
WHERE task_id = p_task_id;
SELECT task_id
, task_assignment_id
, object_version_number
, DECODE(p_owner_id, fnd_api.g_miss_num, resource_id, p_owner_id) resource_id
, DECODE(p_owner_type_code, fnd_api.g_miss_char, resource_type_code, p_owner_type_code) resource_type_code
, DECODE(
p_owner_territory_id
, fnd_api.g_miss_num, resource_territory_id
, p_owner_territory_id
) resource_territory_id
, DECODE(l_owner_status_id, fnd_api.g_miss_num, assignment_status_id, l_owner_status_id) assignment_status_id
, DECODE(l_show_on_calendar, fnd_api.g_miss_char, show_on_calendar, l_show_on_calendar) show_on_calendar
, DECODE(p_category_id, jtf_task_utl.g_miss_number, category_id, p_category_id) category_id
, DECODE(p_free_busy_type, jtf_task_utl.g_miss_char, free_busy_type, p_free_busy_type) free_busy_type
FROM jtf_task_all_assignments
WHERE assignee_role = 'OWNER' AND task_id = b_task_id;
SELECT task_id
, assignment_status_id
, show_on_calendar
, category_id
, resource_id
, free_busy_type
, booking_start_date
, booking_end_date
, task_assignment_id
, object_version_number
, actual_start_date
, actual_end_date
, actual_effort
, actual_effort_uom
, actual_travel_duration
, actual_travel_duration_uom
, assignee_role
FROM jtf_task_all_assignments
WHERE task_id = b_task_id
ORDER BY assignee_role DESC;
SELECT customer_id
FROM jtf_tasks_b
WHERE task_id = b_task_id;
SELECT source_object_id
, source_object_type_code
, entity
, open_flag
FROM jtf_tasks_b
WHERE task_id = b_task_id;
SELECT task_reference_id
, object_version_number
FROM jtf_task_references_b
WHERE task_id = b_task_id AND object_id = b_source_id;
SELECT task_contact_id
, contact_id
, object_version_number
FROM jtf_task_contacts
WHERE task_id = c_task_id;
l_updated_field_rec jtf_task_repeat_appt_pvt.updated_field_rec;
SAVEPOINT update_task_pvt;
, p_session => 'UPDATE'
, x_return_status => x_return_status
);
l_date_selected := tasks.date_selected;
, p_date_selected => tasks.date_selected
, p_planned_start_date => tasks.planned_start_date
, p_planned_end_date => tasks.planned_end_date
, p_scheduled_start_date => tasks.scheduled_start_date
, p_scheduled_end_date => tasks.scheduled_end_date
, p_actual_start_date => tasks.actual_start_date
, p_actual_end_date => tasks.actual_end_date
, x_show_on_calendar => l_show_on_calendar
, x_date_selected => l_date_selected
, x_calendar_start_date => l_calendar_start_date
, x_calendar_end_date => l_calendar_end_date
, x_return_status => x_return_status
, p_task_status_id => l_task_status_id
, p_creation_date => tasks.creation_date
);
l_updated_field_rec.task_id := p_task_id;
l_updated_field_rec.task_name := p_task_name;
l_updated_field_rec.task_type_id := p_task_type_id;
l_updated_field_rec.description := p_description;
l_updated_field_rec.task_status_id := p_task_status_id;
l_updated_field_rec.task_priority_id := p_task_priority_id;
l_updated_field_rec.owner_type_code := p_owner_type_code;
l_updated_field_rec.owner_id := p_owner_id;
l_updated_field_rec.owner_territory_id := p_owner_territory_id;
l_updated_field_rec.assigned_by_id := p_assigned_by_id;
l_updated_field_rec.customer_id := p_customer_id;
l_updated_field_rec.cust_account_id := p_cust_account_id;
l_updated_field_rec.address_id := p_address_id;
l_updated_field_rec.planned_start_date := p_planned_start_date;
l_updated_field_rec.planned_end_date := p_planned_end_date;
l_updated_field_rec.scheduled_start_date := p_scheduled_start_date;
l_updated_field_rec.scheduled_end_date := p_scheduled_end_date;
l_updated_field_rec.actual_start_date := p_actual_start_date;
l_updated_field_rec.actual_end_date := p_actual_end_date;
l_updated_field_rec.timezone_id := p_timezone_id;
l_updated_field_rec.source_object_type_code := p_source_object_type_code;
l_updated_field_rec.source_object_id := p_source_object_id;
l_updated_field_rec.source_object_name := p_source_object_name;
l_updated_field_rec.DURATION := p_duration;
l_updated_field_rec.duration_uom := p_duration_uom;
l_updated_field_rec.planned_effort := p_planned_effort;
l_updated_field_rec.planned_effort_uom := p_planned_effort_uom;
l_updated_field_rec.actual_effort := p_actual_effort;
l_updated_field_rec.actual_effort_uom := p_actual_effort_uom;
l_updated_field_rec.percentage_complete := p_percentage_complete;
l_updated_field_rec.reason_code := p_reason_code;
l_updated_field_rec.private_flag := p_private_flag;
l_updated_field_rec.publish_flag := p_publish_flag;
l_updated_field_rec.restrict_closure_flag := p_restrict_closure_flag;
l_updated_field_rec.multi_booked_flag := p_multi_booked_flag;
l_updated_field_rec.milestone_flag := p_milestone_flag;
l_updated_field_rec.holiday_flag := p_holiday_flag;
l_updated_field_rec.billable_flag := p_billable_flag;
l_updated_field_rec.bound_mode_code := p_bound_mode_code;
l_updated_field_rec.soft_bound_flag := p_soft_bound_flag;
l_updated_field_rec.workflow_process_id := p_workflow_process_id;
l_updated_field_rec.notification_flag := p_notification_flag;
l_updated_field_rec.notification_period := p_notification_period;
l_updated_field_rec.notification_period_uom := p_notification_period_uom;
l_updated_field_rec.parent_task_id := p_parent_task_id;
l_updated_field_rec.alarm_start := p_alarm_start;
l_updated_field_rec.alarm_start_uom := p_alarm_start_uom;
l_updated_field_rec.alarm_on := p_alarm_on;
l_updated_field_rec.alarm_count := p_alarm_count;
l_updated_field_rec.alarm_fired_count := p_alarm_fired_count;
l_updated_field_rec.alarm_interval := p_alarm_interval;
l_updated_field_rec.alarm_interval_uom := p_alarm_interval_uom;
l_updated_field_rec.palm_flag := p_palm_flag;
l_updated_field_rec.wince_flag := p_wince_flag;
l_updated_field_rec.laptop_flag := p_laptop_flag;
l_updated_field_rec.device1_flag := p_device1_flag;
l_updated_field_rec.device2_flag := p_device2_flag;
l_updated_field_rec.device3_flag := p_device3_flag;
l_updated_field_rec.costs := p_costs;
l_updated_field_rec.currency_code := p_currency_code;
l_updated_field_rec.escalation_level := p_escalation_level;
l_updated_field_rec.attribute1 := p_attribute1;
l_updated_field_rec.attribute2 := p_attribute2;
l_updated_field_rec.attribute3 := p_attribute3;
l_updated_field_rec.attribute4 := p_attribute4;
l_updated_field_rec.attribute5 := p_attribute5;
l_updated_field_rec.attribute6 := p_attribute6;
l_updated_field_rec.attribute7 := p_attribute7;
l_updated_field_rec.attribute8 := p_attribute8;
l_updated_field_rec.attribute9 := p_attribute9;
l_updated_field_rec.attribute10 := p_attribute10;
l_updated_field_rec.attribute11 := p_attribute11;
l_updated_field_rec.attribute12 := p_attribute12;
l_updated_field_rec.attribute13 := p_attribute13;
l_updated_field_rec.attribute14 := p_attribute14;
l_updated_field_rec.attribute15 := p_attribute15;
l_updated_field_rec.attribute_category := p_attribute_category;
l_updated_field_rec.date_selected := p_date_selected;
l_updated_field_rec.category_id := p_category_id;
l_updated_field_rec.show_on_calendar := p_show_on_calendar;
l_updated_field_rec.owner_status_id := p_owner_status_id;
l_updated_field_rec.enable_workflow := l_enable_workflow;
l_updated_field_rec.abort_workflow := l_abort_workflow;
l_updated_field_rec.change_mode := p_change_mode;
l_updated_field_rec.recurrence_rule_id := tasks.recurrence_rule_id;
l_updated_field_rec.old_calendar_start_date := tasks.calendar_start_date;
l_updated_field_rec.new_calendar_start_date := l_calendar_start_date;
l_updated_field_rec.new_calendar_end_date := l_calendar_end_date;
l_updated_field_rec.free_busy_type := l_free_busy_type; -- Bug No 4269468
l_updated_field_rec.location_id := p_location_id;
jtf_task_repeat_appt_pvt.update_repeat_appointment
(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => p_object_version_number
, p_updated_field_rec => l_updated_field_rec
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
IF tasks.date_selected IS NULL OR tasks.date_selected = fnd_api.g_miss_char THEN
IF l_date_selected = 'P' THEN
l_planned_start_date := l_calendar_start_date;
ELSIF l_date_selected = 'S' THEN
l_scheduled_start_date := l_calendar_start_date;
ELSIF l_date_selected = 'A' THEN
l_actual_start_date := l_calendar_start_date;
jtf_tasks_pub.p_task_user_hooks.date_selected := l_date_selected;
jtf_tasks_iuhk.update_task_pre(x_return_status);
x_task_upd_rec.deleted_flag := 'N';
x_task_upd_rec.last_update_date := SYSDATE;
x_task_upd_rec.last_updated_by := jtf_task_utl.updated_by;
x_task_upd_rec.last_update_login := jtf_task_utl.login_id;
x_task_upd_rec.date_selected := l_date_selected;
jtf_tasks_pkg.update_row(p_task_upd_rec => x_task_upd_rec, p_task_audit_id => x_task_audit_id);
jtf_task_assignments_pvt.update_task_assignment(
p_api_version => p_api_version
, p_object_version_number => task_ass_rec.object_version_number
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_task_assignment_id => task_ass_rec.task_assignment_id
, p_actual_start_date => l_actual_start_date
, p_actual_end_date => l_actual_end_date
, p_palm_flag => l_palm_flag
, p_wince_flag => l_wince_flag
, p_laptop_flag => l_laptop_flag
, p_device1_flag => l_device1_flag
, p_device2_flag => l_device2_flag
, p_device3_flag => l_device3_flag
, p_resource_id => task_ass_rec.resource_id
, p_actual_effort => l_actual_effort
, p_actual_effort_uom => l_actual_effort_uom
, p_resource_type_code => task_ass_rec.resource_type_code
, p_resource_territory_id => task_ass_rec.resource_territory_id
, p_assignment_status_id => task_ass_rec.assignment_status_id
, x_msg_data => x_msg_data
, x_msg_count => x_msg_count
, x_return_status => x_return_status
, p_assignee_role => 'OWNER'
, p_show_on_calendar => task_ass_rec.show_on_calendar
, p_category_id => task_ass_rec.category_id
, p_enable_workflow => l_enable_workflow
, p_abort_workflow => l_abort_workflow
, p_free_busy_type => task_ass_rec.free_busy_type
);
jtf_task_utl.update_task_category(
p_api_version => p_api_version,
p_object_version_number => l_assignee_rec.object_version_number,
p_task_assignment_id => l_assignee_rec.task_assignment_id,
p_category_id => p_category_id,
x_msg_data => x_msg_data,
x_msg_count => x_msg_count,
x_return_status => x_return_status);
UPDATE jtf_task_all_assignments
SET booking_start_date = l_booking_start_date
, booking_end_date = l_booking_end_date
WHERE task_assignment_id = task_ass_orig_rec.task_assignment_id;
jtf_task_utl_ext.update_object_code(
p_task_id => l_task_id
, p_old_object_code => l_orig_source_object_type_code
, p_new_object_code => tasks.source_object_type_code
, p_old_object_id => l_orig_source_id
, p_new_object_id => l_source_object_id
, p_new_object_name => l_source_object_name
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
jtf_task_contacts_pub.delete_task_contacts
(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => c.object_version_number
, p_task_contact_id => c.task_contact_id
, x_return_status => x_return_status
, x_msg_data => x_msg_data
, x_msg_count => x_msg_count
, p_delete_cascade => jtf_task_utl.g_yes_char
);
jtf_task_utl.delete_party_reference(
p_reference_from => 'TASK'
, p_task_id => l_task_id
, p_party_id => l_orig_cust_id
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, x_return_status => x_return_status
);
jtf_tasks_iuhk.update_task_post(x_return_status);
jtf_task_wf_events_pvt.publish_update_task(
p_task_rec_old => l_task_rec_type_old
, p_task_rec_new => l_task_rec_type_new
, x_return_status => x_event_return_status
);
ROLLBACK TO update_task_pvt;
ROLLBACK TO update_task_pvt;
END; ---- End of private Update Task
PROCEDURE delete_task(
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_object_version_number IN NUMBER
, p_task_id IN NUMBER
, p_delete_future_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT delete_task_pvt2;
delete_task(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_object_version_number => p_object_version_number
, p_task_id => p_task_id
, p_delete_future_recurrences => p_delete_future_recurrences
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
, p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
);
ROLLBACK TO delete_task_pvt2;
ROLLBACK TO delete_task_pvt2;
PROCEDURE delete_task(
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_object_version_number IN NUMBER
, p_task_id IN NUMBER
, p_delete_future_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
) IS
l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
l_date_selected jtf_task_recur_rules.date_selected%TYPE;
SELECT recurrence_rule_id
, planned_start_date
, scheduled_start_date
, actual_start_date
FROM jtf_tasks_b
WHERE task_id = b_task_id;
SELECT date_selected
FROM jtf_task_recur_rules
WHERE recurrence_rule_id = b_rule_id;
CURSOR c_delete_task(b_date_selected jtf_task_recur_rules.date_selected%TYPE) IS
SELECT task_id
, object_version_number
, source_object_type_code
, -- Added for XP Sync Story #58
calendar_start_date -- Added for XP Sync Story #58
FROM jtf_tasks_b
WHERE task_id = p_task_id
UNION ALL
SELECT task_id
, object_version_number
, source_object_type_code
, -- Added for XP Sync Story #58
calendar_start_date -- Added for XP Sync Story #58
FROM jtf_tasks_b
WHERE recurrence_rule_id = l_recur_rule
AND (
(
p_delete_future_recurrences = fnd_api.g_true
AND (
---------------------------
---- 'P' use planned date
---- null (existing data)
---- also use planned date
---------------------------
(NVL(b_date_selected, 'P') = 'P' AND planned_start_date >= l_planned_date)
OR
---------------------------
---- 'S' use scheduled date
---------------------------
(b_date_selected = 'S' AND scheduled_start_date >= l_scheduled_date)
OR
---------------------------
---- 'A' use actual date
---------------------------
(b_date_selected = 'A' AND actual_start_date >= l_actual_date)
)
)
OR p_delete_future_recurrences = 'A'
)
AND NVL(deleted_flag, 'N') = 'N'
AND task_id <> p_task_id;
SELECT dependency_id
, object_version_number
FROM jtf_task_depends
WHERE task_id = l_task_id OR dependent_on_task_id = l_task_id;
SELECT task_reference_id
, object_version_number
FROM jtf_task_references_vl
WHERE task_id = l_task_id;
SELECT task_date_id
, object_version_number
FROM jtf_task_dates
WHERE task_id = l_task_id;
SELECT resource_req_id
, object_version_number
FROM jtf_task_rsc_reqs
WHERE task_id = l_task_id;
SELECT task_assignment_id
, object_version_number
FROM jtf_task_all_assignments
WHERE task_id = l_task_id;
SELECT task_contact_id
, object_version_number
FROM jtf_task_contacts
WHERE task_id = l_task_id;
SELECT a.object_version_number
, a.task_phone_id
FROM jtf_task_phones a, jtf_tasks_b c
WHERE a.owner_table_name = 'JTF_TASKS_B'
AND a.task_contact_id = c.task_id
AND c.task_id = l_task_id;
SELECT source_object_id
, source_object_type_code
, entity
FROM jtf_tasks_b
WHERE task_id = b_task_id;
CURSOR c_parent_child(b_date_selected jtf_task_recur_rules.date_selected%TYPE) IS
SELECT count(*) FROM
(SELECT task_number
from jtf_tasks_b
where parent_task_id = p_task_id
AND NVL(deleted_flag, 'N') = 'N'
UNION ALL
SELECT task_number
FROM jtf_tasks_b
WHERE recurrence_rule_id = l_recur_rule
AND (
(
p_delete_future_recurrences = fnd_api.g_true
AND (
---------------------------
---- 'P' use planned date
---- null (existing data)
---- also use planned date
---------------------------
(NVL(b_date_selected, 'P') = 'P' AND planned_start_date >= l_planned_date)
OR
---------------------------
---- 'S' use scheduled date
---------------------------
(b_date_selected = 'S' AND scheduled_start_date >= l_scheduled_date)
OR
---------------------------
---- 'A' use actual date
---------------------------
(b_date_selected = 'A' AND actual_start_date >= l_actual_date)
)
)
OR p_delete_future_recurrences = 'A'
)
AND NVL(deleted_flag, 'N') = 'N'
AND task_id <> p_task_id
AND exists ( select *
from jtf_tasks_b
where parent_task_id = task_id ) );
SAVEPOINT delete_task_pvt;
jtf_task_utl.check_security_privilege(p_task_id => p_task_id, p_session => 'DELETE'
, x_return_status => x_return_status);
p_event => 'DELETE_TASK',
p_task_id => l_task_id,
p_abort_workflow => p_abort_workflow,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
INTO l_date_selected;
OPEN c_parent_child(l_date_selected);
jtf_tasks_iuhk.delete_task_pre(x_return_status);
FOR i IN c_delete_task(l_date_selected) LOOP
l_task_id := i.task_id;
jtf_task_dependency_pub.delete_task_dependency
(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => a.object_version_number
, p_dependency_id => a.dependency_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
jtf_task_references_pvt.delete_references
(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => b.object_version_number
, p_task_reference_id => b.task_reference_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_from_task_api => 'Y'
);
jtf_task_dates_pub.delete_task_dates(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => c.object_version_number
, p_task_date_id => c.task_date_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
jtf_task_resources_pub.delete_task_rsrc_req
(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => c.object_version_number
, p_resource_req_id => c.resource_req_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
(NVL(p_delete_future_recurrences, fnd_api.g_false) <> 'A')
AND (l_recur_rule IS NOT NULL)
AND (l_source_object_type_code IN('APPOINTMENT', 'EXTERNAL APPOINTMENT'))
) THEN
SELECT jta_task_exclusions_s.NEXTVAL
INTO l_task_exclusion_id
FROM DUAL;
jta_task_exclusions_pkg.insert_row(
p_task_exclusion_id => l_task_exclusion_id
, p_task_id => l_task_id
, p_recurrence_rule_id => l_recur_rule
, p_exclusion_date => l_calendar_start_date
);
jta_sync_task_utl.update_mapping(p_task_id => p_task_id);
jtf_task_assignments_pvt.delete_task_assignment
(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => c.object_version_number
, p_task_assignment_id => c.task_assignment_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
, p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
, p_delete_option => jtf_task_repeat_appt_pvt.g_skip
);
UPDATE jtf_tasks_b
SET deleted_flag = 'Y'
, last_update_date = SYSDATE
, last_updated_by = fnd_global.user_id
, object_changed_date = SYSDATE
WHERE task_id = l_task_id;
jtf_task_wf_events_pvt.publish_delete_task(p_task_rec => l_task_rec_type
, x_return_status => x_event_return_status);
jtf_task_contacts_pub.delete_task_contacts
(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => cc.object_version_number
, p_task_contact_id => cc.task_contact_id
, x_return_status => x_return_status
, x_msg_data => x_msg_data
, x_msg_count => x_msg_count
, p_delete_cascade => jtf_task_utl.g_yes_char
);
END LOOP; -- End of delete contacts
jtf_task_phones_pub.delete_task_phones
(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => cp.object_version_number
, p_task_phone_id => cp.task_phone_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
END LOOP; -- End of delete contact points
jtf_tasks_iuhk.delete_task_post(x_return_status);
ROLLBACK TO delete_task_pvt;
ROLLBACK TO delete_task_pvt;
v_select :=
'select '
|| 'task_id,'
|| 'task_number,'
|| 'task_name,'
|| 'description,'
|| 'task_type_id,'
|| 'task_type,'
|| 'task_status_id,'
|| 'task_status,'
|| 'task_priority_id,'
|| 'task_priority,'
|| 'owner_type_code,'
|| 'owner_id,'
|| 'assigned_by_id,'
|| 'assigned_by_name,'
|| 'customer_id,'
|| 'customer_name,'
|| 'customer_number,'
|| 'address_id,'
|| 'planned_start_date,'
|| 'planned_end_date,'
|| 'scheduled_start_date,'
|| 'scheduled_end_date,'
|| 'actual_start_date,'
|| 'actual_end_date,'
|| 'source_object_type_code,'
|| 'source_object_id,'
|| 'source_object_name,'
|| 'duration,'
|| 'duration_uom,'
|| 'planned_effort,'
|| 'planned_effort_uom,'
|| 'actual_effort,'
|| 'actual_effort_uom,'
|| 'percentage_complete,'
|| 'reason_code,'
|| 'private_flag,'
|| 'publish_flag,'
|| 'multi_booked_flag,'
|| 'milestone_flag,'
|| 'holiday_flag,'
|| 'workflow_process_id,'
|| 'notification_flag,'
|| 'notification_period,'
|| 'notification_period_uom,'
|| 'parent_task_id,'
|| 'alarm_start,'
|| 'alarm_start_uom,'
|| 'alarm_on,'
|| 'alarm_count,'
|| 'alarm_fired_count,'
|| 'alarm_interval,'
|| 'alarm_interval_uom,'
|| 'attribute1,'
|| 'attribute2,'
|| 'attribute3,'
|| 'attribute4,'
|| 'attribute5,'
|| 'attribute6,'
|| 'attribute7,'
|| 'attribute8,'
|| 'attribute9,'
|| 'attribute10,'
|| 'attribute11,'
|| 'attribute12,'
|| 'attribute13,'
|| 'attribute14,'
|| 'attribute15,'
|| 'attribute_category,'
|| 'owner,'
|| 'cust_account_number,'
|| 'cust_account_id,'
|| 'owner_territory_id,'
|| 'creation_date, '
|| 'escalation_level, '
|| 'object_version_number, '
|| 'location_id '
|| 'from jtf_tasks_v ';
|| '(select * from jtf_task_references_vl r '
|| ' where r.task_id = jtf_tasks_v.task_id '
|| ' and r.object_id = :b100 '
|| ' and r.object_type_code = :b101 ) ';
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_table.DELETE;
v_tbl.DELETE;
DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);
v_select_date VARCHAR2(50) := UPPER(p_date_type || '_' || p_date_start_or_end || '_date');
select decode (p_date_field,
'PLANNED_START_DATE', planned_start_date,
'PLANNED_END_DATE', planned_end_date,
'SCHEDULED_START_DATE', scheduled_start_date,
'SCHEDULED_END_DATE', scheduled_end_date,
'ACTUAL_START_DATE', actual_start_date,
'ACTUAL_END_DATE', actual_end_date, null)
from jtf_tasks_v
where task_id = p_task_id;*/
SELECT DECODE(
p_date_field
, 'PLANNED_START_DATE', planned_start_date
, 'PLANNED_END_DATE', planned_end_date
, 'SCHEDULED_START_DATE', scheduled_start_date
, 'SCHEDULED_END_DATE', scheduled_end_date
, 'ACTUAL_START_DATE', actual_start_date
, 'ACTUAL_END_DATE', actual_end_date
, NULL
)
FROM jtf_tasks_vl jta
, jtf_task_types_tl jttt
, jtf_task_types_b jttb
, jtf_task_statuses_tl jtst
, jtf_task_statuses_b jtsb
, jtf_task_priorities_tl jtpt
, jtf_objects_tl jtot
, jtf_objects_b jtob
, jtf_objects_tl jto2
WHERE jta.task_id = p_task_id
AND jta.task_type_id = jttb.task_type_id
AND jta.task_status_id = jtsb.task_status_id
AND (jta.deleted_flag <> 'Y' OR jta.deleted_flag IS NULL)
AND jta.task_priority_id = jtpt.task_priority_id(+)
AND jta.source_object_type_code = jtob.object_code
AND jta.owner_type_code = jto2.object_code
AND jttb.task_type_id <> 22
AND NVL(jtpt.LANGUAGE, USERENV('lang')) = USERENV('lang')
AND jttt.LANGUAGE = USERENV('lang')
AND jttt.task_type_id = jta.task_type_id
AND jtst.LANGUAGE = USERENV('lang')
AND jtst.task_status_id = jta.task_status_id
AND jtot.LANGUAGE = USERENV('lang')
AND jtot.object_code = jtob.object_code
AND jto2.LANGUAGE = USERENV('lang');
v_select :=
'select '
|| 'v.task_id,'
|| 'v.task_number,'
|| 'v.task_name,'
|| 'v.description,'
|| 'v.task_type_id,'
|| 'v.task_type,'
|| 'v.task_status_id,'
|| 'v.task_status,'
|| 'v.task_priority_id,'
|| 'v.task_priority,'
|| 'v.owner_type_code,'
|| 'v.owner_id,'
|| 'v.assigned_by_id,'
|| 'v.assigned_by_name,'
|| 'v.customer_id,'
|| 'v.customer_name,'
|| 'v.customer_number,'
|| 'v.address_id,'
|| 'v.planned_start_date,'
|| 'v.planned_end_date,'
|| 'v.scheduled_start_date,'
|| 'v.scheduled_end_date,'
|| 'v.actual_start_date,'
|| 'v.actual_end_date,'
|| 'v.source_object_type_code,'
|| 'v.source_object_id,'
|| 'v.source_object_name,'
|| 'v.duration,'
|| 'v.duration_uom,'
|| 'v.planned_effort,'
|| 'v.planned_effort_uom,'
|| 'v.actual_effort,'
|| 'v.actual_effort_uom,'
|| 'v.percentage_complete,'
|| 'v.reason_code,'
|| 'v.private_flag,'
|| 'v.publish_flag,'
|| 'v.multi_booked_flag,'
|| 'v.milestone_flag,'
|| 'v.holiday_flag,'
|| 'v.workflow_process_id,'
|| 'v.notification_flag,'
|| 'v.notification_period,'
|| 'v.notification_period_uom,'
|| 'v.parent_task_id,'
|| 'v.alarm_start,'
|| 'v.alarm_start_uom,'
|| 'v.alarm_on,'
|| 'v.alarm_count,'
|| 'v.alarm_fired_count,'
|| 'v.alarm_interval,'
|| 'v.alarm_interval_uom,'
|| 'v.attribute1,'
|| 'v.attribute2,'
|| 'v.attribute3,'
|| 'v.attribute4,'
|| 'v.attribute5,'
|| 'v.attribute6,'
|| 'v.attribute7,'
|| 'v.attribute8,'
|| 'v.attribute9,'
|| 'v.attribute10,'
|| 'v.attribute11,'
|| 'v.attribute12,'
|| 'v.attribute13,'
|| 'v.attribute14,'
|| 'v.attribute15,'
|| 'v.attribute_category '
|| 'from jtf_tasks_v v ';
v_select := v_select || ', jtf_task_depends d ';
v_select := v_select || ' where v.task_id = d.task_id and ' || v_where;
v_key_date := get_date(v_select_date, p_task_id);
'select min('
|| v_start_date
|| ') from jtf_tasks_v where assigned_by_id = '
|| TO_CHAR(p_assigned_by)
|| ' and '
|| v_start_date
|| ' > :1 ';
'select min('
|| v_start_date
|| ') from jtf_tasks_v where owner_type_code = '''
|| p_owner_type_code
|| ''' and '
|| 'owner_id = '
|| TO_CHAR(p_owner_id)
|| ' and '
|| v_start_date
|| ' > :1 ';
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_table.DELETE;
v_n_tbl.DELETE;
DBMS_SQL.parse(v_cursor_id, v_select, DBMS_SQL.v7);