[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
, 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_task_split_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_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_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 DEFAULT fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
, p_abort_workflow IN VARCHAR2 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
, p_task_split_flag IN VARCHAR2 DEFAULT NULL
, 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
) IS
l_api_version CONSTANT NUMBER := 1.0;
l_date_selected jtf_tasks_b.date_selected%TYPE;
SELECT task_status_id
FROM jtf_task_statuses_b
WHERE task_status_id = b_owner_status_id
--AND assigned_flag = 'Y'
AND assignment_status_flag = 'Y' -- Fix bug 2500664
AND NVL(end_date_active, SYSDATE) >= SYSDATE
AND NVL(start_date_active, SYSDATE) <= SYSDATE;
IF l_date_selected IS NOT NULL AND l_date_selected <> fnd_api.g_miss_char THEN
IF l_date_selected NOT IN('P', 'S', 'A', 'D') THEN
x_return_status := fnd_api.g_ret_sts_unexp_error;
, p_date_selected => p_date_selected
, p_category_id => p_category_id
, p_show_on_calendar => p_show_on_calendar
, p_owner_status_id => l_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 => g_free_busy_type
, p_task_confirmation_status => 'N'
, p_task_confirmation_counter => 0
, 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 => l_location_id
);
, p_last_update_date => SYSDATE
, p_last_updated_by => fnd_global.login_id
, p_attribute1 => p_task_notes_tbl(i).attribute1
, p_attribute2 => p_task_notes_tbl(i).attribute2
, p_attribute3 => p_task_notes_tbl(i).attribute3
, p_attribute4 => p_task_notes_tbl(i).attribute4
, p_attribute5 => p_task_notes_tbl(i).attribute5
, p_attribute6 => p_task_notes_tbl(i).attribute6
, p_attribute7 => p_task_notes_tbl(i).attribute7
, p_attribute8 => p_task_notes_tbl(i).attribute8
, p_attribute9 => p_task_notes_tbl(i).attribute9
, p_attribute10 => p_task_notes_tbl(i).attribute10
, p_attribute11 => p_task_notes_tbl(i).attribute11
, p_attribute12 => p_task_notes_tbl(i).attribute12
, p_attribute13 => p_task_notes_tbl(i).attribute13
, p_attribute14 => p_task_notes_tbl(i).attribute14
, p_attribute15 => p_task_notes_tbl(i).attribute15
, p_context => p_task_notes_tbl(i).CONTEXT
);
, 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_task_split_flag => NULL
, p_reference_flag => NULL
, p_child_position => NULL
, p_child_sequence_num => NULL
, p_location_id => NULL
);
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_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_type_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_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_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_parent_task_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_parent_task_number IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
) IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';
SAVEPOINT update_task_pub1;
update_task
(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, --commented out as it cleared stack fnd_api.g_true,
p_commit => fnd_api.g_false
, p_object_version_number => p_object_version_number
, p_task_id => p_task_id
, p_task_number => p_task_number
, p_task_name => p_task_name
, p_task_type_name => p_task_type_name
, p_task_type_id => p_task_type_id
, p_description => p_description
, p_task_status_name => p_task_status_name
, p_task_status_id => p_task_status_id
, p_task_priority_name => p_task_priority_name
, p_task_priority_id => p_task_priority_id
, p_owner_type_name => p_owner_type_name
, 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_name => p_assigned_by_name
, p_assigned_by_id => p_assigned_by_id
, p_customer_number => p_customer_number
, p_customer_id => p_customer_id
, p_cust_account_number => p_cust_account_number
, p_cust_account_id => p_cust_account_id
, p_address_id => p_address_id
, p_address_number => p_address_number
, 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_timezone_name => p_timezone_name
, 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_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_parent_task_id => p_parent_task_id
, p_parent_task_number => p_parent_task_number
, p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
, p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
);
ROLLBACK TO update_task_pub1;
ROLLBACK TO update_task_pub1;
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_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_type_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_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_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_parent_task_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_parent_task_number IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
) IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';
SAVEPOINT update_task_pub2;
update_task
(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, --commented out as it cleared stack fnd_api.g_true,
p_commit => fnd_api.g_false
, p_object_version_number => p_object_version_number
, p_task_id => p_task_id
, p_task_number => p_task_number
, p_task_name => p_task_name
, p_task_type_name => p_task_type_name
, p_task_type_id => p_task_type_id
, p_description => p_description
, p_task_status_name => p_task_status_name
, p_task_status_id => p_task_status_id
, p_task_priority_name => p_task_priority_name
, p_task_priority_id => p_task_priority_id
, p_owner_type_name => p_owner_type_name
, 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_name => p_assigned_by_name
, p_assigned_by_id => p_assigned_by_id
, p_customer_number => p_customer_number
, p_customer_id => p_customer_id
, p_cust_account_number => p_cust_account_number
, p_cust_account_id => p_cust_account_id
, p_address_id => p_address_id
, p_address_number => p_address_number
, 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_timezone_name => p_timezone_name
, 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_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_parent_task_id => p_parent_task_id
, p_parent_task_number => p_parent_task_number
, p_enable_workflow => p_enable_workflow
, p_abort_workflow => p_abort_workflow
, p_task_split_flag => fnd_api.g_miss_char
, p_child_position => fnd_api.g_miss_char
, p_child_sequence_num => fnd_api.g_miss_num
);
ROLLBACK TO update_task_pub2;
ROLLBACK TO update_task_pub2;
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_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_type_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_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_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_parent_task_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_parent_task_number IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
, 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
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';
SAVEPOINT update_task_pub3;
update_task
(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, --commented out as it cleared stack fnd_api.g_true,
p_commit => fnd_api.g_false
, p_object_version_number => p_object_version_number
, p_task_id => p_task_id
, p_task_number => p_task_number
, p_task_name => p_task_name
, p_task_type_name => p_task_type_name
, p_task_type_id => p_task_type_id
, p_description => p_description
, p_task_status_name => p_task_status_name
, p_task_status_id => p_task_status_id
, p_task_priority_name => p_task_priority_name
, p_task_priority_id => p_task_priority_id
, p_owner_type_name => p_owner_type_name
, 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_name => p_assigned_by_name
, p_assigned_by_id => p_assigned_by_id
, p_customer_number => p_customer_number
, p_customer_id => p_customer_id
, p_cust_account_number => p_cust_account_number
, p_cust_account_id => p_cust_account_id
, p_address_id => p_address_id
, p_address_number => p_address_number
, 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_timezone_name => p_timezone_name
, 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_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_parent_task_id => p_parent_task_id
, p_parent_task_number => p_parent_task_number
, p_enable_workflow => p_enable_workflow
, p_abort_workflow => p_abort_workflow
, 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 => fnd_api.g_miss_num
);
ROLLBACK TO update_task_pub3;
ROLLBACK TO update_task_pub3;
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_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_type_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_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_owner_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
, p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
, 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_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_parent_task_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
, p_parent_task_number IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_enable_workflow IN VARCHAR2
, p_abort_workflow IN VARCHAR2
, 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_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';
l_date_selected jtf_tasks_b.date_selected%TYPE;
CURSOR c_task_update(l_task_id IN NUMBER) IS
SELECT DECODE(p_task_id, fnd_api.g_miss_num, task_id, p_task_id) task_id
, DECODE(p_task_number, fnd_api.g_miss_char, task_number, p_task_number) task_number
, 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_location_id, fnd_api.g_miss_num, location_id, p_location_id) location_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_source_object_type_code
, fnd_api.g_miss_char, 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, p_source_object_id)
source_object_id
, DECODE(
p_source_object_name
, fnd_api.g_miss_char, 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_workflow_process_id
, fnd_api.g_miss_num, workflow_process_id
, p_workflow_process_id
) workflow_process_id
, 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_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
, DECODE(p_date_selected, fnd_api.g_miss_char, date_selected, p_date_selected)
date_selected
, DECODE(p_parent_task_id, fnd_api.g_miss_num, parent_task_id, p_parent_task_id)
parent_task_id
, DECODE(p_task_split_flag, fnd_api.g_miss_char, task_split_flag, p_task_split_flag)
task_split_flag
, DECODE(p_child_position, fnd_api.g_miss_char, child_position, p_child_position)
child_position
, DECODE(
p_child_sequence_num
, fnd_api.g_miss_num, child_sequence_num
, p_child_sequence_num
) child_sequence_num
FROM jtf_tasks_vl
WHERE task_id = l_task_id;
task_rec c_task_update%ROWTYPE;
SELECT task_status_id
FROM jtf_task_statuses_b
WHERE task_status_id = b_owner_status_id
--AND assigned_flag = 'Y'
AND assignment_status_flag = 'Y' -- Fix bug 2500664
AND NVL(end_date_active, SYSDATE) >= SYSDATE
AND NVL(start_date_active, SYSDATE) <= SYSDATE;
SAVEPOINT update_task_pub;
jtf_tasks_iuhk.update_task_pre (x_return_status);
SELECT DECODE(l_task_id, fnd_api.g_miss_num, NULL, l_task_id)
INTO l_task_id
FROM DUAL;
SELECT DECODE(l_task_number, fnd_api.g_miss_char, NULL, l_task_number)
INTO l_task_number
FROM DUAL;
OPEN c_task_update(l_task_id);
FETCH c_task_update
INTO task_rec;
IF c_task_update%NOTFOUND THEN
fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
SELECT DECODE(p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id)
INTO l_customer_id
FROM DUAL;
SELECT DECODE(p_customer_number, fnd_api.g_miss_char, NULL, p_customer_number)
INTO l_customer_number
FROM DUAL;
SELECT DECODE(p_address_id, fnd_api.g_miss_num, NULL, p_address_id)
INTO l_address_id
FROM DUAL;
SELECT DECODE(p_address_number, fnd_api.g_miss_char, NULL, p_address_number)
INTO l_address_number
FROM DUAL;
SELECT DECODE(p_cust_account_id, fnd_api.g_miss_num, NULL, p_cust_account_id)
INTO l_cust_account_id
FROM DUAL;
SELECT DECODE(p_cust_account_number, fnd_api.g_miss_char, NULL, p_cust_account_number)
INTO l_cust_account_number
FROM DUAL;
update jtf_tasks_b
set source_object_name = l_source_object_name
where task_id = l_task_id ;
l_date_selected := task_rec.date_selected;
IF l_date_selected IS NOT NULL AND l_date_selected <> fnd_api.g_miss_char THEN
IF l_date_selected NOT IN('P', 'S', 'A', 'D') THEN
x_return_status := fnd_api.g_ret_sts_unexp_error;
SELECT DECODE(p_parent_task_id, fnd_api.g_miss_num, NULL, p_parent_task_id)
INTO l_parent_task_id
FROM DUAL;
SELECT DECODE(p_parent_task_number, fnd_api.g_miss_char, NULL, p_parent_task_number)
INTO l_parent_task_number
FROM DUAL;
jtf_tasks_pvt.update_task(
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_task_id => l_task_id
, p_task_name => l_task_name
, p_task_type_id => l_task_type_id
, p_description => task_rec.description
, p_task_status_id => l_task_status_id
, p_task_priority_id => l_task_priority_id
, p_owner_type_code => l_owner_type_code
, p_owner_id => l_owner_id
, p_owner_territory_id => p_owner_territory_id
, p_assigned_by_id => l_assigned_by_id
, p_customer_id => l_customer_id
, p_cust_account_id => l_cust_account_id
, p_address_id => l_address_id
, 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
, p_timezone_id => l_timezone_id
, p_source_object_type_code => l_source_object_type_code
, p_source_object_id => l_source_object_id
, p_source_object_name => l_source_object_name
, p_duration => l_duration
, p_duration_uom => l_duration_uom
, p_planned_effort => l_planned_effort
, p_planned_effort_uom => l_planned_effort_uom
, p_actual_effort => l_actual_effort
, p_actual_effort_uom => l_actual_effort_uom
, p_percentage_complete => l_percentage_complete
, p_reason_code => l_reason_code
, p_private_flag => l_private_flag
, p_publish_flag => l_publish_flag
, p_restrict_closure_flag => l_restrict_closure_flag
, p_multi_booked_flag => l_multi_booked_flag
, p_milestone_flag => l_milestone_flag
, p_holiday_flag => l_holiday_flag
, p_billable_flag => l_billable_flag
, p_bound_mode_code => l_bound_mode_code
, p_soft_bound_flag => l_soft_bound_flag
, p_workflow_process_id => task_rec.workflow_process_id
, p_notification_flag => l_notification_flag
, p_notification_period => l_notification_period
, p_notification_period_uom => l_notification_period_uom
, p_parent_task_id => l_parent_task_id
, p_alarm_start => l_alarm_start
, p_alarm_start_uom => l_alarm_start_uom
, p_alarm_on => l_alarm_on
, p_alarm_count => l_alarm_count
, p_alarm_fired_count => l_alarm_fired_count
, p_alarm_interval => l_alarm_interval
, p_alarm_interval_uom => l_alarm_interval_uom
, 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_costs => l_costs
, p_currency_code => l_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 => task_rec.attribute1
, p_attribute2 => task_rec.attribute2
, p_attribute3 => task_rec.attribute3
, p_attribute4 => task_rec.attribute4
, p_attribute5 => task_rec.attribute5
, p_attribute6 => task_rec.attribute6
, p_attribute7 => task_rec.attribute7
, p_attribute8 => task_rec.attribute8
, p_attribute9 => task_rec.attribute9
, p_attribute10 => task_rec.attribute10
, p_attribute11 => task_rec.attribute11
, p_attribute12 => task_rec.attribute12
, p_attribute13 => task_rec.attribute13
, p_attribute14 => task_rec.attribute14
, p_attribute15 => task_rec.attribute15
, p_attribute_category => task_rec.attribute_category
, p_date_selected => task_rec.date_selected
, p_category_id => p_category_id
, p_show_on_calendar => p_show_on_calendar
, p_owner_status_id => l_owner_status_id
, p_enable_workflow => p_enable_workflow
, p_abort_workflow => p_abort_workflow
,
-- p_task_confirmation_status => 'N', -- confirmation status should be changed in jtf_tasks_confirmations apis
p_task_confirmation_status => fnd_api.g_miss_char
, p_task_confirmation_counter => fnd_api.g_miss_num
, p_task_split_flag => task_rec.task_split_flag
, p_change_mode => jtf_task_repeat_appt_pvt.g_one
, p_free_busy_type => g_free_busy_type
, p_child_position => task_rec.child_position
, p_child_sequence_num => task_rec.child_sequence_num
, p_location_id => task_rec.location_id
);
/* jtf_tasks_iuhk.update_task_post (x_return_status);
ROLLBACK TO update_task_pub;
ROLLBACK TO update_task_pub;
ROLLBACK TO update_task_pub;
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 DEFAULT NULL
, p_task_number IN VARCHAR2 DEFAULT NULL
, 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
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK';
SAVEPOINT delete_task_pub2;
delete_task(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_true
, p_commit => fnd_api.g_false
, p_object_version_number => p_object_version_number
, p_task_id => p_task_id
, p_task_number => p_task_number
, 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_pub2;
ROLLBACK TO delete_task_pub2;
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 DEFAULT NULL
, p_task_number IN VARCHAR2 DEFAULT NULL
, 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_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK';
SAVEPOINT delete_task_pub;
jtf_tasks_pvt.delete_task(
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_task_id => l_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 => p_enable_workflow
, p_abort_workflow => p_abort_workflow
);
ROLLBACK TO delete_task_pub;
ROLLBACK TO delete_task_pub;
SELECT task_id
FROM jtf_tasks_b
WHERE task_number = p_task_number;
SELECT NULL
FROM jtf_tasks_vl
WHERE task_name = p_task_name AND NVL(deleted_flag, 'N') = 'N';
SELECT NULL
FROM jtf_tasks_b
WHERE task_id = p_task_id;
SELECT user_id assigned_by_id
FROM fnd_user
WHERE user_name = p_assigned_name
AND NVL(end_date, SYSDATE) >= SYSDATE
AND NVL(start_date, SYSDATE) <= SYSDATE;
SELECT object_code
FROM jtf_objects_vl
WHERE NAME = p_object_name
AND NVL(end_date_active, SYSDATE) >= SYSDATE
AND NVL(start_date_active, SYSDATE) <= SYSDATE;
SELECT party_id
FROM hz_parties
WHERE party_name = p_customer_name;
SELECT party_id
FROM hz_parties
WHERE party_number = p_customer_number;
SELECT cust_account_id
FROM hz_cust_accounts
WHERE account_number = p_cust_account_number;
SELECT task_priority_id
FROM jtf_task_priorities_vl
WHERE NAME = p_task_priority_name
AND NVL(end_date_active, SYSDATE) >= SYSDATE
AND NVL(start_date_active, SYSDATE) <= SYSDATE;
SELECT tk.laptop_flag
, tk.device1_flag
, tk.device2_flag
, tk.device3_flag
, tk.template_id
, tk.template_group_id
, tk.currency_code
, tk.costs
, tk.task_type_id
, tk.task_status_id
, tk.task_priority_id
, tk.owner_id
, tk.owner_type_code
, tk.assigned_by_id
, tk.cust_account_id
, tk.customer_id
, tk.address_id
, tk.location_id
, tk.planned_start_date
, tk.planned_end_date
, tk.scheduled_start_date
, tk.scheduled_end_date
, tk.actual_start_date
, tk.actual_end_date
, tk.source_object_type_code
, tk.timezone_id
, tk.source_object_id
, tk.source_object_name
, tk.DURATION
, tk.duration_uom
, tk.planned_effort
, tk.planned_effort_uom
, tk.actual_effort
, tk.actual_effort_uom
, tk.percentage_complete
, tk.reason_code
, tk.private_flag
, tk.publish_flag
, tk.restrict_closure_flag
, tk.multi_booked_flag
, tk.milestone_flag
, tk.holiday_flag
, tk.billable_flag
, tk.bound_mode_code
, tk.soft_bound_flag
, tk.workflow_process_id
, tk.notification_flag
, tk.notification_period
, tk.notification_period_uom
, tk.parent_task_id
, tk.recurrence_rule_id
, tk.alarm_start
, tk.alarm_start_uom
, tk.alarm_on
, tk.alarm_count
, tk.alarm_fired_count
, tk.alarm_interval
, tk.alarm_interval_uom
, tk.deleted_flag
, tk.palm_flag
, tk.wince_flag
, tk.task_name
, tk.description
, tk.date_selected
, tk.attribute1
, tk.attribute2
, tk.attribute3
, tk.attribute4
, tk.attribute5
, tk.attribute6
, tk.attribute7
, tk.attribute8
, tk.attribute9
, tk.attribute10
, tk.attribute11
, tk.attribute12
, tk.attribute13
, tk.attribute14
, tk.attribute15
, tk.attribute_category
, NVL(tka.category_id, NULL) category_id
, NVL(tka.show_on_calendar, NULL) show_on_calendar
, NVL(tka.assignment_status_id, NULL) assignment_status_id
, tka.free_busy_type free_busy_type
, tk.entity
FROM jtf_tasks_vl tk, jtf_task_all_assignments tka
WHERE tk.task_id = l_source_task_id AND tk.task_id = tka.task_id(+) AND 'OWNER' = tka.assignee_role(+);
SELECT dependent_on_task_id
, dependency_type_code
, template_flag
, adjustment_time
, adjustment_time_uom
, validated_flag
FROM jtf_task_depends
WHERE task_id = l_source_task_id;
SELECT object_type_code
, object_name
, object_id
, object_details
, reference_code
, USAGE
FROM jtf_task_references_vl
WHERE task_id = l_source_task_id;
SELECT date_type_id
, date_value
FROM jtf_task_dates
WHERE task_id = l_source_task_id;
SELECT occurs_which
, day_of_week
, date_of_month
, occurs_month
, occurs_uom
, occurs_every
, occurs_number
, start_date_active
, end_date_active
FROM jtf_task_recur_rules
WHERE recurrence_rule_id = l_recurrence_rule_id;
SELECT task_id
, resource_type_code
, required_units
, enabled_flag
FROM jtf_task_rsc_reqs
WHERE task_id = l_source_task_id;
SELECT resource_type_code
, resource_id
, actual_effort
, actual_effort_uom
, schedule_flag
, alarm_type_code
, alarm_contact
, sched_travel_distance
, sched_travel_duration
, sched_travel_duration_uom
, actual_travel_distance
, actual_travel_duration
, actual_travel_duration_uom
, actual_start_date
, actual_end_date
, palm_flag
, wince_flag
, laptop_flag
, device1_flag
, device2_flag
, device3_flag
, resource_territory_id
, assignment_status_id
, assignee_role
, show_on_calendar
, category_id
, free_busy_type
FROM jtf_task_all_assignments
WHERE task_id = l_source_task_id AND assignee_role = 'ASSIGNEE';
SELECT resource_type_code
, resource_id
, actual_effort
, actual_effort_uom
, schedule_flag
, alarm_type_code
, alarm_contact
, sched_travel_distance
, sched_travel_duration
, sched_travel_duration_uom
, actual_travel_distance
, actual_travel_duration
, actual_travel_duration_uom
, actual_start_date
, actual_end_date
, palm_flag
, wince_flag
, laptop_flag
, device1_flag
, device2_flag
, device3_flag
, resource_territory_id
, assignment_status_id
, assignee_role
, show_on_calendar
, category_id
, free_busy_type
FROM jtf_task_all_assignments
WHERE task_id = l_source_task_id AND assignee_role = 'ASSIGNEE';
SELECT jtf_note_id
, parent_note_id
, source_object_id
, source_object_code
, source_number
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, notes
, notes_detail
, note_status
, entered_by
, entered_by_name
, entered_date
, source_object_meaning
, note_type
, note_type_meaning
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, CONTEXT
, note_status_meaning
FROM jtf_notes_vl
WHERE source_object_id = l_source_task_id AND source_object_code = p_source_object_code;
SELECT task_contact_id
, contact_id
, contact_type_code
, escalation_notify_flag
, escalation_requester_flag
, primary_flag
FROM jtf_task_contacts
WHERE task_id = l_source_task_id;
SELECT phone_id
, task_phone_id
, primary_flag
FROM jtf_task_phones
WHERE task_contact_id = b_contact_id;
, p_date_selected => tasks.date_selected
, p_category_id => tasks.category_id
, p_show_on_calendar => tasks.show_on_calendar
, p_owner_status_id => tasks.assignment_status_id
, p_attribute1 => tasks.attribute1
, p_attribute2 => tasks.attribute2
, p_attribute3 => tasks.attribute3
, p_attribute4 => tasks.attribute4
, p_attribute5 => tasks.attribute5
, p_attribute6 => tasks.attribute6
, p_attribute7 => tasks.attribute7
, p_attribute8 => tasks.attribute8
, p_attribute9 => tasks.attribute9
, p_attribute10 => tasks.attribute10
, p_attribute11 => tasks.attribute11
, p_attribute12 => tasks.attribute12
, p_attribute13 => tasks.attribute13
, p_attribute14 => tasks.attribute14
, p_attribute15 => tasks.attribute15
, p_attribute_category => tasks.attribute_category
, p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
, p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
, p_entity => tasks.entity
, p_free_busy_type => tasks.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_location_id => tasks.location_id
, p_template_id => tasks.template_id
, p_template_group_id => tasks.template_group_id
, p_copied_from_task_id => l_source_task_id
);
SELECT jtf_notes_s.NEXTVAL
INTO l_note_id
FROM DUAL;
jtf_notes_pkg.insert_row(
x_rowid => l_rowid
, x_jtf_note_id => l_note_id
, x_source_object_code => notes_rec.source_object_code
, x_note_status => notes_rec.note_status
, x_entered_by => notes_rec.entered_by
, x_entered_date => notes_rec.entered_date
, x_note_type => notes_rec.note_type
, x_attribute1 => notes_rec.attribute1
, x_attribute2 => notes_rec.attribute2
, x_attribute3 => notes_rec.attribute3
, x_attribute4 => notes_rec.attribute4
, x_attribute5 => notes_rec.attribute5
, x_attribute6 => notes_rec.attribute6
, x_attribute7 => notes_rec.attribute7
, x_attribute8 => notes_rec.attribute8
, x_attribute9 => notes_rec.attribute9
, x_attribute10 => notes_rec.attribute10
, x_attribute11 => notes_rec.attribute11
, x_attribute12 => notes_rec.attribute12
, x_attribute13 => notes_rec.attribute13
, x_attribute14 => notes_rec.attribute14
, x_attribute15 => notes_rec.attribute15
, x_context => notes_rec.CONTEXT
, x_parent_note_id => notes_rec.parent_note_id
, x_source_object_id => l_target_task_id
, x_notes => notes_rec.notes
, x_notes_detail => l_notes_detail
, x_creation_date => notes_rec.creation_date
, x_created_by => notes_rec.created_by
, x_last_update_date => notes_rec.last_update_date
, x_last_updated_by => notes_rec.last_updated_by
, x_last_update_login => notes_rec.last_update_login
);
, p_date_selected => tasks.date_selected
, p_category_id => tasks.category_id
, p_show_on_calendar => tasks.show_on_calendar
, p_owner_status_id => tasks.assignment_status_id
, p_attribute1 => tasks.attribute1
, p_attribute2 => tasks.attribute2
, p_attribute3 => tasks.attribute3
, p_attribute4 => tasks.attribute4
, p_attribute5 => tasks.attribute5
, p_attribute6 => tasks.attribute6
, p_attribute7 => tasks.attribute7
, p_attribute8 => tasks.attribute8
, p_attribute9 => tasks.attribute9
, p_attribute10 => tasks.attribute10
, p_attribute11 => tasks.attribute11
, p_attribute12 => tasks.attribute12
, p_attribute13 => tasks.attribute13
, p_attribute14 => tasks.attribute14
, p_attribute15 => tasks.attribute15
, p_attribute_category => tasks.attribute_category
, p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
, p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
, p_entity => tasks.entity
, p_free_busy_type => tasks.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_location_id => tasks.location_id
, p_template_id => tasks.template_id
, p_template_group_id => tasks.template_group_id
, p_copied_from_task_id => l_source_task_id
);
SELECT recurrence_rule_id
INTO l_recurrence_rule_id
FROM jtf_tasks_b
WHERE task_id = l_source_task_id;
, p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
) IS
l_api_version CONSTANT NUMBER := 1.0;
, p_date_selected => p_date_selected
, p_location_id => NULL
);
, p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
, p_location_id IN NUMBER
) IS
l_api_version CONSTANT NUMBER := 1.0;
l_task_template_group_info.date_selected := p_date_selected;
PROCEDURE update_task_source(
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
, p_source_object_type_code IN VARCHAR2 DEFAULT NULL
, p_source_object_id IN NUMBER DEFAULT NULL
, p_source_object_name IN VARCHAR2 DEFAULT NULL
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_SOURCE';
SAVEPOINT update_task_source;
/* jtf_tasks_pkg.update_row (
x_task_id => p_task_id,
x_object_version_number => p_object_version_number,
x_source_object_type_code => l_source_object_type_code,
x_source_object_id => l_source_object_id,
x_source_object_name => l_source_object_name,
x_last_update_date => SYSDATE,
x_last_updated_by => jtf_task_utl.updated_by,
x_last_update_login => jtf_task_utl.login_id,
);
ROLLBACK TO update_task_source;
ROLLBACK TO update_task_source;
PROCEDURE delete_split_tasks(
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 DEFAULT NULL
, p_task_split_flag IN VARCHAR2 DEFAULT NULL
, p_try_to_reconnect_flag IN VARCHAR2 DEFAULT 'N'
, p_template_flag IN VARCHAR2 DEFAULT 'N'
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
) IS
CURSOR c_task_info(i_task_id jtf_tasks_b.task_id%TYPE) IS
SELECT a.task_id
, b.object_version_number
FROM jtf_task_depends a, jtf_tasks_b b
WHERE a.task_id = i_task_id AND a.task_id = b.task_id
AND b.task_split_flag = p_task_split_flag;
SELECT task_id
, dependent_on_task_id
FROM jtf_task_depends
START WITH dependent_on_task_id = p_task_id
CONNECT BY PRIOR task_id = dependent_on_task_id;
SELECT object_version_number
, task_split_flag
FROM jtf_tasks_b
WHERE task_id = p_task_id;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SPLIT_TASKS';
p_delete_future_recurrences VARCHAR2(1) := 'S';
SAVEPOINT delete_split_tasks_pub;
jtf_tasks_pvt.delete_task(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => l_task_info.object_version_number
, p_task_id => l_task_info.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
);
jtf_tasks_pvt.delete_task(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => task_val.object_version_number
, p_task_id => l_mass_tasks_info.dependent_on_task_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
jtf_tasks_pvt.delete_task(
p_api_version => 1.0
, p_init_msg_list => fnd_api.g_false
, p_commit => fnd_api.g_false
, p_object_version_number => task_val.object_version_number
, p_task_id => l_mass_tasks_info.task_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
ROLLBACK TO delete_split_tasks_pub;
ROLLBACK TO delete_split_tasks_pub;