The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_update_date IN VARCHAR2
) IS
-- Variables Declared for the API
l_loop_counter NUMBER;
SELECT
INCIDENT_ID ,
INCIDENT_NUMBER ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
CREATION_TIME ,
LAST_UPDATE_LOGIN ,
INCIDENT_STATUS_ID ,
to_number(NULL) OLD_INCIDENT_STATUS_ID ,
'N' CHANGE_INCIDENT_STATUS_FLAG ,
INCIDENT_TYPE_ID ,
to_number(NULL) OLD_INCIDENT_TYPE_ID ,
'N' CHANGE_INCIDENT_TYPE_FLAG ,
INCIDENT_URGENCY_ID ,
to_number(NULL) OLD_INCIDENT_URGENCY_ID ,
'N' CHANGE_INCIDENT_URGENCY_FLAG ,
INCIDENT_SEVERITY_ID ,
to_number(NULL) OLD_INCIDENT_SEVERITY_ID ,
'N' CHANGE_INCIDENT_SEVERITY_FLAG,
RESPONSIBLE_GROUP_ID ,
to_number(NULL) OLD_RESPONSIBLE_GROUP_ID ,
'N' CHANGE_RESPONSIBLE_GROUP_FLAG ,
INCIDENT_OWNER_ID ,
to_number(NULL) OLD_INCIDENT_OWNER_ID ,
'N' CHANGE_INCIDENT_OWNER_FLAG ,
EXPECTED_RESOLUTION_DATE,
TO_DATE(NULL) OLD_EXPECTED_RESOLUTION_DATE ,
'N' CHANGE_RESOLUTION_FLAG ,
OWNER_GROUP_ID GROUP_ID ,
to_number(NULL) OLD_GROUP_ID ,
'N' CHANGE_GROUP_FLAG ,
OBLIGATION_DATE ,
TO_DATE(NULL) OLD_OBLIGATION_DATE ,
'N' CHANGE_OBLIGATION_FLAG ,
SITE_ID ,
to_number(NULL) OLD_SITE_ID ,
'N' CHANGE_SITE_FLAG ,
BILL_TO_CONTACT_ID ,
to_number(NULL) OLD_BILL_TO_CONTACT_ID ,
'N' CHANGE_BILL_TO_FLAG ,
SHIP_TO_CONTACT_ID ,
to_number(NULL) OLD_SHIP_TO_CONTACT_ID ,
'N' CHANGE_SHIP_TO_FLAG ,
INCIDENT_DATE ,
TO_DATE(NULL) OLD_INCIDENT_DATE ,
'N' CHANGE_INCIDENT_DATE_FLAG ,
CLOSE_DATE ,
to_date(NULL) OLD_CLOSE_DATE ,
'N' CHANGE_CLOSE_DATE_FLAG ,
CUSTOMER_PRODUCT_ID ,
to_number(NULL) OLD_CUSTOMER_PRODUCT_ID ,
'N' CHANGE_CUSTOMER_PRODUCT_FLAG ,
PLATFORM_ID ,
to_number(NULL) OLD_PLATFORM_ID ,
'N' CHANGE_PLATFORM_ID_FLAG ,
PLATFORM_VERSION_ID ,
to_number(NULL) OLD_PLATFORM_VERSION_ID ,
'N' CHANGE_PLAT_VER_ID_FLAG ,
CP_COMPONENT_ID ,
to_number(NULL) OLD_CP_COMPONENT_ID ,
'N' CHANGE_CP_COMPONENT_ID_FLAG ,
CP_COMPONENT_VERSION_ID ,
to_number(NULL) OLD_CP_COMPONENT_VERSION_ID,
'N' CHANGE_CP_COMP_VER_ID_FLAG ,
CP_SUBCOMPONENT_ID ,
to_number(NULL) OLD_CP_SUBCOMPONENT_ID ,
'N' CHANGE_CP_SUBCOMPONENT_ID_FLAG ,
CP_SUBCOMPONENT_VERSION_ID ,
to_number(NULL) OLD_CP_SUBCOMPONENT_VERSION_ID ,
'N' CHANGE_CP_SUBCOMP_VER_ID_FLAG ,
LANGUAGE_ID ,
to_number(NULL) OLD_LANGUAGE_ID ,
'N' CHANGE_LANGUAGE_ID_FLAG ,
TERRITORY_ID ,
to_number(NULL) OLD_TERRITORY_ID ,
'N' CHANGE_TERRITORY_ID_FLAG ,
CP_REVISION_ID ,
to_number(NULL) OLD_CP_REVISION_ID ,
'N' CHANGE_CP_REVISION_ID_FLAG ,
INV_ITEM_REVISION ,
to_char(NULL) OLD_INV_ITEM_REVISION ,
'N' CHANGE_INV_ITEM_REVISION,
INV_COMPONENT_ID ,
to_number(NULL) OLD_INV_COMPONENT_ID ,
'N' CHANGE_INV_COMPONENT_ID ,
INV_COMPONENT_VERSION ,
to_char(NULL) OLD_INV_COMPONENT_VERSION ,
'N' CHANGE_INV_COMPONENT_VERSION ,
INV_SUBCOMPONENT_ID ,
to_number(NULL) OLD_INV_SUBCOMPONENT_ID ,
'N' CHANGE_INV_SUBCOMPONENT_ID ,
INV_SUBCOMPONENT_VERSION ,
to_char(NULL) OLD_INV_SUBCOMPONENT_VERSION ,
'N' CHANGE_INV_SUBCOMP_VERSION ,
RESOURCE_TYPE ,
to_char(NULL) OLD_RESOURCE_TYPE ,
'N' CHANGE_RESOURCE_TYPE_FLAG ,
to_char(NULL) OLD_GROUP_TYPE ,
GROUP_TYPE ,
'N' CHANGE_GROUP_TYPE_FLAG ,
to_date(NULL) OLD_OWNER_ASSIGNED_TIME ,
OWNER_ASSIGNED_TIME ,
'N' CHANGE_ASSIGNED_TIME_FLAG ,
INV_PLATFORM_ORG_ID ,
to_number(NULL) OLD_INV_PLATFORM_ORG_ID ,
'N' CHANGE_PLATFORM_ORG_ID_FLAG ,
COMPONENT_VERSION ,
to_char(NULL) OLD_COMPONENT_VERSION ,
'N' CHANGE_COMP_VER_FLAG ,
SUBCOMPONENT_VERSION ,
to_char(NULL) OLD_SUBCOMPONENT_VERSION ,
'N' CHANGE_SUBCOMP_VER_FLAG ,
PRODUCT_REVISION ,
to_char(NULL) OLD_PRODUCT_REVISION ,
'N' CHANGE_PRODUCT_REVISION_FLAG ,
INVENTORY_ITEM_ID ,
to_number(NULL) OLD_INVENTORY_ITEM_ID ,
'N' CHANGE_INVENTORY_ITEM_FLAG ,
INV_ORGANIZATION_ID ,
to_number(NULL) OLD_INV_ORGANIZATION_ID ,
'N' CHANGE_INV_ORGANIZATION_FLAG ,
STATUS_FLAG ,
to_char(NULL) OLD_STATUS_FLAG ,
'N' CHANGE_STATUS_FLAG ,
PRIMARY_CONTACT_ID ,
'N' CHANGE_PRIMARY_CONTACT_FLAG ,
to_number(NULL) OLD_PRIMARY_CONTACT_ID ,
SECURITY_GROUP_ID
FROM CS_INCIDENTS_ALL_B
WHERE ROWID BETWEEN c_start_rowid AND c_end_rowid
AND creation_date > p_audit_date;
SELECT
INCIDENT_ID ,
INCIDENT_AUDIT_ID,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
CREATION_TIME ,
INCIDENT_STATUS_ID ,
OLD_INCIDENT_STATUS_ID ,
CHANGE_INCIDENT_STATUS_FLAG ,
INCIDENT_TYPE_ID ,
OLD_INCIDENT_TYPE_ID ,
CHANGE_INCIDENT_TYPE_FLAG ,
INCIDENT_URGENCY_ID ,
OLD_INCIDENT_URGENCY_ID ,
CHANGE_INCIDENT_URGENCY_FLAG ,
INCIDENT_SEVERITY_ID ,
OLD_INCIDENT_SEVERITY_ID ,
CHANGE_INCIDENT_SEVERITY_FLAG,
RESPONSIBLE_GROUP_ID ,
OLD_RESPONSIBLE_GROUP_ID ,
CHANGE_RESPONSIBLE_GROUP_FLAG ,
INCIDENT_OWNER_ID ,
OLD_INCIDENT_OWNER_ID ,
CHANGE_INCIDENT_OWNER_FLAG ,
CREATE_MANUAL_ACTION ,
ACTION_ID ,
EXPECTED_RESOLUTION_DATE,
OLD_EXPECTED_RESOLUTION_DATE ,
CHANGE_RESOLUTION_FLAG ,
GROUP_ID ,
OLD_GROUP_ID ,
CHANGE_GROUP_FLAG ,
OBLIGATION_DATE ,
OLD_OBLIGATION_DATE ,
CHANGE_OBLIGATION_FLAG ,
SITE_ID ,
OLD_SITE_ID ,
CHANGE_SITE_FLAG ,
BILL_TO_CONTACT_ID ,
OLD_BILL_TO_CONTACT_ID ,
CHANGE_BILL_TO_FLAG ,
SHIP_TO_CONTACT_ID ,
OLD_SHIP_TO_CONTACT_ID ,
CHANGE_SHIP_TO_FLAG ,
INCIDENT_DATE ,
OLD_INCIDENT_DATE ,
CHANGE_INCIDENT_DATE_FLAG ,
CLOSE_DATE ,
OLD_CLOSE_DATE ,
CHANGE_CLOSE_DATE_FLAG ,
CUSTOMER_PRODUCT_ID ,
OLD_CUSTOMER_PRODUCT_ID ,
CHANGE_CUSTOMER_PRODUCT_FLAG ,
AUDIT_FIELD ,
OBJECT_VERSION_NUMBER ,
PLATFORM_ID ,
OLD_PLATFORM_ID ,
CHANGE_PLATFORM_ID_FLAG ,
PLATFORM_VERSION_ID ,
OLD_PLATFORM_VERSION_ID ,
CHANGE_PLAT_VER_ID_FLAG ,
CP_COMPONENT_ID ,
OLD_CP_COMPONENT_ID ,
CHANGE_CP_COMPONENT_ID_FLAG ,
CP_COMPONENT_VERSION_ID ,
OLD_CP_COMPONENT_VERSION_ID,
CHANGE_CP_COMP_VER_ID_FLAG ,
CP_SUBCOMPONENT_ID ,
OLD_CP_SUBCOMPONENT_ID ,
CHANGE_CP_SUBCOMPONENT_ID_FLAG ,
CP_SUBCOMPONENT_VERSION_ID ,
OLD_CP_SUBCOMPONENT_VERSION_ID ,
CHANGE_CP_SUBCOMP_VER_ID_FLAG ,
LANGUAGE_ID ,
OLD_LANGUAGE_ID ,
CHANGE_LANGUAGE_ID_FLAG ,
TERRITORY_ID ,
OLD_TERRITORY_ID ,
CHANGE_TERRITORY_ID_FLAG ,
CP_REVISION_ID ,
OLD_CP_REVISION_ID ,
CHANGE_CP_REVISION_ID_FLAG ,
INV_ITEM_REVISION ,
OLD_INV_ITEM_REVISION ,
CHANGE_INV_ITEM_REVISION,
INV_COMPONENT_ID ,
OLD_INV_COMPONENT_ID ,
CHANGE_INV_COMPONENT_ID ,
INV_COMPONENT_VERSION ,
OLD_INV_COMPONENT_VERSION ,
CHANGE_INV_COMPONENT_VERSION ,
INV_SUBCOMPONENT_ID ,
OLD_INV_SUBCOMPONENT_ID ,
CHANGE_INV_SUBCOMPONENT_ID ,
INV_SUBCOMPONENT_VERSION ,
OLD_INV_SUBCOMPONENT_VERSION ,
CHANGE_INV_SUBCOMP_VERSION ,
RESOURCE_TYPE ,
OLD_RESOURCE_TYPE ,
CHANGE_RESOURCE_TYPE_FLAG ,
OLD_GROUP_TYPE ,
GROUP_TYPE ,
CHANGE_GROUP_TYPE_FLAG ,
OLD_OWNER_ASSIGNED_TIME ,
OWNER_ASSIGNED_TIME ,
CHANGE_ASSIGNED_TIME_FLAG ,
INV_PLATFORM_ORG_ID ,
OLD_INV_PLATFORM_ORG_ID ,
CHANGE_PLATFORM_ORG_ID_FLAG ,
COMPONENT_VERSION ,
OLD_COMPONENT_VERSION ,
CHANGE_COMP_VER_FLAG ,
SUBCOMPONENT_VERSION ,
OLD_SUBCOMPONENT_VERSION ,
CHANGE_SUBCOMP_VER_FLAG ,
PRODUCT_REVISION ,
OLD_PRODUCT_REVISION ,
CHANGE_PRODUCT_REVISION_FLAG ,
INVENTORY_ITEM_ID ,
OLD_INVENTORY_ITEM_ID ,
CHANGE_INVENTORY_ITEM_FLAG ,
INV_ORGANIZATION_ID ,
OLD_INV_ORGANIZATION_ID ,
CHANGE_INV_ORGANIZATION_FLAG ,
STATUS_FLAG ,
OLD_STATUS_FLAG ,
CHANGE_STATUS_FLAG ,
PRIMARY_CONTACT_ID ,
CHANGE_PRIMARY_CONTACT_FLAG ,
OLD_PRIMARY_CONTACT_ID ,
SECURITY_GROUP_ID
FROM cs_incidents_audit_b
WHERE INCIDENT_ID = c_incident_id
AND NVL(UPGRADE_FLAG_FOR_CREATE,'N') = 'N'
AND NVL(updated_entity_code, 'SR_HEADER') = 'SR_HEADER'
ORDER BY creation_date desc, incident_audit_id desc;
SELECT
INCIDENT_ID ,
INCIDENT_AUDIT_ID ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
CREATION_TIME ,
INCIDENT_STATUS_ID ,
OLD_INCIDENT_STATUS_ID ,
CHANGE_INCIDENT_STATUS_FLAG ,
INCIDENT_TYPE_ID ,
OLD_INCIDENT_TYPE_ID ,
CHANGE_INCIDENT_TYPE_FLAG ,
INCIDENT_URGENCY_ID ,
OLD_INCIDENT_URGENCY_ID ,
CHANGE_INCIDENT_URGENCY_FLAG ,
INCIDENT_SEVERITY_ID ,
OLD_INCIDENT_SEVERITY_ID ,
CHANGE_INCIDENT_SEVERITY_FLAG,
RESPONSIBLE_GROUP_ID ,
OLD_RESPONSIBLE_GROUP_ID ,
CHANGE_RESPONSIBLE_GROUP_FLAG ,
INCIDENT_OWNER_ID ,
OLD_INCIDENT_OWNER_ID ,
CHANGE_INCIDENT_OWNER_FLAG ,
CREATE_MANUAL_ACTION ,
ACTION_ID ,
EXPECTED_RESOLUTION_DATE,
OLD_EXPECTED_RESOLUTION_DATE ,
CHANGE_RESOLUTION_FLAG ,
GROUP_ID ,
OLD_GROUP_ID ,
CHANGE_GROUP_FLAG ,
OBLIGATION_DATE ,
OLD_OBLIGATION_DATE ,
CHANGE_OBLIGATION_FLAG ,
SITE_ID ,
OLD_SITE_ID ,
CHANGE_SITE_FLAG ,
BILL_TO_CONTACT_ID ,
OLD_BILL_TO_CONTACT_ID ,
CHANGE_BILL_TO_FLAG ,
SHIP_TO_CONTACT_ID ,
OLD_SHIP_TO_CONTACT_ID ,
CHANGE_SHIP_TO_FLAG ,
INCIDENT_DATE ,
OLD_INCIDENT_DATE ,
CHANGE_INCIDENT_DATE_FLAG ,
CLOSE_DATE ,
OLD_CLOSE_DATE ,
CHANGE_CLOSE_DATE_FLAG ,
CUSTOMER_PRODUCT_ID ,
OLD_CUSTOMER_PRODUCT_ID ,
CHANGE_CUSTOMER_PRODUCT_FLAG ,
AUDIT_FIELD ,
OBJECT_VERSION_NUMBER ,
PLATFORM_ID ,
OLD_PLATFORM_ID ,
CHANGE_PLATFORM_ID_FLAG ,
PLATFORM_VERSION_ID ,
OLD_PLATFORM_VERSION_ID ,
CHANGE_PLAT_VER_ID_FLAG ,
CP_COMPONENT_ID ,
OLD_CP_COMPONENT_ID ,
CHANGE_CP_COMPONENT_ID_FLAG ,
CP_COMPONENT_VERSION_ID ,
OLD_CP_COMPONENT_VERSION_ID,
CHANGE_CP_COMP_VER_ID_FLAG ,
CP_SUBCOMPONENT_ID ,
OLD_CP_SUBCOMPONENT_ID ,
CHANGE_CP_SUBCOMPONENT_ID_FLAG ,
CP_SUBCOMPONENT_VERSION_ID ,
OLD_CP_SUBCOMPONENT_VERSION_ID ,
CHANGE_CP_SUBCOMP_VER_ID_FLAG ,
LANGUAGE_ID ,
OLD_LANGUAGE_ID ,
CHANGE_LANGUAGE_ID_FLAG ,
TERRITORY_ID ,
OLD_TERRITORY_ID ,
CHANGE_TERRITORY_ID_FLAG ,
CP_REVISION_ID ,
OLD_CP_REVISION_ID ,
CHANGE_CP_REVISION_ID_FLAG ,
INV_ITEM_REVISION ,
OLD_INV_ITEM_REVISION ,
CHANGE_INV_ITEM_REVISION,
INV_COMPONENT_ID ,
OLD_INV_COMPONENT_ID ,
CHANGE_INV_COMPONENT_ID ,
INV_COMPONENT_VERSION ,
OLD_INV_COMPONENT_VERSION ,
CHANGE_INV_COMPONENT_VERSION ,
INV_SUBCOMPONENT_ID ,
OLD_INV_SUBCOMPONENT_ID ,
CHANGE_INV_SUBCOMPONENT_ID ,
INV_SUBCOMPONENT_VERSION ,
OLD_INV_SUBCOMPONENT_VERSION ,
CHANGE_INV_SUBCOMP_VERSION ,
RESOURCE_TYPE ,
OLD_RESOURCE_TYPE ,
CHANGE_RESOURCE_TYPE_FLAG ,
OLD_GROUP_TYPE ,
GROUP_TYPE ,
CHANGE_GROUP_TYPE_FLAG ,
OLD_OWNER_ASSIGNED_TIME ,
OWNER_ASSIGNED_TIME ,
CHANGE_ASSIGNED_TIME_FLAG ,
INV_PLATFORM_ORG_ID ,
OLD_INV_PLATFORM_ORG_ID ,
CHANGE_PLATFORM_ORG_ID_FLAG ,
COMPONENT_VERSION ,
OLD_COMPONENT_VERSION ,
CHANGE_COMP_VER_FLAG ,
SUBCOMPONENT_VERSION ,
OLD_SUBCOMPONENT_VERSION ,
CHANGE_SUBCOMP_VER_FLAG ,
PRODUCT_REVISION ,
OLD_PRODUCT_REVISION ,
CHANGE_PRODUCT_REVISION_FLAG ,
INVENTORY_ITEM_ID ,
OLD_INVENTORY_ITEM_ID ,
CHANGE_INVENTORY_ITEM_FLAG ,
INV_ORGANIZATION_ID ,
OLD_INV_ORGANIZATION_ID ,
CHANGE_INV_ORGANIZATION_FLAG ,
STATUS_FLAG ,
OLD_STATUS_FLAG ,
CHANGE_STATUS_FLAG ,
PRIMARY_CONTACT_ID ,
CHANGE_PRIMARY_CONTACT_FLAG ,
OLD_PRIMARY_CONTACT_ID ,
SECURITY_GROUP_ID
FROM cs_incidents_audit_b
WHERE INCIDENT_ID = c_incident_id
AND NVL(UPGRADE_FLAG_FOR_CREATE,'N') = 'N'
AND NVL(updated_entity_code,'SR_HEADER') = 'SR_HEADER'
ORDER BY creation_date, incident_audit_id asc;
SELECT close_flag
FROM cs_incident_statuses_b
WHERE incident_status_id = p_incident_status_id;
l_sta_update number :=0;
l_sev_update number :=0;
l_urg_update number :=0;
l_typ_update number :=0;
l_rgp_update number :=0;
l_own_update number :=0;
l_res_update number :=0;
l_grp_update number :=0;
l_obl_update number :=0;
l_sit_update number :=0;
l_bto_update number :=0;
l_sto_update number :=0;
l_idt_update number :=0;
l_cdt_update number :=0;
l_cpd_update number :=0;
l_pid_update number :=0;
l_pvf_update number :=0;
l_cci_update number :=0;
l_cvi_update number :=0;
l_sci_update number :=0;
l_svi_update number :=0;
l_lan_update number :=0;
l_ter_update number :=0;
l_cpr_update number :=0;
l_iiv_update number :=0;
l_ici_update number :=0;
l_icv_update number :=0;
l_isc_update number :=0;
l_isv_update number :=0;
l_rrp_update number :=0;
l_gpt_update number :=0;
l_oat_update number :=0;
l_por_update number :=0;
l_cov_update number :=0;
l_scv_update number :=0;
l_prv_update number :=0;
l_inv_update number :=0;
l_ino_update number :=0;
l_sfl_update number :=0;
l_pci_update number :=0;
l_update_name VARCHAR2(30) := 'csxaucpb.pls'; -- l_update_name will be appended with sysdate, do not make this longer than 18 characters
ad_parallel_updates_pkg.initialize_rowid_range(
ad_parallel_updates_pkg.ROWID_RANGE,
l_table_owner,
l_table_name,
l_update_name || p_update_date, -- to ensure it is rerunnable
x_worker_id,
x_num_workers,
x_batch_size, 0);
ad_parallel_updates_pkg.get_rowid_range(
l_start_rowid,
l_end_rowid,
l_any_rows_to_process,
x_batch_size,
TRUE);
l_sta_update :=0;
l_sev_update :=0;
l_urg_update :=0;
l_typ_update :=0;
l_rgp_update :=0;
l_own_update :=0;
l_res_update :=0;
l_grp_update :=0;
l_obl_update :=0;
l_sit_update :=0;
l_bto_update :=0;
l_sto_update :=0;
l_idt_update :=0;
l_cdt_update :=0;
l_cpd_update :=0;
l_pid_update :=0;
l_pvf_update :=0;
l_cci_update :=0;
l_cvi_update :=0;
l_sci_update :=0;
l_svi_update :=0;
l_lan_update :=0;
l_ter_update :=0;
l_cpr_update :=0;
l_iiv_update :=0;
l_ici_update :=0;
l_icv_update :=0;
l_isc_update :=0;
l_isv_update :=0;
l_rrp_update :=0;
l_gpt_update :=0;
l_oat_update :=0;
l_por_update :=0;
l_cov_update :=0;
l_scv_update :=0;
l_prv_update :=0;
l_inv_update :=0;
l_ino_update :=0;
l_sfl_update :=0;
l_pci_update :=0;
select count(incident_audit_id) into l_audit_count
from cs_incidents_audit_b
where incident_id= l_request_id
and NVL(upgrade_flag_for_create,'N') = 'N'
and NVL(updated_entity_code, 'SR_HEADER') = 'SR_HEADER';
l_sta_update := 1;
if l_sta_update >0 then
if l_create_audit_rec.old_INCIDENT_STATUS_ID is not null then
l_create_audit_rec.INCIDENT_STATUS_ID := l_create_audit_rec.old_INCIDENT_STATUS_ID ;
l_sta_update := 0;
l_typ_update := 1;
if l_typ_update >0 then
if (l_create_audit_rec.OLD_INCIDENT_TYPE_ID is not null) then
l_create_audit_rec.INCIDENT_TYPE_ID := l_create_audit_rec.OLD_INCIDENT_TYPE_ID ;
l_typ_update := 0;
l_urg_update := 1;
if l_urg_update >0 then
l_create_audit_rec.INCIDENT_URGENCY_ID := l_create_audit_rec.OLD_INCIDENT_URGENCY_ID ;
l_urg_update := 0;
l_sev_update := 1;
if l_sev_update >0 then
if (l_create_audit_rec.OLD_INCIDENT_SEVERITY_ID is not null) then
l_create_audit_rec.INCIDENT_SEVERITY_ID := l_create_audit_rec.OLD_INCIDENT_SEVERITY_ID ;
l_sev_update := 0;
l_rgp_update := 1;
if l_rgp_update >0 then
l_create_audit_rec.RESPONSIBLE_GROUP_ID := l_create_audit_rec.OLD_RESPONSIBLE_GROUP_ID ;
l_rgp_update := 0;
l_oat_update := 1;
l_own_update := 1;
l_rrp_update := 1;
if l_rrp_update >0 then
l_create_audit_rec.RESOURCE_TYPE := l_create_audit_rec.OLD_RESOURCE_TYPE ;
l_rrp_update := 0;
if l_own_update >0 then
l_create_audit_rec.INCIDENT_OWNER_ID := l_create_audit_rec.OLD_INCIDENT_OWNER_ID ;
l_own_update := 0;
if l_oat_update >0 then
l_create_audit_rec.OWNER_ASSIGNED_TIME := l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME ;
l_oat_update := 0;
if l_rrp_update >0 then
l_create_audit_rec.RESOURCE_TYPE := l_create_audit_rec.OLD_RESOURCE_TYPE ;
l_rrp_update := 0;
l_res_update := 1;
if l_res_update >0 then
l_create_audit_rec.EXPECTED_RESOLUTION_DATE := l_create_audit_rec.OLD_EXPECTED_RESOLUTION_DATE ;
l_res_update := 0;
l_grp_update := 1;
l_gpt_update := 1;
if l_grp_update >0 then
l_create_audit_rec.GROUP_ID := l_create_audit_rec.OLD_GROUP_ID ;
l_grp_update := 0;
if l_gpt_update >0 then
l_create_audit_rec.GROUP_TYPE := l_create_audit_rec.OLD_GROUP_TYPE ;
l_gpt_update := 0;
l_obl_update := 1;
if l_obl_update >0 then
l_create_audit_rec.OBLIGATION_DATE := l_create_audit_rec.OLD_OBLIGATION_DATE ;
l_obl_update := 0;
l_sit_update := 1;
if l_sit_update >0 then
l_create_audit_rec.SITE_ID := l_create_audit_rec.OLD_SITE_ID ;
l_sit_update := 0;
l_bto_update := 1;
if l_bto_update >0 then
l_create_audit_rec.BILL_TO_CONTACT_ID := l_create_audit_rec.OLD_BILL_TO_CONTACT_ID ;
l_bto_update := 0;
l_sto_update := 1;
if l_sto_update >0 then
l_create_audit_rec.SHIP_TO_CONTACT_ID := l_create_audit_rec.OLD_SHIP_TO_CONTACT_ID ;
l_sto_update := 0;
l_idt_update := 1;
if l_idt_update >0 then
l_create_audit_rec.INCIDENT_DATE := l_create_audit_rec.OLD_INCIDENT_DATE ;
l_idt_update := 0;
l_cpd_update := 1;
if l_cpd_update >0 then
l_create_audit_rec.CUSTOMER_PRODUCT_ID := l_create_audit_rec.OLD_CUSTOMER_PRODUCT_ID ;
l_cpd_update := 0;
l_pid_update := 1;
if l_pid_update >0 then
l_create_audit_rec.PLATFORM_ID := l_create_audit_rec.OLD_PLATFORM_ID ;
l_pid_update := 0;
l_pvf_update := 1;
if l_pvf_update >0 then
l_create_audit_rec.PLATFORM_VERSION_ID := l_create_audit_rec.OLD_PLATFORM_VERSION_ID ;
l_pvf_update := 0;
l_cci_update := 1;
if l_cci_update >0 then
l_create_audit_rec.CP_COMPONENT_ID := l_create_audit_rec.OLD_CP_COMPONENT_ID ;
l_cci_update := 0;
l_cvi_update := 1;
if l_cvi_update >0 then
l_create_audit_rec.CP_COMPONENT_VERSION_ID := l_create_audit_rec.OLD_CP_COMPONENT_VERSION_ID ;
l_cvi_update := 0;
l_sci_update := 1;
if l_sci_update >0 then
l_create_audit_rec.CP_SUBCOMPONENT_ID := l_create_audit_rec.OLD_CP_SUBCOMPONENT_ID ;
l_sci_update := 0;
l_svi_update := 1;
if l_svi_update >0 then
l_create_audit_rec.CP_SUBCOMPONENT_VERSION_ID := l_create_audit_rec.OLD_CP_SUBCOMPONENT_VERSION_ID ;
l_svi_update := 0;
l_lan_update := 1;
if l_lan_update >0 then
l_create_audit_rec.LANGUAGE_ID := l_create_audit_rec.OLD_LANGUAGE_ID ;
l_lan_update := 0;
l_ter_update := 1;
if l_ter_update >0 then
l_create_audit_rec.TERRITORY_ID := l_create_audit_rec.OLD_TERRITORY_ID ;
l_ter_update := 0;
l_cpr_update := 1;
if l_cpr_update >0 then
l_create_audit_rec.CP_REVISION_ID := l_create_audit_rec.CP_REVISION_ID ;
l_cpr_update := 0;
l_iiv_update := 1;
if l_iiv_update >0 then
l_create_audit_rec.INV_ITEM_REVISION := l_create_audit_rec.OLD_INV_ITEM_REVISION ;
l_iiv_update := 0;
l_ici_update := 1;
if l_ici_update >0 then
l_create_audit_rec.INV_COMPONENT_ID := l_create_audit_rec.OLD_INV_COMPONENT_ID ;
l_ici_update := 0;
l_icv_update := 1;
if l_icv_update >0 then
l_create_audit_rec.INV_COMPONENT_VERSION := l_create_audit_rec.OLD_INV_COMPONENT_VERSION ;
l_icv_update := 0;
l_isc_update := 1;
if l_isc_update >0 then
l_create_audit_rec.INV_SUBCOMPONENT_ID := l_create_audit_rec.OLD_INV_SUBCOMPONENT_ID ;
l_isc_update := 0;
l_isv_update := 1;
if l_isv_update >0 then
l_create_audit_rec.INV_SUBCOMPONENT_VERSION := l_create_audit_rec.OLD_INV_SUBCOMPONENT_VERSION ;
l_isv_update := 0;
l_por_update := 1;
if l_por_update >0 then
l_create_audit_rec.INV_PLATFORM_ORG_ID := l_create_audit_rec.OLD_INV_PLATFORM_ORG_ID ;
l_por_update := 0;
l_cov_update := 1;
if l_cov_update >0 then
l_create_audit_rec.COMPONENT_VERSION := l_create_audit_rec.OLD_COMPONENT_VERSION ;
l_cov_update := 0;
l_scv_update := 1;
if l_scv_update >0 then
l_create_audit_rec.SUBCOMPONENT_VERSION := l_create_audit_rec.OLD_SUBCOMPONENT_VERSION ;
l_scv_update := 0;
l_prv_update := 1;
if l_prv_update >0 then
l_create_audit_rec.PRODUCT_REVISION := l_create_audit_rec.OLD_PRODUCT_REVISION ;
l_prv_update := 0;
l_inv_update := 1;
if l_inv_update >0 then
l_create_audit_rec.INVENTORY_ITEM_ID := l_create_audit_rec.OLD_INVENTORY_ITEM_ID ;
l_inv_update := 0;
l_ino_update := 1;
if l_ino_update >0 then
l_create_audit_rec.INV_ORGANIZATION_ID := l_create_audit_rec.OLD_INV_ORGANIZATION_ID ;
l_ino_update := 0;
l_pci_update := 1;
if l_pci_update >0 then
l_create_audit_rec.PRIMARY_CONTACT_ID := l_create_audit_rec.OLD_PRIMARY_CONTACT_ID ;
l_pci_update := 0;
Update cs_incidents_audit_b
set INCIDENT_STATUS_ID = decode(l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_STATUS_ID,l_create_audit_rec.INCIDENT_STATUS_ID),
CHANGE_INCIDENT_STATUS_FLAG = decode(l_create_audit_rec.INCIDENT_STATUS_ID,NULL,'N','Y'),
INCIDENT_TYPE_ID = decode(l_create_audit_rec.CHANGE_INCIDENT_TYPE_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_TYPE_ID,l_create_audit_rec.INCIDENT_TYPE_ID),
CHANGE_INCIDENT_TYPE_FLAG = decode(l_create_audit_rec.INCIDENT_TYPE_ID,NULL,'N','Y'),
INCIDENT_URGENCY_ID = decode(l_create_audit_rec.CHANGE_INCIDENT_URGENCY_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_URGENCY_ID,l_create_audit_rec.INCIDENT_URGENCY_ID),
CHANGE_INCIDENT_URGENCY_FLAG = decode(l_create_audit_rec.INCIDENT_URGENCY_ID,NULL,'N','Y'),
INCIDENT_SEVERITY_ID = decode(l_create_audit_rec.CHANGE_INCIDENT_SEVERITY_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_SEVERITY_ID,l_create_audit_rec.INCIDENT_SEVERITY_ID),
CHANGE_INCIDENT_SEVERITY_FLAG = decode(l_create_audit_rec.INCIDENT_SEVERITY_ID,NULL,'N','Y'),
RESPONSIBLE_GROUP_ID = decode(l_create_audit_rec.CHANGE_RESPONSIBLE_GROUP_FLAG,'Y',l_create_audit_rec.OLD_RESPONSIBLE_GROUP_ID,l_create_audit_rec.RESPONSIBLE_GROUP_ID),
CHANGE_RESPONSIBLE_GROUP_FLAG = decode(l_create_audit_rec.RESPONSIBLE_GROUP_ID,NULL,'N','Y'),
INCIDENT_OWNER_ID = decode(l_create_audit_rec.CHANGE_INCIDENT_OWNER_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_OWNER_ID,l_create_audit_rec.INCIDENT_OWNER_ID),
CHANGE_INCIDENT_OWNER_FLAG = decode(decode(l_create_audit_rec.CHANGE_INCIDENT_OWNER_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_OWNER_ID,l_create_audit_rec.INCIDENT_OWNER_ID),NULL,'N','Y'),
EXPECTED_RESOLUTION_DATE= decode(l_create_audit_rec.CHANGE_RESOLUTION_FLAG,'Y',l_create_audit_rec.OLD_EXPECTED_RESOLUTION_DATE,l_create_audit_rec.EXPECTED_RESOLUTION_DATE),
CHANGE_RESOLUTION_FLAG = decode(decode(l_create_audit_rec.CHANGE_RESOLUTION_FLAG,'Y',l_create_audit_rec.OLD_EXPECTED_RESOLUTION_DATE,l_create_audit_rec.EXPECTED_RESOLUTION_DATE),NULL,'N','Y'),
GROUP_ID = decode(l_create_audit_rec.CHANGE_GROUP_FLAG,'Y',l_create_audit_rec.OLD_GROUP_ID,l_create_audit_rec.GROUP_ID),
CHANGE_GROUP_FLAG = decode(decode(l_create_audit_rec.CHANGE_GROUP_FLAG,'Y',l_create_audit_rec.OLD_GROUP_ID,l_create_audit_rec.GROUP_ID),NULL,'N','Y'),
OBLIGATION_DATE = decode(l_create_audit_rec.CHANGE_OBLIGATION_FLAG,'Y',l_create_audit_rec.OLD_OBLIGATION_DATE,l_create_audit_rec.OBLIGATION_DATE) ,
CHANGE_OBLIGATION_FLAG = decode(decode(l_create_audit_rec.CHANGE_OBLIGATION_FLAG,'Y',l_create_audit_rec.OLD_OBLIGATION_DATE,l_create_audit_rec.OBLIGATION_DATE),NULL,'N','Y'),
SITE_ID = decode(l_create_audit_rec.CHANGE_SITE_FLAG,'Y',l_create_audit_rec.OLD_SITE_ID,l_create_audit_rec.SITE_ID),
CHANGE_SITE_FLAG = decode(decode(l_create_audit_rec.CHANGE_SITE_FLAG,'Y',l_create_audit_rec.OLD_SITE_ID,l_create_audit_rec.SITE_ID),NULL,'N','Y'),
BILL_TO_CONTACT_ID = decode(l_create_audit_rec.CHANGE_BILL_TO_FLAG,'Y',l_create_audit_rec.OLD_BILL_TO_CONTACT_ID,l_create_audit_rec.BILL_TO_CONTACT_ID) ,
CHANGE_BILL_TO_FLAG = decode(decode(l_create_audit_rec.CHANGE_BILL_TO_FLAG,'Y',l_create_audit_rec.OLD_BILL_TO_CONTACT_ID,l_create_audit_rec.BILL_TO_CONTACT_ID),NULL,'N','Y'),
SHIP_TO_CONTACT_ID = decode(l_create_audit_rec.CHANGE_SHIP_TO_FLAG,'Y',l_create_audit_rec.OLD_SHIP_TO_CONTACT_ID,l_create_audit_rec.SHIP_TO_CONTACT_ID),
CHANGE_SHIP_TO_FLAG = decode(decode(l_create_audit_rec.CHANGE_SHIP_TO_FLAG,'Y',l_create_audit_rec.OLD_SHIP_TO_CONTACT_ID,l_create_audit_rec.SHIP_TO_CONTACT_ID),NULL,'N','Y'),
INCIDENT_DATE = decode(l_create_audit_rec.CHANGE_INCIDENT_DATE_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_DATE,l_create_audit_rec.INCIDENT_DATE),
CHANGE_INCIDENT_DATE_FLAG = decode(decode(l_create_audit_rec.CHANGE_INCIDENT_DATE_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_DATE,l_create_audit_rec.INCIDENT_DATE),NULL,'N','Y'),
CLOSE_DATE = decode(l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,'Y',l_create_audit_rec.OLD_CLOSE_DATE,l_create_audit_rec.CLOSE_DATE),
CHANGE_CLOSE_DATE_FLAG = decode(decode(l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,'Y',l_create_audit_rec.OLD_CLOSE_DATE,l_create_audit_rec.CLOSE_DATE),NULL,'N','Y'),
CUSTOMER_PRODUCT_ID = decode(l_create_audit_rec.CHANGE_CUSTOMER_PRODUCT_FLAG,'Y',l_create_audit_rec.OLD_CUSTOMER_PRODUCT_ID,l_create_audit_rec.CUSTOMER_PRODUCT_ID),
CHANGE_CUSTOMER_PRODUCT_FLAG = decode(decode(l_create_audit_rec.CHANGE_CUSTOMER_PRODUCT_FLAG,'Y',l_create_audit_rec.OLD_CUSTOMER_PRODUCT_ID,l_create_audit_rec.CUSTOMER_PRODUCT_ID),NULL,'N','Y'),
PLATFORM_ID = decode(l_create_audit_rec.CHANGE_PLATFORM_ID_FLAG,'Y',l_create_audit_rec.OLD_PLATFORM_ID,l_create_audit_rec.PLATFORM_ID),
CHANGE_PLATFORM_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_PLATFORM_ID_FLAG,'Y',l_create_audit_rec.OLD_PLATFORM_ID,l_create_audit_rec.PLATFORM_ID),NULL,'N','Y'),
PLATFORM_VERSION_ID = decode(l_create_audit_rec.CHANGE_PLAT_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_PLATFORM_VERSION_ID,l_create_audit_rec.PLATFORM_VERSION_ID),
CHANGE_PLAT_VER_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_PLAT_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_PLATFORM_VERSION_ID,l_create_audit_rec.PLATFORM_VERSION_ID),NULL,'N','Y'),
CP_COMPONENT_ID = decode(l_create_audit_rec.CHANGE_CP_COMPONENT_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_COMPONENT_ID,l_create_audit_rec.CP_COMPONENT_ID),
CHANGE_CP_COMPONENT_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_CP_COMPONENT_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_COMPONENT_ID,l_create_audit_rec.CP_COMPONENT_ID),NULL,'N','Y'),
CP_COMPONENT_VERSION_ID = decode(l_create_audit_rec.CHANGE_CP_COMP_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_COMPONENT_VERSION_ID,l_create_audit_rec.CP_COMPONENT_VERSION_ID),
CHANGE_CP_COMP_VER_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_CP_COMP_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_COMPONENT_VERSION_ID,l_create_audit_rec.CP_COMPONENT_VERSION_ID),NULL,'N','Y'),
CP_SUBCOMPONENT_ID = decode(l_create_audit_rec.CHANGE_CP_SUBCOMPONENT_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_SUBCOMPONENT_ID,l_create_audit_rec.CP_SUBCOMPONENT_ID),
CHANGE_CP_SUBCOMPONENT_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_CP_SUBCOMPONENT_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_SUBCOMPONENT_ID,l_create_audit_rec.CP_SUBCOMPONENT_ID),NULL,'N','Y'),
CP_SUBCOMPONENT_VERSION_ID = decode(l_create_audit_rec.CHANGE_CP_SUBCOMP_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_SUBCOMPONENT_VERSION_ID,l_create_audit_rec.CP_SUBCOMPONENT_VERSION_ID),
CHANGE_CP_SUBCOMP_VER_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_CP_SUBCOMP_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_SUBCOMPONENT_VERSION_ID,l_create_audit_rec.CP_SUBCOMPONENT_VERSION_ID),NULL,'N','Y'),
LANGUAGE_ID = decode(l_create_audit_rec.CHANGE_LANGUAGE_ID_FLAG,'Y',l_create_audit_rec.OLD_LANGUAGE_ID,l_create_audit_rec.LANGUAGE_ID),
CHANGE_LANGUAGE_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_LANGUAGE_ID_FLAG,'Y',l_create_audit_rec.OLD_LANGUAGE_ID,l_create_audit_rec.LANGUAGE_ID),NULL,'N','Y'),
TERRITORY_ID = decode(l_create_audit_rec.CHANGE_TERRITORY_ID_FLAG,'Y',l_create_audit_rec.OLD_TERRITORY_ID,l_create_audit_rec.TERRITORY_ID),
CHANGE_TERRITORY_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_TERRITORY_ID_FLAG,'Y',l_create_audit_rec.OLD_TERRITORY_ID,l_create_audit_rec.TERRITORY_ID),NULL,'N','Y'),
CP_REVISION_ID = decode(l_create_audit_rec.CHANGE_CP_REVISION_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_REVISION_ID,l_create_audit_rec.CP_REVISION_ID),
CHANGE_CP_REVISION_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_CP_REVISION_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_REVISION_ID,l_create_audit_rec.CP_REVISION_ID),NULL,'N','Y'),
INV_ITEM_REVISION = decode(l_create_audit_rec.CHANGE_INV_ITEM_REVISION,'Y',l_create_audit_rec.OLD_INV_ITEM_REVISION,l_create_audit_rec.INV_ITEM_REVISION),
CHANGE_INV_ITEM_REVISION = decode(decode(l_create_audit_rec.CHANGE_INV_ITEM_REVISION,'Y',l_create_audit_rec.OLD_INV_ITEM_REVISION,l_create_audit_rec.INV_ITEM_REVISION),NULL,'N','Y'),
INV_COMPONENT_ID = decode(l_create_audit_rec.CHANGE_INV_COMPONENT_ID,'Y',l_create_audit_rec.OLD_INV_COMPONENT_ID,l_create_audit_rec.INV_COMPONENT_ID),
CHANGE_INV_COMPONENT_ID = decode(decode(l_create_audit_rec.CHANGE_INV_COMPONENT_ID,'Y',l_create_audit_rec.OLD_INV_COMPONENT_ID,l_create_audit_rec.INV_COMPONENT_ID),NULL,'N','Y'),
INV_COMPONENT_VERSION = decode(l_create_audit_rec.CHANGE_INV_COMPONENT_VERSION,'Y',l_create_audit_rec.OLD_INV_COMPONENT_VERSION,l_create_audit_rec.INV_COMPONENT_VERSION),
CHANGE_INV_COMPONENT_VERSION = decode(decode(l_create_audit_rec.CHANGE_INV_COMPONENT_VERSION,'Y',l_create_audit_rec.OLD_INV_COMPONENT_VERSION,l_create_audit_rec.INV_COMPONENT_VERSION),NULL,'N','Y'),
INV_SUBCOMPONENT_ID = decode(l_create_audit_rec.CHANGE_INV_SUBCOMPONENT_ID,'Y',l_create_audit_rec.OLD_INV_SUBCOMPONENT_ID,l_create_audit_rec.INV_SUBCOMPONENT_ID),
CHANGE_INV_SUBCOMPONENT_ID = decode(decode(l_create_audit_rec.CHANGE_INV_SUBCOMPONENT_ID,'Y',l_create_audit_rec.OLD_INV_SUBCOMPONENT_ID,l_create_audit_rec.INV_SUBCOMPONENT_ID),NULL,'N','Y'),
INV_SUBCOMPONENT_VERSION = decode(l_create_audit_rec.CHANGE_INV_SUBCOMP_VERSION,'Y',l_create_audit_rec.OLD_INV_SUBCOMPONENT_VERSION,l_create_audit_rec.INV_SUBCOMPONENT_VERSION),
CHANGE_INV_SUBCOMP_VERSION = decode(decode(l_create_audit_rec.CHANGE_INV_SUBCOMP_VERSION,'Y',l_create_audit_rec.OLD_INV_SUBCOMPONENT_VERSION,l_create_audit_rec.INV_SUBCOMPONENT_VERSION),NULL,'N','Y'),
RESOURCE_TYPE = decode(l_create_audit_rec.CHANGE_RESOURCE_TYPE_FLAG,'Y',l_create_audit_rec.OLD_RESOURCE_TYPE,l_create_audit_rec.RESOURCE_TYPE),
CHANGE_RESOURCE_TYPE_FLAG = decode(decode(l_create_audit_rec.CHANGE_RESOURCE_TYPE_FLAG,'Y',l_create_audit_rec.OLD_RESOURCE_TYPE,l_create_audit_rec.RESOURCE_TYPE),NULL,'N','Y'),
GROUP_TYPE = decode(l_create_audit_rec.CHANGE_GROUP_TYPE_FLAG,'Y',l_create_audit_rec.OLD_GROUP_TYPE,l_create_audit_rec.GROUP_TYPE),
CHANGE_GROUP_TYPE_FLAG = decode(decode(l_create_audit_rec.CHANGE_GROUP_TYPE_FLAG,'Y',l_create_audit_rec.OLD_GROUP_TYPE,l_create_audit_rec.GROUP_TYPE),NULL,'N','Y'),
OWNER_ASSIGNED_TIME= decode(l_create_audit_rec.change_assigned_time_flag,'Y',l_create_audit_rec.creation_date,l_create_audit_rec.owner_assigned_time),
CHANGE_ASSIGNED_TIME_FLAG = decode(decode(l_create_audit_rec.change_assigned_time_flag,'Y',l_create_audit_rec.creation_date,l_create_audit_rec.owner_assigned_time),NULL,'N','Y'),
INVENTORY_ITEM_ID = decode(l_create_audit_rec.CHANGE_INVENTORY_ITEM_FLAG,'Y',l_create_audit_rec.OLD_INVENTORY_ITEM_ID,l_create_audit_rec.INVENTORY_ITEM_ID) ,
CHANGE_INVENTORY_ITEM_FLAG = decode(decode(l_create_audit_rec.CHANGE_INVENTORY_ITEM_FLAG,'Y',l_create_audit_rec.OLD_INVENTORY_ITEM_ID,l_create_audit_rec.INVENTORY_ITEM_ID),NULL,'N','Y'),
INV_ORGANIZATION_ID = decode(l_create_audit_rec.CHANGE_INV_ORGANIZATION_FLAG,'Y',l_create_audit_rec.OLD_INV_ORGANIZATION_ID,l_create_audit_rec.INV_ORGANIZATION_ID),
CHANGE_INV_ORGANIZATION_FLAG = decode(decode(l_create_audit_rec.CHANGE_INV_ORGANIZATION_FLAG,'Y',l_create_audit_rec.OLD_INV_ORGANIZATION_ID,l_create_audit_rec.INV_ORGANIZATION_ID),NULL,'N','Y'),
STATUS_FLAG = decode(l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,'Y',l_create_audit_rec.OLD_STATUS_FLAG,l_create_audit_rec.STATUS_FLAG),
CHANGE_STATUS_FLAG = decode(decode(l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,'Y',l_create_audit_rec.OLD_STATUS_FLAG,l_create_audit_rec.STATUS_FLAG),NULL,'N','Y'),
UPGRADE_FLAG_FOR_CREATE = 'X',
updated_entity_code = 'SR_HEADER'
WHERE incident_id = l_create_audit_rec.incident_id
AND upgrade_flag_for_create = 'Y';
UPDATE cs_incidents_audit_b
SET LAST_UPDATE_DATE = sysdate,
INCIDENT_STATUS_ID = l_create_audit_rec.INCIDENT_STATUS_ID,
OLD_INCIDENT_STATUS_ID = l_create_audit_rec.OLD_INCIDENT_STATUS_ID,
CHANGE_INCIDENT_STATUS_FLAG = l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,
INCIDENT_TYPE_ID = l_create_audit_rec.INCIDENT_TYPE_ID ,
OLD_INCIDENT_TYPE_ID = l_create_audit_rec.OLD_INCIDENT_TYPE_ID ,
CHANGE_INCIDENT_TYPE_FLAG = l_create_audit_rec.CHANGE_INCIDENT_TYPE_FLAG,
INCIDENT_URGENCY_ID = l_create_audit_rec.INCIDENT_URGENCY_ID ,
OLD_INCIDENT_URGENCY_ID = l_create_audit_rec.OLD_INCIDENT_URGENCY_ID,
CHANGE_INCIDENT_URGENCY_FLAG = l_create_audit_rec.CHANGE_INCIDENT_URGENCY_FLAG,
INCIDENT_SEVERITY_ID = l_create_audit_rec.INCIDENT_SEVERITY_ID ,
OLD_INCIDENT_SEVERITY_ID = l_create_audit_rec.OLD_INCIDENT_SEVERITY_ID ,
CHANGE_INCIDENT_SEVERITY_FLAG = l_create_audit_rec.CHANGE_INCIDENT_SEVERITY_FLAG,
RESPONSIBLE_GROUP_ID = l_create_audit_rec.RESPONSIBLE_GROUP_ID ,
OLD_RESPONSIBLE_GROUP_ID = l_create_audit_rec.OLD_RESPONSIBLE_GROUP_ID ,
CHANGE_RESPONSIBLE_GROUP_FLAG = l_create_audit_rec.CHANGE_RESPONSIBLE_GROUP_FLAG,
INCIDENT_OWNER_ID = l_create_audit_rec.INCIDENT_OWNER_ID ,
OLD_INCIDENT_OWNER_ID = l_create_audit_rec.OLD_INCIDENT_OWNER_ID ,
CHANGE_INCIDENT_OWNER_FLAG = l_create_audit_rec.CHANGE_INCIDENT_OWNER_FLAG,
EXPECTED_RESOLUTION_DATE= l_create_audit_rec.EXPECTED_RESOLUTION_DATE,
OLD_EXPECTED_RESOLUTION_DATE = l_create_audit_rec.OLD_EXPECTED_RESOLUTION_DATE ,
CHANGE_RESOLUTION_FLAG = l_create_audit_rec.CHANGE_RESOLUTION_FLAG,
GROUP_ID = l_create_audit_rec.GROUP_ID ,
OLD_GROUP_ID = l_create_audit_rec.OLD_GROUP_ID ,
change_group_flag = l_create_audit_rec.change_group_flag,
OBLIGATION_DATE = l_create_audit_rec.OBLIGATION_DATE ,
OLD_OBLIGATION_DATE= l_create_audit_rec.OLD_OBLIGATION_DATE ,
CHANGE_OBLIGATION_FLAG = l_create_audit_rec.CHANGE_OBLIGATION_FLAG,
SITE_ID = l_create_audit_rec.SITE_ID ,
OLD_SITE_ID = l_create_audit_rec.OLD_SITE_ID ,
CHANGE_SITE_FLAG = l_create_audit_rec.CHANGE_SITE_FLAG,
BILL_TO_CONTACT_ID = l_create_audit_rec.BILL_TO_CONTACT_ID ,
OLD_BILL_TO_CONTACT_ID = l_create_audit_rec.OLD_BILL_TO_CONTACT_ID ,
CHANGE_BILL_TO_FLAG = l_create_audit_rec.CHANGE_BILL_TO_FLAG,
SHIP_TO_CONTACT_ID = l_create_audit_rec.SHIP_TO_CONTACT_ID ,
OLD_SHIP_TO_CONTACT_ID= l_create_audit_rec.OLD_SHIP_TO_CONTACT_ID ,
CHANGE_SHIP_TO_FLAG = l_create_audit_rec.CHANGE_SHIP_TO_FLAG,
INCIDENT_DATE = l_create_audit_rec.INCIDENT_DATE ,
OLD_INCIDENT_DATE = l_create_audit_rec.OLD_INCIDENT_DATE ,
CHANGE_INCIDENT_DATE_FLAG = l_create_audit_rec.CHANGE_INCIDENT_DATE_FLAG,
CLOSE_DATE = l_create_audit_rec.CLOSE_DATE ,
OLD_CLOSE_DATE = l_create_audit_rec.OLD_CLOSE_DATE ,
CHANGE_CLOSE_DATE_FLAG = l_create_audit_rec.CHANGE_CLOSE_DATE_FLAG,
CUSTOMER_PRODUCT_ID = l_create_audit_rec.CUSTOMER_PRODUCT_ID ,
OLD_CUSTOMER_PRODUCT_ID= l_create_audit_rec.OLD_CUSTOMER_PRODUCT_ID ,
CHANGE_CUSTOMER_PRODUCT_FLAG = l_create_audit_rec.CHANGE_CUSTOMER_PRODUCT_FLAG,
PLATFORM_ID = l_create_audit_rec.PLATFORM_ID ,
OLD_PLATFORM_ID = l_create_audit_rec.OLD_PLATFORM_ID ,
CHANGE_PLATFORM_ID_FLAG = l_create_audit_rec.CHANGE_PLATFORM_ID_FLAG,
PLATFORM_VERSION_ID = l_create_audit_rec.PLATFORM_VERSION_ID ,
OLD_PLATFORM_VERSION_ID = l_create_audit_rec.OLD_PLATFORM_VERSION_ID ,
CHANGE_PLAT_VER_ID_FLAG = l_create_audit_rec.CHANGE_PLAT_VER_ID_FLAG,
CP_COMPONENT_ID = l_create_audit_rec.CP_COMPONENT_ID ,
OLD_CP_COMPONENT_ID = l_create_audit_rec.OLD_CP_COMPONENT_ID ,
CHANGE_CP_COMPONENT_ID_FLAG = l_create_audit_rec.CHANGE_CP_COMPONENT_ID_FLAG,
CP_COMPONENT_VERSION_ID = l_create_audit_rec.CP_COMPONENT_VERSION_ID ,
OLD_CP_COMPONENT_VERSION_ID= l_create_audit_rec.OLD_CP_COMPONENT_VERSION_ID,
CHANGE_CP_COMP_VER_ID_FLAG = l_create_audit_rec.CHANGE_CP_COMP_VER_ID_FLAG,
CP_SUBCOMPONENT_ID = l_create_audit_rec.CP_SUBCOMPONENT_ID,
OLD_CP_SUBCOMPONENT_ID = l_create_audit_rec.OLD_CP_SUBCOMPONENT_ID ,
CHANGE_CP_SUBCOMPONENT_ID_FLAG = l_create_audit_rec.CHANGE_CP_SUBCOMPONENT_ID_FLAG,
CP_SUBCOMPONENT_VERSION_ID = l_create_audit_rec.CP_SUBCOMPONENT_VERSION_ID ,
OLD_CP_SUBCOMPONENT_VERSION_ID= l_create_audit_rec.OLD_CP_SUBCOMPONENT_VERSION_ID ,
CHANGE_CP_SUBCOMP_VER_ID_FLAG = l_create_audit_rec.CHANGE_CP_SUBCOMP_VER_ID_FLAG,
LANGUAGE_ID = l_create_audit_rec.LANGUAGE_ID ,
OLD_LANGUAGE_ID = l_create_audit_rec.OLD_LANGUAGE_ID ,
CHANGE_LANGUAGE_ID_FLAG = l_create_audit_rec.CHANGE_LANGUAGE_ID_FLAG,
TERRITORY_ID = l_create_audit_rec.TERRITORY_ID ,
OLD_TERRITORY_ID = l_create_audit_rec.OLD_TERRITORY_ID ,
CHANGE_TERRITORY_ID_FLAG = l_create_audit_rec.CHANGE_TERRITORY_ID_FLAG,
CP_REVISION_ID = l_create_audit_rec.CP_REVISION_ID ,
OLD_CP_REVISION_ID = l_create_audit_rec.OLD_CP_REVISION_ID ,
CHANGE_CP_REVISION_ID_FLAG = l_create_audit_rec.CHANGE_CP_REVISION_ID_FLAG,
INV_ITEM_REVISION = l_create_audit_rec.INV_ITEM_REVISION ,
OLD_INV_ITEM_REVISION = l_create_audit_rec.OLD_INV_ITEM_REVISION ,
CHANGE_INV_ITEM_REVISION = l_create_audit_rec.CHANGE_INV_ITEM_REVISION,
INV_COMPONENT_ID = l_create_audit_rec.INV_COMPONENT_ID ,
OLD_INV_COMPONENT_ID = l_create_audit_rec.OLD_INV_COMPONENT_ID ,
CHANGE_INV_COMPONENT_ID = l_create_audit_rec.CHANGE_INV_COMPONENT_ID,
INV_COMPONENT_VERSION = l_create_audit_rec.INV_COMPONENT_VERSION ,
OLD_INV_COMPONENT_VERSION = l_create_audit_rec.OLD_INV_COMPONENT_VERSION ,
CHANGE_INV_COMPONENT_VERSION = l_create_audit_rec.CHANGE_INV_COMPONENT_VERSION,
INV_SUBCOMPONENT_ID = l_create_audit_rec.INV_SUBCOMPONENT_ID ,
OLD_INV_SUBCOMPONENT_ID = l_create_audit_rec.OLD_INV_SUBCOMPONENT_ID ,
CHANGE_INV_SUBCOMPONENT_ID = l_create_audit_rec.CHANGE_INV_SUBCOMPONENT_ID,
INV_SUBCOMPONENT_VERSION = l_create_audit_rec.INV_SUBCOMPONENT_VERSION ,
OLD_INV_SUBCOMPONENT_VERSION = l_create_audit_rec.OLD_INV_SUBCOMPONENT_VERSION ,
CHANGE_INV_SUBCOMP_VERSION = l_create_audit_rec.CHANGE_INV_SUBCOMP_VERSION,
RESOURCE_TYPE = l_create_audit_rec.RESOURCE_TYPE ,
OLD_RESOURCE_TYPE = l_create_audit_rec.OLD_RESOURCE_TYPE ,
change_resource_type_flag = l_create_audit_rec.change_resource_type_flag,
OLD_GROUP_TYPE = l_create_audit_rec.OLD_GROUP_TYPE ,
GROUP_TYPE = l_create_audit_rec.GROUP_TYPE ,
change_group_type_flag = l_create_audit_rec.change_group_type_flag,
OLD_OWNER_ASSIGNED_TIME = l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME ,
OWNER_ASSIGNED_TIME= l_create_audit_rec.OWNER_ASSIGNED_TIME ,
CHANGE_ASSIGNED_TIME_FLAG = l_create_audit_rec.CHANGE_ASSIGNED_TIME_FLAG,
INV_PLATFORM_ORG_ID = l_create_audit_rec.INV_PLATFORM_ORG_ID ,
OLD_INV_PLATFORM_ORG_ID = l_create_audit_rec.OLD_INV_PLATFORM_ORG_ID ,
CHANGE_PLATFORM_ORG_ID_FLAG = l_create_audit_rec.CHANGE_PLATFORM_ORG_ID_FLAG,
COMPONENT_VERSION = l_create_audit_rec.COMPONENT_VERSION ,
OLD_COMPONENT_VERSION = l_create_audit_rec.OLD_COMPONENT_VERSION ,
CHANGE_COMP_VER_FLAG = l_create_audit_rec.CHANGE_COMP_VER_FLAG,
SUBCOMPONENT_VERSION = l_create_audit_rec.SUBCOMPONENT_VERSION ,
OLD_SUBCOMPONENT_VERSION = l_create_audit_rec.OLD_SUBCOMPONENT_VERSION ,
CHANGE_SUBCOMP_VER_FLAG = l_create_audit_rec.CHANGE_SUBCOMP_VER_FLAG,
PRODUCT_REVISION = l_create_audit_rec.PRODUCT_REVISION ,
OLD_PRODUCT_REVISION = l_create_audit_rec.OLD_PRODUCT_REVISION ,
CHANGE_PRODUCT_REVISION_FLAG = l_create_audit_rec.CHANGE_PRODUCT_REVISION_FLAG,
INVENTORY_ITEM_ID = l_create_audit_rec.INVENTORY_ITEM_ID ,
OLD_INVENTORY_ITEM_ID = l_create_audit_rec.OLD_INVENTORY_ITEM_ID ,
CHANGE_INVENTORY_ITEM_FLAG = decode(l_create_audit_rec.CHANGE_INVENTORY_ITEM_FLAG,NULL,'N',l_create_audit_rec.CHANGE_INVENTORY_ITEM_FLAG),
INV_ORGANIZATION_ID = l_create_audit_rec.INV_ORGANIZATION_ID ,
OLD_INV_ORGANIZATION_ID = l_create_audit_rec.OLD_INV_ORGANIZATION_ID ,
--CHANGE_INV_ORGANIZATION_FLAG = decode(l_create_audit_rec.CHANGE_INV_ORGANIZATION_FLAG,NULL,'N',l_create_audit_rec.CHANGE_INV_ORGANIZATION_FLAG),
CHANGE_INV_ORGANIZATION_FLAG = l_create_audit_rec.CHANGE_INV_ORGANIZATION_FLAG,
STATUS_FLAG = l_create_audit_rec.STATUS_FLAG ,
OLD_STATUS_FLAG = l_create_audit_rec.OLD_STATUS_FLAG,
CHANGE_STATUS_FLAG = l_create_audit_rec.CHANGE_STATUS_FLAG,
PRIMARY_CONTACT_ID = l_create_audit_rec.PRIMARY_CONTACT_ID ,
OLD_PRIMARY_CONTACT_ID= l_create_audit_rec.OLD_PRIMARY_CONTACT_ID,
CHANGE_PRIMARY_CONTACT_FLAG = l_create_audit_rec.CHANGE_PRIMARY_CONTACT_FLAG,
UPGRADE_FLAG_FOR_CREATE = decode(l_create_record, 'Y', 'X', 'U'),
updated_entity_code = 'SR_HEADER'
WHERE incident_audit_id = l_audit_rec.incident_audit_id;
ad_parallel_updates_pkg.processed_rowid_range(
l_loop_counter,
l_end_rowid);
ad_parallel_updates_pkg.get_rowid_range(
l_start_rowid,
l_end_rowid,
l_any_rows_to_process,
x_batch_size,
FALSE);