The following lines contain the word 'select', 'insert', 'update' or 'delete':
P_OLD_DATE_SELECTED IN VARCHAR2 DEFAULT NULL ,
P_NEW_DATE_SELECTED IN VARCHAR2 DEFAULT NULL ,
p_old_location_id IN NUMBER DEFAULT NULL,
p_new_location_id IN NUMBER DEFAULT NULL,
x_task_audit_id OUT NOCOPY NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'JTF_TASK_AUDITS_PVT';
l_last_update_date DATE;
l_last_updated_by NUMBER;
l_date_selected_chan_flag CHAR(1) := 'N';
l_OLD_DATE_SELECTED VARCHAR2(1) := p_OLD_DATE_SELECTED;
l_NEW_DATE_SELECTED VARCHAR2(1) := p_NEW_DATE_SELECTED;
l_last_update_date DATE;
l_last_updated_by NUMBER(15);
l_last_update_login NUMBER(15);
SELECT 1
FROM jtf_task_audits_b
WHERE ROWID = l_rowid;
SELECT jtf_task_audits_s.nextval
FROM dual;
IF (NOT ( p_new_date_selected IS NULL
AND p_old_date_selected IS NULL))
AND ( p_new_date_selected IS NULL
OR p_old_date_selected IS NULL
OR p_new_date_selected <> p_old_date_selected)
THEN
l_date_selected_chan_flag := 'Y';
l_new_date_selected := p_new_date_selected;
l_old_date_selected := p_old_date_selected;
OR l_date_selected_chan_flag = 'Y'
THEN
OPEN c_audit;
jtf_task_audits_pvt.insert_row (
x_rowid => l_rowid,
x_task_audit_id => l_task_audit_id,
x_new_notification_period => l_new_not_period,
x_old_notification_period_uom => l_old_not_period,
x_new_notification_period_uom => l_new_not_period_uom,
x_old_parent_task_id => l_old_parent_task_id,
x_new_parent_task_id => l_new_parent_task_id,
x_old_recurrence_rule_id => l_old_recurrence_rule_id,
x_new_recurrence_rule_id => l_new_recurrence_rule_id,
x_palm_changed_flag => l_palm_chan_flag,
x_wince_changed_flag => l_wince_chan_flag,
x_laptop_changed_flag => l_laptop_chan_flag,
x_device1_changed_flag => l_device1_chan_flag,
x_device2_changed_flag => l_device2_chan_flag,
x_device3_changed_flag => l_device3_chan_flag,
x_old_currency_code => l_old_currency_code,
x_new_currency_code => l_new_currency_code,
x_old_costs => l_old_costs,
x_new_costs => l_new_costs,
x_task_id => l_task_id,
x_old_task_type_id => l_old_task_type_id,
x_new_task_type_id => l_new_task_type_id,
x_old_task_status_id => l_old_task_status_id,
x_new_task_status_id => l_new_task_status_id,
x_old_task_priority_id => l_old_task_priority_id,
x_new_task_priority_id => l_new_task_priority_id,
x_old_owner_id => l_old_owner_id,
x_new_owner_id => l_new_owner_id,
x_old_owner_type_code => l_old_owner_type_code,
x_new_owner_type_code => l_new_owner_type_code,
x_old_assigned_by_id => l_old_assigned_by_id,
x_new_assigned_by_id => l_new_assigned_by_id,
x_old_cust_account_id => l_old_cust_account_id,
x_new_cust_account_id => l_new_cust_account_id,
x_old_customer_id => l_old_customer_id,
x_new_customer_id => l_new_customer_id,
x_old_address_id => l_old_address_id,
x_new_address_id => l_new_address_id,
x_old_planned_start_date => l_old_planned_start_date,
x_new_planned_start_date => l_new_planned_start_date,
x_old_planned_end_date => l_old_planned_end_date,
x_new_planned_end_date => l_new_planned_end_date,
x_old_scheduled_start_date => l_old_sched_start_date,
x_new_scheduled_start_date => l_new_sched_start_date,
x_old_scheduled_end_date => l_old_sched_end_date,
x_new_scheduled_end_date => l_new_sched_end_date,
x_old_actual_start_date => l_old_actual_start_date,
x_new_actual_start_date => l_new_actual_start_date,
x_old_actual_end_date => l_old_actual_end_date,
x_new_actual_end_date => l_new_actual_end_date,
x_old_source_object_type_code => l_old_src_obj_type_code,
x_new_source_object_type_code => l_new_src_obj_type_code,
x_old_timezone_id => l_old_timezone_id,
x_new_timezone_id => l_new_timezone_id,
x_old_source_object_id => l_old_src_obj_id,
x_new_source_object_id => l_new_src_obj_id,
x_old_source_object_name => l_old_src_obj_name,
x_new_source_object_name => l_new_src_obj_name,
x_old_duration => l_old_duration,
x_new_duration => l_new_duration,
x_old_duration_uom => l_old_duration_uom,
x_new_duration_uom => l_new_duration_uom,
x_old_planned_effort => l_old_planned_effort,
x_new_planned_effort => l_new_planned_effort,
x_old_planned_effort_uom => l_old_planned_effort_uom,
x_new_planned_effort_uom => l_new_planned_effort_uom,
x_old_actual_effort => l_old_actual_effort,
x_new_actual_effort => l_new_actual_effort,
x_old_actual_effort_uom => l_old_actual_effort_uom,
x_new_actual_effort_uom => l_new_actual_effort_uom,
x_old_percentage_complete => l_old_per_complete,
x_new_percentage_complete => l_new_per_complete,
x_old_reason_code => l_old_reason_code,
x_new_reason_code => l_new_reason_code,
x_private_changed_flag => l_private_chan_flag,
x_publish_changed_flag => l_publish_chan_flag,
x_restrict_closure_change_flag => l_restrict_closure_chan_flag,
x_multi_booked_changed_flag => l_multi_booked_chan_flag,
x_milestone_changed_flag => l_milestone_chan_flag,
x_holiday_changed_flag => l_holiday_chan_flag,
x_billable_changed_flag => l_billable_chan_flag,
x_old_bound_mode_code => l_old_bound_mode_code,
x_new_bound_mode_code => l_new_bound_mode_code,
x_soft_bound_changed_flag => l_soft_bound_chan_flag,
x_old_workflow_process_id => l_old_workflow_process_id,
x_new_workflow_process_id => l_new_workflow_process_id,
x_notification_changed_flag => l_not_chan_flag,
x_old_notification_period => l_old_not_period,
x_old_task_name => l_old_task_name,
x_new_task_name => l_new_task_name,
x_old_description => l_old_description,
x_new_description => l_new_description,
x_creation_date => SYSDATE,
x_created_by => jtf_task_utl.created_by,
x_last_update_date => SYSDATE,
x_last_updated_by => jtf_task_utl.updated_by,
x_last_update_login => jtf_task_utl.login_id,
x_object_version_number => p_object_version_number ,
x_old_owner_territory_id => l_old_owner_territory_id,
x_new_owner_territory_id => l_new_owner_territory_id,
x_new_escalation_level => l_new_escalation_level,
x_old_escalation_level => l_old_escalation_level,
x_new_date_selected => l_new_date_selected,
x_old_date_selected => l_old_date_selected,
x_new_location_id => l_new_location_id,
x_old_location_id => l_old_location_id
);
p_new_date_selected IN VARCHAR2 DEFAULT NULL,
p_new_location_id IN NUMBER DEFAULT NULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_task_audit_id OUT NOCOPY NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'JTF_TASK_AUDITS_PVT';
l_last_update_date DATE := SYSDATE;
l_last_updated_by NUMBER := -1;
l_new_date_selected VARCHAR2(1) := p_new_date_selected;
l_old_date_selected VARCHAR2(1);
l_last_update_date DATE;
l_last_updated_by NUMBER(15);
l_last_update_login NUMBER(15);
SELECT 1
FROM jtf_task_audits_b
WHERE ROWID = l_rowid;
SELECT attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_category,
task_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
task_number,
task_type_id,
task_status_id,
task_priority_id,
owner_id,
owner_type_code,
assigned_by_id,
cust_account_id,
customer_id,
address_id,
planned_start_date,
palm_flag,
wince_flag,
laptop_flag,
device1_flag,
device2_flag,
device3_flag,
costs,
currency_code,
attribute1,
attribute2,
attribute3,
notification_period,
notification_period_uom,
parent_task_id,
recurrence_rule_id,
alarm_start,
alarm_start_uom,
alarm_on,
alarm_count,
alarm_fired_count,
alarm_interval,
alarm_interval_uom,
deleted_flag,
actual_start_date,
actual_end_date,
source_object_type_code,
timezone_id,
source_object_id,
source_object_name,
duration,
duration_uom,
planned_effort,
planned_effort_uom,
actual_effort,
actual_effort_uom,
percentage_complete,
reason_code,
private_flag,
publish_flag,
restrict_closure_flag,
multi_booked_flag,
milestone_flag,
holiday_flag,
billable_flag,
bound_mode_code,
soft_bound_flag,
workflow_process_id,
notification_flag,
planned_end_date,
scheduled_start_date,
scheduled_end_date,
task_name,
description,
object_version_number,
owner_territory_id,
escalation_level,
date_selected,
location_id
FROM jtf_tasks_vl
WHERE task_id = p_task_id;
SELECT jtf_task_audits_s.nextval
FROM dual;
l_old_date_selected := NULL;
l_old_date_selected := aud_rec.date_selected;
p_old_date_selected => l_old_date_selected,
p_new_date_selected => l_new_date_selected,
p_old_location_id => l_old_location_id,
p_new_location_id => l_new_location_id,
x_task_audit_id => x_task_audit_id
);
procedure INSERT_ROW (
X_ROWID in out NOCOPY VARCHAR2,
X_TASK_AUDIT_ID in NUMBER,
X_NEW_NOTIFICATION_PERIOD in NUMBER,
X_OLD_NOTIFICATION_PERIOD_UOM in VARCHAR2,
X_NEW_NOTIFICATION_PERIOD_UOM in VARCHAR2,
X_OLD_PARENT_TASK_ID in NUMBER,
X_NEW_PARENT_TASK_ID in NUMBER,
X_OLD_RECURRENCE_RULE_ID in NUMBER,
X_NEW_RECURRENCE_RULE_ID in NUMBER,
X_PALM_CHANGED_FLAG in VARCHAR2,
X_WINCE_CHANGED_FLAG in VARCHAR2,
X_LAPTOP_CHANGED_FLAG in VARCHAR2,
X_DEVICE1_CHANGED_FLAG in VARCHAR2,
X_DEVICE2_CHANGED_FLAG in VARCHAR2,
X_DEVICE3_CHANGED_FLAG in VARCHAR2,
X_OLD_CURRENCY_CODE in VARCHAR2,
X_NEW_CURRENCY_CODE in VARCHAR2,
X_OLD_COSTS in NUMBER,
X_NEW_COSTS in NUMBER,
X_TASK_ID in NUMBER,
X_OLD_TASK_TYPE_ID in NUMBER,
X_NEW_TASK_TYPE_ID in NUMBER,
X_OLD_TASK_STATUS_ID in NUMBER,
X_NEW_TASK_STATUS_ID in NUMBER,
X_OLD_TASK_PRIORITY_ID in NUMBER,
X_NEW_TASK_PRIORITY_ID in NUMBER,
X_OLD_OWNER_ID in NUMBER,
X_NEW_OWNER_ID in NUMBER,
X_OLD_OWNER_TYPE_CODE in VARCHAR2,
X_NEW_OWNER_TYPE_CODE in VARCHAR2,
X_OLD_ASSIGNED_BY_ID in NUMBER,
X_NEW_ASSIGNED_BY_ID in NUMBER,
X_OLD_CUST_ACCOUNT_ID in NUMBER,
X_NEW_CUST_ACCOUNT_ID in NUMBER,
X_OLD_CUSTOMER_ID in NUMBER,
X_NEW_CUSTOMER_ID in NUMBER,
X_OLD_ADDRESS_ID in NUMBER,
X_NEW_ADDRESS_ID in NUMBER,
X_OLD_PLANNED_START_DATE in DATE,
X_NEW_PLANNED_START_DATE in DATE,
X_OLD_PLANNED_END_DATE in DATE,
X_NEW_PLANNED_END_DATE in DATE,
X_OLD_SCHEDULED_START_DATE in DATE,
X_NEW_SCHEDULED_START_DATE in DATE,
X_OLD_SCHEDULED_END_DATE in DATE,
X_NEW_SCHEDULED_END_DATE in DATE,
X_OLD_ACTUAL_START_DATE in DATE,
X_NEW_ACTUAL_START_DATE in DATE,
X_OLD_ACTUAL_END_DATE in DATE,
X_NEW_ACTUAL_END_DATE in DATE,
X_OLD_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
X_NEW_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
X_OLD_TIMEZONE_ID in NUMBER,
X_NEW_TIMEZONE_ID in NUMBER,
X_OLD_SOURCE_OBJECT_ID in NUMBER,
X_NEW_SOURCE_OBJECT_ID in NUMBER,
X_OLD_SOURCE_OBJECT_NAME in VARCHAR2,
X_NEW_SOURCE_OBJECT_NAME in VARCHAR2,
X_OLD_DURATION in NUMBER,
X_NEW_DURATION in NUMBER,
X_OLD_DURATION_UOM in VARCHAR2,
X_NEW_DURATION_UOM in VARCHAR2,
X_OLD_PLANNED_EFFORT in NUMBER,
X_NEW_PLANNED_EFFORT in NUMBER,
X_OLD_PLANNED_EFFORT_UOM in VARCHAR2,
X_NEW_PLANNED_EFFORT_UOM in VARCHAR2,
X_OLD_ACTUAL_EFFORT in NUMBER,
X_NEW_ACTUAL_EFFORT in NUMBER,
X_OLD_ACTUAL_EFFORT_UOM in VARCHAR2,
X_NEW_ACTUAL_EFFORT_UOM in VARCHAR2,
X_OLD_PERCENTAGE_COMPLETE in NUMBER,
X_NEW_PERCENTAGE_COMPLETE in NUMBER,
X_OLD_REASON_CODE in VARCHAR2,
X_NEW_REASON_CODE in VARCHAR2,
X_PRIVATE_CHANGED_FLAG in VARCHAR2,
X_PUBLISH_CHANGED_FLAG in VARCHAR2,
X_RESTRICT_CLOSURE_CHANGE_FLAG in VARCHAR2,
X_MULTI_BOOKED_CHANGED_FLAG in VARCHAR2,
X_MILESTONE_CHANGED_FLAG in VARCHAR2,
X_HOLIDAY_CHANGED_FLAG in VARCHAR2,
X_BILLABLE_CHANGED_FLAG in VARCHAR2,
X_OLD_BOUND_MODE_CODE in VARCHAR2,
X_NEW_BOUND_MODE_CODE in VARCHAR2,
X_SOFT_BOUND_CHANGED_FLAG in VARCHAR2,
X_OLD_WORKFLOW_PROCESS_ID in NUMBER,
X_NEW_WORKFLOW_PROCESS_ID in NUMBER,
X_NOTIFICATION_CHANGED_FLAG in VARCHAR2,
X_OLD_NOTIFICATION_PERIOD in NUMBER,
X_OLD_TASK_NAME in VARCHAR2,
X_NEW_TASK_NAME in VARCHAR2,
X_OLD_DESCRIPTION in VARCHAR2,
X_NEW_DESCRIPTION in VARCHAR2,
X_CREATION_DATE in DATE,
X_CREATED_BY in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
X_OBJECT_VERSION_NUMBER in NUMBER,
X_OLD_OWNER_TERRITORY_ID in NUMBER,
X_NEW_OWNER_TERRITORY_ID in NUMBER,
X_NEW_ESCALATION_LEVEL in VARCHAR2,
X_OLD_ESCALATION_LEVEL in VARCHAR2,
X_OLD_DATE_SELECTED in VARCHAR2,
X_NEW_DATE_SELECTED in VARCHAR2,
X_OLD_LOCATION_ID in NUMBER,
X_NEW_LOCATION_ID in NUMBER
) is
cursor C is select ROWID from JTF_TASK_AUDITS_B
where TASK_AUDIT_ID = X_TASK_AUDIT_ID
;
insert into JTF_TASK_AUDITS_B (
NEW_NOTIFICATION_PERIOD,
OLD_NOTIFICATION_PERIOD_UOM,
NEW_NOTIFICATION_PERIOD_UOM,
OLD_PARENT_TASK_ID,
NEW_PARENT_TASK_ID,
OLD_RECURRENCE_RULE_ID,
NEW_RECURRENCE_RULE_ID,
PALM_CHANGED_FLAG,
WINCE_CHANGED_FLAG,
LAPTOP_CHANGED_FLAG,
DEVICE1_CHANGED_FLAG,
DEVICE2_CHANGED_FLAG,
DEVICE3_CHANGED_FLAG,
OLD_CURRENCY_CODE,
NEW_CURRENCY_CODE,
OLD_COSTS,
NEW_COSTS,
TASK_AUDIT_ID,
TASK_ID,
OLD_TASK_TYPE_ID,
NEW_TASK_TYPE_ID,
OLD_TASK_STATUS_ID,
NEW_TASK_STATUS_ID,
OLD_TASK_PRIORITY_ID,
NEW_TASK_PRIORITY_ID,
OLD_OWNER_ID,
NEW_OWNER_ID,
OLD_OWNER_TYPE_CODE,
NEW_OWNER_TYPE_CODE,
OLD_ASSIGNED_BY_ID,
NEW_ASSIGNED_BY_ID,
OLD_CUST_ACCOUNT_ID,
NEW_CUST_ACCOUNT_ID,
OLD_CUSTOMER_ID,
NEW_CUSTOMER_ID,
OLD_ADDRESS_ID,
NEW_ADDRESS_ID,
OLD_PLANNED_START_DATE,
NEW_PLANNED_START_DATE,
OLD_PLANNED_END_DATE,
NEW_PLANNED_END_DATE,
OLD_SCHEDULED_START_DATE,
NEW_SCHEDULED_START_DATE,
OLD_SCHEDULED_END_DATE,
NEW_SCHEDULED_END_DATE,
OLD_ACTUAL_START_DATE,
NEW_ACTUAL_START_DATE,
OLD_ACTUAL_END_DATE,
NEW_ACTUAL_END_DATE,
OLD_SOURCE_OBJECT_TYPE_CODE,
NEW_SOURCE_OBJECT_TYPE_CODE,
OLD_TIMEZONE_ID,
NEW_TIMEZONE_ID,
OLD_SOURCE_OBJECT_ID,
NEW_SOURCE_OBJECT_ID,
OLD_SOURCE_OBJECT_NAME,
NEW_SOURCE_OBJECT_NAME,
OLD_DURATION,
NEW_DURATION,
OLD_DURATION_UOM,
NEW_DURATION_UOM,
OLD_PLANNED_EFFORT,
NEW_PLANNED_EFFORT,
OLD_PLANNED_EFFORT_UOM,
NEW_PLANNED_EFFORT_UOM,
OLD_ACTUAL_EFFORT,
NEW_ACTUAL_EFFORT,
OLD_ACTUAL_EFFORT_UOM,
NEW_ACTUAL_EFFORT_UOM,
OLD_PERCENTAGE_COMPLETE,
NEW_PERCENTAGE_COMPLETE,
OLD_REASON_CODE,
NEW_REASON_CODE,
PRIVATE_CHANGED_FLAG,
PUBLISH_CHANGED_FLAG,
RESTRICT_CLOSURE_CHANGE_FLAG,
MULTI_BOOKED_CHANGED_FLAG,
MILESTONE_CHANGED_FLAG,
HOLIDAY_CHANGED_FLAG,
BILLABLE_CHANGED_FLAG,
OLD_BOUND_MODE_CODE,
NEW_BOUND_MODE_CODE,
SOFT_BOUND_CHANGED_FLAG,
OLD_WORKFLOW_PROCESS_ID,
NEW_WORKFLOW_PROCESS_ID,
NOTIFICATION_CHANGED_FLAG,
OLD_NOTIFICATION_PERIOD,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
OBJECT_VERSION_NUMBER,
OLD_OWNER_TERRITORY_ID,
NEW_OWNER_TERRITORY_ID,
NEW_ESCALATION_LEVEL,
OLD_ESCALATION_LEVEL,
NEW_DATE_SELECTED,
OLD_DATE_SELECTED
) values (
X_NEW_NOTIFICATION_PERIOD,
X_OLD_NOTIFICATION_PERIOD_UOM,
X_NEW_NOTIFICATION_PERIOD_UOM,
X_OLD_PARENT_TASK_ID,
X_NEW_PARENT_TASK_ID,
X_OLD_RECURRENCE_RULE_ID,
X_NEW_RECURRENCE_RULE_ID,
X_PALM_CHANGED_FLAG,
X_WINCE_CHANGED_FLAG,
X_LAPTOP_CHANGED_FLAG,
X_DEVICE1_CHANGED_FLAG,
X_DEVICE2_CHANGED_FLAG,
X_DEVICE3_CHANGED_FLAG,
X_OLD_CURRENCY_CODE,
X_NEW_CURRENCY_CODE,
X_OLD_COSTS,
X_NEW_COSTS,
X_TASK_AUDIT_ID,
X_TASK_ID,
X_OLD_TASK_TYPE_ID,
X_NEW_TASK_TYPE_ID,
X_OLD_TASK_STATUS_ID,
X_NEW_TASK_STATUS_ID,
X_OLD_TASK_PRIORITY_ID,
X_NEW_TASK_PRIORITY_ID,
X_OLD_OWNER_ID,
X_NEW_OWNER_ID,
X_OLD_OWNER_TYPE_CODE,
X_NEW_OWNER_TYPE_CODE,
X_OLD_ASSIGNED_BY_ID,
X_NEW_ASSIGNED_BY_ID,
X_OLD_CUST_ACCOUNT_ID,
X_NEW_CUST_ACCOUNT_ID,
X_OLD_CUSTOMER_ID,
X_NEW_CUSTOMER_ID,
X_OLD_ADDRESS_ID,
X_NEW_ADDRESS_ID,
X_OLD_PLANNED_START_DATE,
X_NEW_PLANNED_START_DATE,
X_OLD_PLANNED_END_DATE,
X_NEW_PLANNED_END_DATE,
X_OLD_SCHEDULED_START_DATE,
X_NEW_SCHEDULED_START_DATE,
X_OLD_SCHEDULED_END_DATE,
X_NEW_SCHEDULED_END_DATE,
X_OLD_ACTUAL_START_DATE,
X_NEW_ACTUAL_START_DATE,
X_OLD_ACTUAL_END_DATE,
X_NEW_ACTUAL_END_DATE,
X_OLD_SOURCE_OBJECT_TYPE_CODE,
X_NEW_SOURCE_OBJECT_TYPE_CODE,
X_OLD_TIMEZONE_ID,
X_NEW_TIMEZONE_ID,
X_OLD_SOURCE_OBJECT_ID,
X_NEW_SOURCE_OBJECT_ID,
X_OLD_SOURCE_OBJECT_NAME,
X_NEW_SOURCE_OBJECT_NAME,
X_OLD_DURATION,
X_NEW_DURATION,
X_OLD_DURATION_UOM,
X_NEW_DURATION_UOM,
X_OLD_PLANNED_EFFORT,
X_NEW_PLANNED_EFFORT,
X_OLD_PLANNED_EFFORT_UOM,
X_NEW_PLANNED_EFFORT_UOM,
X_OLD_ACTUAL_EFFORT,
X_NEW_ACTUAL_EFFORT,
X_OLD_ACTUAL_EFFORT_UOM,
X_NEW_ACTUAL_EFFORT_UOM,
X_OLD_PERCENTAGE_COMPLETE,
X_NEW_PERCENTAGE_COMPLETE,
X_OLD_REASON_CODE,
X_NEW_REASON_CODE,
X_PRIVATE_CHANGED_FLAG,
X_PUBLISH_CHANGED_FLAG,
X_RESTRICT_CLOSURE_CHANGE_FLAG,
X_MULTI_BOOKED_CHANGED_FLAG,
X_MILESTONE_CHANGED_FLAG,
X_HOLIDAY_CHANGED_FLAG,
X_BILLABLE_CHANGED_FLAG,
X_OLD_BOUND_MODE_CODE,
X_NEW_BOUND_MODE_CODE,
X_SOFT_BOUND_CHANGED_FLAG,
X_OLD_WORKFLOW_PROCESS_ID,
X_NEW_WORKFLOW_PROCESS_ID,
X_NOTIFICATION_CHANGED_FLAG,
X_OLD_NOTIFICATION_PERIOD,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
X_OBJECT_VERSION_NUMBER,
X_OLD_OWNER_TERRITORY_ID,
X_NEW_OWNER_TERRITORY_ID,
X_NEW_ESCALATION_LEVEL,
X_OLD_ESCALATION_LEVEL,
X_NEW_DATE_SELECTED,
X_OLD_DATE_SELECTED
);
insert into JTF_TASK_AUDITS_TL (
TASK_AUDIT_ID,
OLD_TASK_NAME,
NEW_TASK_NAME,
OLD_DESCRIPTION,
NEW_DESCRIPTION,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
LANGUAGE,
SOURCE_LANG
) select
X_TASK_AUDIT_ID,
X_OLD_TASK_NAME,
X_NEW_TASK_NAME,
X_OLD_DESCRIPTION,
X_NEW_DESCRIPTION,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN,
L.LANGUAGE_CODE,
userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from JTF_TASK_AUDITS_TL T
where T.TASK_AUDIT_ID = X_TASK_AUDIT_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
end INSERT_ROW;
/* The following delete and update statements are commented out */
/* as a quick workaround to fix the time-consuming table handler issue */
/*
delete from JTF_TASK_AUDITS_TL T
where not exists
(select NULL
from JTF_TASK_AUDITS_B B
where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
);
update JTF_TASK_AUDITS_TL T set (
OLD_TASK_NAME,
NEW_TASK_NAME,
OLD_DESCRIPTION,
NEW_DESCRIPTION
) = (select
B.OLD_TASK_NAME,
B.NEW_TASK_NAME,
B.OLD_DESCRIPTION,
B.NEW_DESCRIPTION
from JTF_TASK_AUDITS_TL B
where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
and B.LANGUAGE = T.SOURCE_LANG)
where (
T.TASK_AUDIT_ID,
T.LANGUAGE
) in (select
SUBT.TASK_AUDIT_ID,
SUBT.LANGUAGE
from JTF_TASK_AUDITS_TL SUBB, JTF_TASK_AUDITS_TL SUBT
where SUBB.TASK_AUDIT_ID = SUBT.TASK_AUDIT_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.OLD_TASK_NAME <> SUBT.OLD_TASK_NAME
or (SUBB.OLD_TASK_NAME is null and SUBT.OLD_TASK_NAME is not null)
or (SUBB.OLD_TASK_NAME is not null and SUBT.OLD_TASK_NAME is null)
or SUBB.NEW_TASK_NAME <> SUBT.NEW_TASK_NAME
or (SUBB.NEW_TASK_NAME is null and SUBT.NEW_TASK_NAME is not null)
or (SUBB.NEW_TASK_NAME is not null and SUBT.NEW_TASK_NAME is null)
or SUBB.OLD_DESCRIPTION <> SUBT.OLD_DESCRIPTION
or (SUBB.OLD_DESCRIPTION is null and SUBT.OLD_DESCRIPTION is not null)
or (SUBB.OLD_DESCRIPTION is not null and SUBT.OLD_DESCRIPTION is null)
or SUBB.NEW_DESCRIPTION <> SUBT.NEW_DESCRIPTION
or (SUBB.NEW_DESCRIPTION is null and SUBT.NEW_DESCRIPTION is not null)
or (SUBB.NEW_DESCRIPTION is not null and SUBT.NEW_DESCRIPTION is null)
)); */
insert into JTF_TASK_AUDITS_TL (
SECURITY_GROUP_ID,
TASK_AUDIT_ID,
OLD_TASK_NAME,
NEW_TASK_NAME,
OLD_DESCRIPTION,
NEW_DESCRIPTION,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
LANGUAGE,
SOURCE_LANG
) select /*+ parallel(B) parallel(L) */
B.SECURITY_GROUP_ID,
B.TASK_AUDIT_ID,
B.OLD_TASK_NAME,
B.NEW_TASK_NAME,
B.OLD_DESCRIPTION,
B.NEW_DESCRIPTION,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from JTF_TASK_AUDITS_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
(select /*+ parallel(T) */ NULL
from JTF_TASK_AUDITS_TL T
where T.TASK_AUDIT_ID = B.TASK_AUDIT_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
update jtf_task_audits_tl set
old_task_name = nvl(x_old_task_name,old_task_name),
new_task_name = nvl(x_new_task_name,new_task_name),
old_description = nvl(x_old_description,old_description),
new_description = nvl(x_new_description,new_description),
LAST_UPDATE_DATE = sysdate,
LAST_UPDATEd_by = decode(x_owner,'SEED',1,0),
LAST_UPDATE_LOGIN = 0,
SOURCE_LANG = userenv('LANG')
where task_audit_id = X_task_audit_id
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);