The following lines contain the word 'select', 'insert', 'update' or 'delete':
t(ddindx).date_selected := a77(indx);
a77(indx) := t(ddindx).date_selected;
, p_date_selected VARCHAR2
, p_category_id NUMBER
, p_show_on_calendar VARCHAR2
, p_owner_status_id NUMBER
, p_template_id NUMBER
, p_template_group_id NUMBER
, p_enable_workflow VARCHAR2
, p_abort_workflow VARCHAR2
, p_task_split_flag VARCHAR2
, p_reference_flag VARCHAR2
, p_child_position VARCHAR2
, p_child_sequence_num NUMBER
, p_location_id NUMBER
)
as
ddp_planned_start_date date;
p_date_selected,
p_category_id,
p_show_on_calendar,
p_owner_status_id,
p_template_id,
p_template_group_id,
p_enable_workflow,
p_abort_workflow,
p_task_split_flag,
p_reference_flag,
p_child_position,
p_child_sequence_num,
p_location_id);
, p_date_selected VARCHAR2
, p_category_id NUMBER
, p_show_on_calendar VARCHAR2
, p_owner_status_id NUMBER
, p_template_id NUMBER
, p_template_group_id NUMBER
, p_enable_workflow VARCHAR2
, p_abort_workflow VARCHAR2
, p_task_split_flag VARCHAR2
, p_reference_flag VARCHAR2
, p_child_position VARCHAR2
, p_child_sequence_num NUMBER
)
as
ddp_planned_start_date date;
p_date_selected,
p_category_id,
p_show_on_calendar,
p_owner_status_id,
p_template_id,
p_template_group_id,
p_enable_workflow,
p_abort_workflow,
p_task_split_flag,
p_reference_flag,
p_child_position,
p_child_sequence_num);
, p_date_selected VARCHAR2
, p_category_id NUMBER
, p_show_on_calendar VARCHAR2
, p_owner_status_id NUMBER
, p_template_id NUMBER
, p_template_group_id NUMBER
, p_enable_workflow VARCHAR2
, p_abort_workflow VARCHAR2
)
as
ddp_planned_start_date date;
p_date_selected,
p_category_id,
p_show_on_calendar,
p_owner_status_id,
p_template_id,
p_template_group_id,
p_enable_workflow,
p_abort_workflow);
, p_date_selected VARCHAR2
, p_category_id NUMBER
, p_show_on_calendar VARCHAR2
, p_owner_status_id NUMBER
, p_template_id NUMBER
, p_template_group_id NUMBER
)
as
ddp_planned_start_date date;
p_date_selected,
p_category_id,
p_show_on_calendar,
p_owner_status_id,
p_template_id,
p_template_group_id);
procedure update_task(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_object_version_number in out nocopy NUMBER
, p_task_id NUMBER
, p_task_number VARCHAR2
, p_task_name VARCHAR2
, p_task_type_name VARCHAR2
, p_task_type_id NUMBER
, p_description VARCHAR2
, p_task_status_name VARCHAR2
, p_task_status_id NUMBER
, p_task_priority_name VARCHAR2
, p_task_priority_id NUMBER
, p_owner_type_name VARCHAR2
, p_owner_type_code VARCHAR2
, p_owner_id NUMBER
, p_owner_territory_id NUMBER
, p_assigned_by_name VARCHAR2
, p_assigned_by_id NUMBER
, p_customer_number VARCHAR2
, p_customer_id NUMBER
, p_cust_account_number VARCHAR2
, p_cust_account_id NUMBER
, p_address_id NUMBER
, p_address_number VARCHAR2
, p_planned_start_date date
, p_planned_end_date date
, p_scheduled_start_date date
, p_scheduled_end_date date
, p_actual_start_date date
, p_actual_end_date date
, p_timezone_id NUMBER
, p_timezone_name VARCHAR2
, p_source_object_type_code VARCHAR2
, p_source_object_id NUMBER
, p_source_object_name VARCHAR2
, p_duration NUMBER
, p_duration_uom VARCHAR2
, p_planned_effort NUMBER
, p_planned_effort_uom VARCHAR2
, p_actual_effort NUMBER
, p_actual_effort_uom VARCHAR2
, p_percentage_complete NUMBER
, p_reason_code VARCHAR2
, p_private_flag VARCHAR2
, p_publish_flag VARCHAR2
, p_restrict_closure_flag VARCHAR2
, p_multi_booked_flag VARCHAR2
, p_milestone_flag VARCHAR2
, p_holiday_flag VARCHAR2
, p_billable_flag VARCHAR2
, p_bound_mode_code VARCHAR2
, p_soft_bound_flag VARCHAR2
, p_workflow_process_id NUMBER
, p_notification_flag VARCHAR2
, p_notification_period NUMBER
, p_notification_period_uom VARCHAR2
, p_alarm_start NUMBER
, p_alarm_start_uom VARCHAR2
, p_alarm_on VARCHAR2
, p_alarm_count NUMBER
, p_alarm_fired_count NUMBER
, p_alarm_interval NUMBER
, p_alarm_interval_uom VARCHAR2
, p_palm_flag VARCHAR2
, p_wince_flag VARCHAR2
, p_laptop_flag VARCHAR2
, p_device1_flag VARCHAR2
, p_device2_flag VARCHAR2
, p_device3_flag VARCHAR2
, p_costs NUMBER
, p_currency_code VARCHAR2
, p_escalation_level VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p_attribute1 VARCHAR2
, p_attribute2 VARCHAR2
, p_attribute3 VARCHAR2
, p_attribute4 VARCHAR2
, p_attribute5 VARCHAR2
, p_attribute6 VARCHAR2
, p_attribute7 VARCHAR2
, p_attribute8 VARCHAR2
, p_attribute9 VARCHAR2
, p_attribute10 VARCHAR2
, p_attribute11 VARCHAR2
, p_attribute12 VARCHAR2
, p_attribute13 VARCHAR2
, p_attribute14 VARCHAR2
, p_attribute15 VARCHAR2
, p_attribute_category VARCHAR2
, p_date_selected VARCHAR2
, p_category_id NUMBER
, p_show_on_calendar VARCHAR2
, p_owner_status_id NUMBER
, p_parent_task_id NUMBER
, p_parent_task_number VARCHAR2
, p_enable_workflow VARCHAR2
, p_abort_workflow VARCHAR2
, p_task_split_flag VARCHAR2
, p_child_position VARCHAR2
, p_child_sequence_num NUMBER
, p_location_id NUMBER
)
as
ddp_planned_start_date date;
jtf_tasks_pub.update_task(p_api_version,
p_init_msg_list,
p_commit,
p_object_version_number,
p_task_id,
p_task_number,
p_task_name,
p_task_type_name,
p_task_type_id,
p_description,
p_task_status_name,
p_task_status_id,
p_task_priority_name,
p_task_priority_id,
p_owner_type_name,
p_owner_type_code,
p_owner_id,
p_owner_territory_id,
p_assigned_by_name,
p_assigned_by_id,
p_customer_number,
p_customer_id,
p_cust_account_number,
p_cust_account_id,
p_address_id,
p_address_number,
ddp_planned_start_date,
ddp_planned_end_date,
ddp_scheduled_start_date,
ddp_scheduled_end_date,
ddp_actual_start_date,
ddp_actual_end_date,
p_timezone_id,
p_timezone_name,
p_source_object_type_code,
p_source_object_id,
p_source_object_name,
p_duration,
p_duration_uom,
p_planned_effort,
p_planned_effort_uom,
p_actual_effort,
p_actual_effort_uom,
p_percentage_complete,
p_reason_code,
p_private_flag,
p_publish_flag,
p_restrict_closure_flag,
p_multi_booked_flag,
p_milestone_flag,
p_holiday_flag,
p_billable_flag,
p_bound_mode_code,
p_soft_bound_flag,
p_workflow_process_id,
p_notification_flag,
p_notification_period,
p_notification_period_uom,
p_alarm_start,
p_alarm_start_uom,
p_alarm_on,
p_alarm_count,
p_alarm_fired_count,
p_alarm_interval,
p_alarm_interval_uom,
p_palm_flag,
p_wince_flag,
p_laptop_flag,
p_device1_flag,
p_device2_flag,
p_device3_flag,
p_costs,
p_currency_code,
p_escalation_level,
x_return_status,
x_msg_count,
x_msg_data,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute_category,
p_date_selected,
p_category_id,
p_show_on_calendar,
p_owner_status_id,
p_parent_task_id,
p_parent_task_number,
p_enable_workflow,
p_abort_workflow,
p_task_split_flag,
p_child_position,
p_child_sequence_num,
p_location_id);
procedure update_task(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_object_version_number in out nocopy NUMBER
, p_task_id NUMBER
, p_task_number VARCHAR2
, p_task_name VARCHAR2
, p_task_type_name VARCHAR2
, p_task_type_id NUMBER
, p_description VARCHAR2
, p_task_status_name VARCHAR2
, p_task_status_id NUMBER
, p_task_priority_name VARCHAR2
, p_task_priority_id NUMBER
, p_owner_type_name VARCHAR2
, p_owner_type_code VARCHAR2
, p_owner_id NUMBER
, p_owner_territory_id NUMBER
, p_assigned_by_name VARCHAR2
, p_assigned_by_id NUMBER
, p_customer_number VARCHAR2
, p_customer_id NUMBER
, p_cust_account_number VARCHAR2
, p_cust_account_id NUMBER
, p_address_id NUMBER
, p_address_number VARCHAR2
, p_planned_start_date date
, p_planned_end_date date
, p_scheduled_start_date date
, p_scheduled_end_date date
, p_actual_start_date date
, p_actual_end_date date
, p_timezone_id NUMBER
, p_timezone_name VARCHAR2
, p_source_object_type_code VARCHAR2
, p_source_object_id NUMBER
, p_source_object_name VARCHAR2
, p_duration NUMBER
, p_duration_uom VARCHAR2
, p_planned_effort NUMBER
, p_planned_effort_uom VARCHAR2
, p_actual_effort NUMBER
, p_actual_effort_uom VARCHAR2
, p_percentage_complete NUMBER
, p_reason_code VARCHAR2
, p_private_flag VARCHAR2
, p_publish_flag VARCHAR2
, p_restrict_closure_flag VARCHAR2
, p_multi_booked_flag VARCHAR2
, p_milestone_flag VARCHAR2
, p_holiday_flag VARCHAR2
, p_billable_flag VARCHAR2
, p_bound_mode_code VARCHAR2
, p_soft_bound_flag VARCHAR2
, p_workflow_process_id NUMBER
, p_notification_flag VARCHAR2
, p_notification_period NUMBER
, p_notification_period_uom VARCHAR2
, p_alarm_start NUMBER
, p_alarm_start_uom VARCHAR2
, p_alarm_on VARCHAR2
, p_alarm_count NUMBER
, p_alarm_fired_count NUMBER
, p_alarm_interval NUMBER
, p_alarm_interval_uom VARCHAR2
, p_palm_flag VARCHAR2
, p_wince_flag VARCHAR2
, p_laptop_flag VARCHAR2
, p_device1_flag VARCHAR2
, p_device2_flag VARCHAR2
, p_device3_flag VARCHAR2
, p_costs NUMBER
, p_currency_code VARCHAR2
, p_escalation_level VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p_attribute1 VARCHAR2
, p_attribute2 VARCHAR2
, p_attribute3 VARCHAR2
, p_attribute4 VARCHAR2
, p_attribute5 VARCHAR2
, p_attribute6 VARCHAR2
, p_attribute7 VARCHAR2
, p_attribute8 VARCHAR2
, p_attribute9 VARCHAR2
, p_attribute10 VARCHAR2
, p_attribute11 VARCHAR2
, p_attribute12 VARCHAR2
, p_attribute13 VARCHAR2
, p_attribute14 VARCHAR2
, p_attribute15 VARCHAR2
, p_attribute_category VARCHAR2
, p_date_selected VARCHAR2
, p_category_id NUMBER
, p_show_on_calendar VARCHAR2
, p_owner_status_id NUMBER
, p_parent_task_id NUMBER
, p_parent_task_number VARCHAR2
, p_enable_workflow VARCHAR2
, p_abort_workflow VARCHAR2
, p_task_split_flag VARCHAR2
, p_child_position VARCHAR2
, p_child_sequence_num NUMBER
)
as
ddp_planned_start_date date;
jtf_tasks_pub.update_task(p_api_version,
p_init_msg_list,
p_commit,
p_object_version_number,
p_task_id,
p_task_number,
p_task_name,
p_task_type_name,
p_task_type_id,
p_description,
p_task_status_name,
p_task_status_id,
p_task_priority_name,
p_task_priority_id,
p_owner_type_name,
p_owner_type_code,
p_owner_id,
p_owner_territory_id,
p_assigned_by_name,
p_assigned_by_id,
p_customer_number,
p_customer_id,
p_cust_account_number,
p_cust_account_id,
p_address_id,
p_address_number,
ddp_planned_start_date,
ddp_planned_end_date,
ddp_scheduled_start_date,
ddp_scheduled_end_date,
ddp_actual_start_date,
ddp_actual_end_date,
p_timezone_id,
p_timezone_name,
p_source_object_type_code,
p_source_object_id,
p_source_object_name,
p_duration,
p_duration_uom,
p_planned_effort,
p_planned_effort_uom,
p_actual_effort,
p_actual_effort_uom,
p_percentage_complete,
p_reason_code,
p_private_flag,
p_publish_flag,
p_restrict_closure_flag,
p_multi_booked_flag,
p_milestone_flag,
p_holiday_flag,
p_billable_flag,
p_bound_mode_code,
p_soft_bound_flag,
p_workflow_process_id,
p_notification_flag,
p_notification_period,
p_notification_period_uom,
p_alarm_start,
p_alarm_start_uom,
p_alarm_on,
p_alarm_count,
p_alarm_fired_count,
p_alarm_interval,
p_alarm_interval_uom,
p_palm_flag,
p_wince_flag,
p_laptop_flag,
p_device1_flag,
p_device2_flag,
p_device3_flag,
p_costs,
p_currency_code,
p_escalation_level,
x_return_status,
x_msg_count,
x_msg_data,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute_category,
p_date_selected,
p_category_id,
p_show_on_calendar,
p_owner_status_id,
p_parent_task_id,
p_parent_task_number,
p_enable_workflow,
p_abort_workflow,
p_task_split_flag,
p_child_position,
p_child_sequence_num);
procedure update_task(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_object_version_number in out nocopy NUMBER
, p_task_id NUMBER
, p_task_number VARCHAR2
, p_task_name VARCHAR2
, p_task_type_name VARCHAR2
, p_task_type_id NUMBER
, p_description VARCHAR2
, p_task_status_name VARCHAR2
, p_task_status_id NUMBER
, p_task_priority_name VARCHAR2
, p_task_priority_id NUMBER
, p_owner_type_name VARCHAR2
, p_owner_type_code VARCHAR2
, p_owner_id NUMBER
, p_owner_territory_id NUMBER
, p_assigned_by_name VARCHAR2
, p_assigned_by_id NUMBER
, p_customer_number VARCHAR2
, p_customer_id NUMBER
, p_cust_account_number VARCHAR2
, p_cust_account_id NUMBER
, p_address_id NUMBER
, p_address_number VARCHAR2
, p_planned_start_date date
, p_planned_end_date date
, p_scheduled_start_date date
, p_scheduled_end_date date
, p_actual_start_date date
, p_actual_end_date date
, p_timezone_id NUMBER
, p_timezone_name VARCHAR2
, p_source_object_type_code VARCHAR2
, p_source_object_id NUMBER
, p_source_object_name VARCHAR2
, p_duration NUMBER
, p_duration_uom VARCHAR2
, p_planned_effort NUMBER
, p_planned_effort_uom VARCHAR2
, p_actual_effort NUMBER
, p_actual_effort_uom VARCHAR2
, p_percentage_complete NUMBER
, p_reason_code VARCHAR2
, p_private_flag VARCHAR2
, p_publish_flag VARCHAR2
, p_restrict_closure_flag VARCHAR2
, p_multi_booked_flag VARCHAR2
, p_milestone_flag VARCHAR2
, p_holiday_flag VARCHAR2
, p_billable_flag VARCHAR2
, p_bound_mode_code VARCHAR2
, p_soft_bound_flag VARCHAR2
, p_workflow_process_id NUMBER
, p_notification_flag VARCHAR2
, p_notification_period NUMBER
, p_notification_period_uom VARCHAR2
, p_alarm_start NUMBER
, p_alarm_start_uom VARCHAR2
, p_alarm_on VARCHAR2
, p_alarm_count NUMBER
, p_alarm_fired_count NUMBER
, p_alarm_interval NUMBER
, p_alarm_interval_uom VARCHAR2
, p_palm_flag VARCHAR2
, p_wince_flag VARCHAR2
, p_laptop_flag VARCHAR2
, p_device1_flag VARCHAR2
, p_device2_flag VARCHAR2
, p_device3_flag VARCHAR2
, p_costs NUMBER
, p_currency_code VARCHAR2
, p_escalation_level VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p_attribute1 VARCHAR2
, p_attribute2 VARCHAR2
, p_attribute3 VARCHAR2
, p_attribute4 VARCHAR2
, p_attribute5 VARCHAR2
, p_attribute6 VARCHAR2
, p_attribute7 VARCHAR2
, p_attribute8 VARCHAR2
, p_attribute9 VARCHAR2
, p_attribute10 VARCHAR2
, p_attribute11 VARCHAR2
, p_attribute12 VARCHAR2
, p_attribute13 VARCHAR2
, p_attribute14 VARCHAR2
, p_attribute15 VARCHAR2
, p_attribute_category VARCHAR2
, p_date_selected VARCHAR2
, p_category_id NUMBER
, p_show_on_calendar VARCHAR2
, p_owner_status_id NUMBER
, p_parent_task_id NUMBER
, p_parent_task_number VARCHAR2
, p_enable_workflow VARCHAR2
, p_abort_workflow VARCHAR2
)
as
ddp_planned_start_date date;
jtf_tasks_pub.update_task(p_api_version,
p_init_msg_list,
p_commit,
p_object_version_number,
p_task_id,
p_task_number,
p_task_name,
p_task_type_name,
p_task_type_id,
p_description,
p_task_status_name,
p_task_status_id,
p_task_priority_name,
p_task_priority_id,
p_owner_type_name,
p_owner_type_code,
p_owner_id,
p_owner_territory_id,
p_assigned_by_name,
p_assigned_by_id,
p_customer_number,
p_customer_id,
p_cust_account_number,
p_cust_account_id,
p_address_id,
p_address_number,
ddp_planned_start_date,
ddp_planned_end_date,
ddp_scheduled_start_date,
ddp_scheduled_end_date,
ddp_actual_start_date,
ddp_actual_end_date,
p_timezone_id,
p_timezone_name,
p_source_object_type_code,
p_source_object_id,
p_source_object_name,
p_duration,
p_duration_uom,
p_planned_effort,
p_planned_effort_uom,
p_actual_effort,
p_actual_effort_uom,
p_percentage_complete,
p_reason_code,
p_private_flag,
p_publish_flag,
p_restrict_closure_flag,
p_multi_booked_flag,
p_milestone_flag,
p_holiday_flag,
p_billable_flag,
p_bound_mode_code,
p_soft_bound_flag,
p_workflow_process_id,
p_notification_flag,
p_notification_period,
p_notification_period_uom,
p_alarm_start,
p_alarm_start_uom,
p_alarm_on,
p_alarm_count,
p_alarm_fired_count,
p_alarm_interval,
p_alarm_interval_uom,
p_palm_flag,
p_wince_flag,
p_laptop_flag,
p_device1_flag,
p_device2_flag,
p_device3_flag,
p_costs,
p_currency_code,
p_escalation_level,
x_return_status,
x_msg_count,
x_msg_data,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute_category,
p_date_selected,
p_category_id,
p_show_on_calendar,
p_owner_status_id,
p_parent_task_id,
p_parent_task_number,
p_enable_workflow,
p_abort_workflow);
procedure update_task(p_api_version NUMBER
, p_init_msg_list VARCHAR2
, p_commit VARCHAR2
, p_object_version_number in out nocopy NUMBER
, p_task_id NUMBER
, p_task_number VARCHAR2
, p_task_name VARCHAR2
, p_task_type_name VARCHAR2
, p_task_type_id NUMBER
, p_description VARCHAR2
, p_task_status_name VARCHAR2
, p_task_status_id NUMBER
, p_task_priority_name VARCHAR2
, p_task_priority_id NUMBER
, p_owner_type_name VARCHAR2
, p_owner_type_code VARCHAR2
, p_owner_id NUMBER
, p_owner_territory_id NUMBER
, p_assigned_by_name VARCHAR2
, p_assigned_by_id NUMBER
, p_customer_number VARCHAR2
, p_customer_id NUMBER
, p_cust_account_number VARCHAR2
, p_cust_account_id NUMBER
, p_address_id NUMBER
, p_address_number VARCHAR2
, p_planned_start_date date
, p_planned_end_date date
, p_scheduled_start_date date
, p_scheduled_end_date date
, p_actual_start_date date
, p_actual_end_date date
, p_timezone_id NUMBER
, p_timezone_name VARCHAR2
, p_source_object_type_code VARCHAR2
, p_source_object_id NUMBER
, p_source_object_name VARCHAR2
, p_duration NUMBER
, p_duration_uom VARCHAR2
, p_planned_effort NUMBER
, p_planned_effort_uom VARCHAR2
, p_actual_effort NUMBER
, p_actual_effort_uom VARCHAR2
, p_percentage_complete NUMBER
, p_reason_code VARCHAR2
, p_private_flag VARCHAR2
, p_publish_flag VARCHAR2
, p_restrict_closure_flag VARCHAR2
, p_multi_booked_flag VARCHAR2
, p_milestone_flag VARCHAR2
, p_holiday_flag VARCHAR2
, p_billable_flag VARCHAR2
, p_bound_mode_code VARCHAR2
, p_soft_bound_flag VARCHAR2
, p_workflow_process_id NUMBER
, p_notification_flag VARCHAR2
, p_notification_period NUMBER
, p_notification_period_uom VARCHAR2
, p_alarm_start NUMBER
, p_alarm_start_uom VARCHAR2
, p_alarm_on VARCHAR2
, p_alarm_count NUMBER
, p_alarm_fired_count NUMBER
, p_alarm_interval NUMBER
, p_alarm_interval_uom VARCHAR2
, p_palm_flag VARCHAR2
, p_wince_flag VARCHAR2
, p_laptop_flag VARCHAR2
, p_device1_flag VARCHAR2
, p_device2_flag VARCHAR2
, p_device3_flag VARCHAR2
, p_costs NUMBER
, p_currency_code VARCHAR2
, p_escalation_level VARCHAR2
, x_return_status out nocopy VARCHAR2
, x_msg_count out nocopy NUMBER
, x_msg_data out nocopy VARCHAR2
, p_attribute1 VARCHAR2
, p_attribute2 VARCHAR2
, p_attribute3 VARCHAR2
, p_attribute4 VARCHAR2
, p_attribute5 VARCHAR2
, p_attribute6 VARCHAR2
, p_attribute7 VARCHAR2
, p_attribute8 VARCHAR2
, p_attribute9 VARCHAR2
, p_attribute10 VARCHAR2
, p_attribute11 VARCHAR2
, p_attribute12 VARCHAR2
, p_attribute13 VARCHAR2
, p_attribute14 VARCHAR2
, p_attribute15 VARCHAR2
, p_attribute_category VARCHAR2
, p_date_selected VARCHAR2
, p_category_id NUMBER
, p_show_on_calendar VARCHAR2
, p_owner_status_id NUMBER
, p_parent_task_id NUMBER
, p_parent_task_number VARCHAR2
)
as
ddp_planned_start_date date;
jtf_tasks_pub.update_task(p_api_version,
p_init_msg_list,
p_commit,
p_object_version_number,
p_task_id,
p_task_number,
p_task_name,
p_task_type_name,
p_task_type_id,
p_description,
p_task_status_name,
p_task_status_id,
p_task_priority_name,
p_task_priority_id,
p_owner_type_name,
p_owner_type_code,
p_owner_id,
p_owner_territory_id,
p_assigned_by_name,
p_assigned_by_id,
p_customer_number,
p_customer_id,
p_cust_account_number,
p_cust_account_id,
p_address_id,
p_address_number,
ddp_planned_start_date,
ddp_planned_end_date,
ddp_scheduled_start_date,
ddp_scheduled_end_date,
ddp_actual_start_date,
ddp_actual_end_date,
p_timezone_id,
p_timezone_name,
p_source_object_type_code,
p_source_object_id,
p_source_object_name,
p_duration,
p_duration_uom,
p_planned_effort,
p_planned_effort_uom,
p_actual_effort,
p_actual_effort_uom,
p_percentage_complete,
p_reason_code,
p_private_flag,
p_publish_flag,
p_restrict_closure_flag,
p_multi_booked_flag,
p_milestone_flag,
p_holiday_flag,
p_billable_flag,
p_bound_mode_code,
p_soft_bound_flag,
p_workflow_process_id,
p_notification_flag,
p_notification_period,
p_notification_period_uom,
p_alarm_start,
p_alarm_start_uom,
p_alarm_on,
p_alarm_count,
p_alarm_fired_count,
p_alarm_interval,
p_alarm_interval_uom,
p_palm_flag,
p_wince_flag,
p_laptop_flag,
p_device1_flag,
p_device2_flag,
p_device3_flag,
p_costs,
p_currency_code,
p_escalation_level,
x_return_status,
x_msg_count,
x_msg_data,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute_category,
p_date_selected,
p_category_id,
p_show_on_calendar,
p_owner_status_id,
p_parent_task_id,
p_parent_task_number);
, p_date_selected VARCHAR2
, p_location_id NUMBER
)
as
ddx_task_details_tbl jtf_tasks_pub.task_details_tbl;
p_date_selected,
p_location_id);
, p_date_selected VARCHAR2
)
as
ddx_task_details_tbl jtf_tasks_pub.task_details_tbl;
p_date_selected);