The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
sr.customer_id,
--sr.customer_name,
sr.customer_number,
sr.inventory_item_id,
mtl.concatenated_segments product,
mtl.description product_description,
CS_STD.Get_Item_Valdn_Orgzn_Id organization_id,
sr.reference_number,
sr.current_serial_number,
cp.installation_date,
sr.incident_id,
sr.incident_number,
sr.incident_date,
act.task_number,
sr.problem_code_meaning problem_code,
sr.resolution_code_meaning resolution_code,
--act.text_description problem_description,
-- act.text_resolution resolution_description,
sr.problem_code_description sr_problem_description,
sr.resolution_code_description sr_resolution_description,
sr.incident_urgency_id,
sr.urgency,
-- decode( st.status_code ,
--CS_WF_Activities_PKG.FS_Planned_Status , 1 ,
--CS_WF_Activities_PKG.FS_Cancelled_Status , 2 )
sr.incident_status_id,
--decode( st.status_code ,
--CS_WF_Activities_PKG.FS_Planned_Status , 'Planned' ,
--CS_WF_Activities_PKG.FS_Cancelled_Status , 'Cancelled' )
st.status_code,
sr.incident_date status_date,
act.task_type_id incident_type_id,
-- act.action_type_meaning incident_type,
it.business_process_id,
-- act.action_assignee_id dispatcher_id,
-- act.action_assignee dispatcher_name,
'N' covered_by_contract,
-- decode(sr.current_contact_person_id, null, sr.represented_by_name,
-- sr.current_contact_name) current_contact_name,
-- decode(sr.current_contact_person_id,null, sr.represented_by_telephone,
-- sr.current_contact_telephone) current_contact_telephone,
-- decode(sr.current_contact_person_id, null, sr.represented_by_area_code,
-- sr.current_contact_area_code) current_contact_area_code,
-- decode(sr.current_contact_person_id, null, sr.represented_by_extension,
-- sr.current_contact_extension) current_contact_extension,
-- decode(sr.current_contact_person_id, null, sr.represented_by_fax_number,
-- sr.current_contact_fax_number) current_contact_fax_number,
-- decode(sr.current_contact_person_id, null, sr.represented_by_fax_area_code,
-- sr.current_contact_fax_area_code) current_contact_fax_area_code,
-- decode(sr.current_contact_person_id, null, sr.represented_by_email_address,
-- sr.current_contact_email_address) current_contact_email_address,
hl.address1 || hl.address2 ship_to_address_line1,
hl.address3 ship_to_address_line2,
substr(hl.address3,instr(hl.address3, ',')+5 , 5 ) postal_code,
substr(hl.address3,1,instr(hl.address3, ',') -1 ) city,
substr(hl.address3,instr(hl.address3, ',')+2 , 2 ) state,
substr(hl.address3,instr(hl.address3, ',', -1, 1)+2 ) country,
act.actual_start_date start_time,
act.scheduled_end_date end_time,
act.actual_end_date end_time,
act.actual_start_date earliest_start_time,
act.scheduled_end_date latest_finish_time,
'N' appointment,
null request_duration,
-- act.dispatcher_orig_syst_id employee_id,
-- act.dispatch_role_name employee_name,
sr.incident_severity_id,
sr.severity incident_severity_name,
jn.notes inc_prob_description,
act.task_status_id action_status_id
-- act.text problem_summary
FROM CS_INCIDENTS_V sr,
jtf_tasks_v act,
-- CS_INCIDENT_ACTIONS_V act,
mtl_system_items_kfv mtl,
cs_customer_products cp,
cs_incident_types it,
cs_incident_statuses st,
hz_party_sites hps,
hz_locations hl,
jtf_notes_vl jn
WHERE it.incident_type_id = sr.incident_type_id
AND mtl.inventory_item_id(+) = sr.inventory_item_id
AND mtl.organization_id = CS_STD.Get_Item_Valdn_Orgzn_ID
AND cp.customer_product_id(+) = sr.customer_product_id
AND sr.incident_id = p_incident_id
AND act.source_object_id = p_incident_id
AND act.task_id = p_incident_action_id
-- AND act.dispatcher_orig_syst = 'PER'
AND act.task_status_id = st.incident_status_id
AND sr.customer_id = hps.party_id
AND hps.party_site_id = hl.location_id
AND sr.incident_id = jn.source_object_id
AND jn.source_object_code = 'SR'
AND upper(jn.note_type) = 'SR_PROBLEM';
PROCEDURE Servereq_Selector
( itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
result OUT NOCOPY VARCHAR2
)
IS
l_user_id NUMBER;
WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Servereq_Selector',
itemtype, itemkey, actid, funcmode);
END Servereq_Selector;
SELECT *
FROM CS_INCIDENTS_WORKFLOW_V
WHERE INCIDENT_NUMBER = l_request_number;
SELECT INC.INCIDENT_ID,
INC.INCIDENT_NUMBER,
INC.INCIDENT_DATE,
TYPE.NAME INCIDENT_TYPE
FROM cs_incidents_all_b INC,
CS_INCIDENT_TYPES_TL TYPE
WHERE INC.INCIDENT_NUMBER = l_request_number
AND INC.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID(+)
AND TYPE.LANGUAGE(+) = userenv('LANG');
PROCEDURE Update_Request_Info ( itemtype VARCHAR2,
itemkey VARCHAR2,
actid NUMBER,
funmode VARCHAR2,
result OUT NOCOPY VARCHAR2 ) IS
l_return_status VARCHAR2(1);
SELECT *
FROM cs_incidents_workflow_v
WHERE incident_id = l_request_id;
SELECT INC.INCIDENT_ID,
INC.SUMMARY,
INC.INCIDENT_OWNER_ID,
INC.INVENTORY_ITEM_ID,
INC.EXPECTED_RESOLUTION_DATE,
INC.INCIDENT_DATE,
INC.CUSTOMER_PRODUCT_ID,
SEVERITY.NAME SEVERITY,
STATUS.NAME STATUS_CODE,
URGENCY.NAME URGENCY,
RA2.PARTY_NAME CUSTOMER_NAME,
CSLKUP.DESCRIPTION PROBLEM_CODE_DESCRIPTION,
MTL.DESCRIPTION PRODUCT_DESCRIPTION
FROM CS_INCIDENTS_ALL_VL INC,
--CS_INCIDENT_SEVERITIES_VL SEVERITY,
CS_INCIDENT_SEVERITIES_TL SEVERITY,
CS_INCIDENT_STATUSES_VL STATUS,
--CS_INCIDENT_URGENCIES_VL URGENCY,
CS_INCIDENT_URGENCIES_TL URGENCY,
HZ_PARTIES RA2,
CS_LOOKUPS CSLKUP,
--MTL_SYSTEM_ITEMS_VL MTL
MTL_SYSTEM_ITEMS_TL MTL
WHERE INC.INCIDENT_ID = l_request_id
AND INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
AND INC.INCIDENT_URGENCY_ID = URGENCY.INCIDENT_URGENCY_ID(+)
AND URGENCY.LANGUAGE(+) = userenv('LANG')
AND INC.CUSTOMER_ID = RA2.PARTY_ID(+)
AND INC.INCIDENT_SEVERITY_ID = SEVERITY.INCIDENT_SEVERITY_ID(+)
AND SEVERITY.LANGUAGE(+) = userenv('LANG')
AND INC.PROBLEM_CODE = CSLKUP.LOOKUP_CODE(+)
AND CSLKUP.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
AND MTL.INVENTORY_ITEM_ID(+) = INC.INVENTORY_ITEM_ID
AND MTL.LANGUAGE(+) = userenv('LANG')
AND (MTL.ORGANIZATION_ID = CS_STD.Get_Item_Valdn_Orgzn_ID OR MTL.ORGANIZATION_ID IS NULL);
SELECT emp.source_id
FROM jtf_rs_resource_extns emp
WHERE emp.resource_id = l_incident_owner_id;
WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Update_Request_Info',
itemtype, itemkey, actid, funmode);
END Update_Request_Info;
PROCEDURE Select_Supervisor( itemtype VARCHAR2,
itemkey VARCHAR2,
actid NUMBER,
funmode VARCHAR2,
result OUT NOCOPY VARCHAR2 ) IS
l_return_status VARCHAR2(1);
select wf.recipient_role, wf.status
from wf_notifications wf,
wf_item_activity_statuses_h wi
--Bug 2412660 modified for performance issues. related to bug 2365267.rmanabat 06/11/02
--wf_item_activity_statuses_v wi
where
wf.message_name in ('ESCALATION_WITH_EXP_MSG',
'ESCALATION_MSG',
'ASSIGNMENT_WITH_EXP_MSG',
'ASSIGNMENT_MSG')
AND wf.original_recipient = l_owner_role
AND wi.notification_id = wf.notification_id
AND wi.item_type = itemtype
AND wi.item_key = itemkey
AND wi.activity_status='COMPLETE'
--AND wi.activity_status_code='COMPLETE'
order by wf.begin_date desc;
select wr.orig_system_id
from WF_ROLES wr
where wr.orig_system = 'PER'
AND wr.name = l_recipient_role;
WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Select_Supervisor',
itemtype, itemkey, actid, funmode);
END Select_Supervisor;
PROCEDURE Update_Owner( itemtype VARCHAR2,
itemkey VARCHAR2,
actid NUMBER,
funmode VARCHAR2,
result OUT NOCOPY VARCHAR2 ) IS
l_owner_id NUMBER;
select resource_id from jtf_rs_resource_extns
where source_id = l_new_owner_id
and category = 'EMPLOYEE'
and sysdate between start_date_active and nvl(end_date_active,sysdate + 1);
SELECT login_id INTO l_login_id
FROM fnd_logins
WHERE login_id = FND_GLOBAL.LOGIN_ID
AND user_id = l_user_id;
SELECT org_id, object_version_number, incident_id
INTO l_org_id, l_object_version_number, l_request_id
FROM CS_INCIDENTS_ALL_B
WHERE incident_number = l_request_number;
CS_ServiceRequest_PUB.Update_Owner (
p_api_version => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_user_id => l_user_id,
p_login_id => l_login_id,
-- Don't need Org id for updates , SR API modified so comment out here
--p_org_id => l_org_id,
p_request_number => l_request_number,
p_object_version_number => l_object_version_number,
-- Fix for bug 3065468. rmanabat 07/24/03
--p_owner_id => l_new_owner_id,
p_resp_id => l_resp_id,
p_resp_appl_id => l_resp_appl_id,
p_owner_id => l_resource_id,
p_owner_group_id => l_owner_group_id,
p_resource_type => l_resource_type,
p_audit_comments => CS_WF_ACTIVITIES_PKG.Audit_Comments,
p_called_by_workflow => FND_API.G_TRUE,
p_workflow_process_id => l_wf_process_id,
x_interaction_id => l_dummy_id );
proc_name => 'Update_Owner',
arg1 => 'p_user_id=>'||l_user_id,
arg2 => 'p_login_id=>'||l_login_id,
arg3 => 'p_org_id=>'||l_org_id,
arg4 => 'p_owner_id=>'||l_resource_id,
arg5 => 'p_msg_data=>'||l_msg_data );
l_errmsg_name := 'CS_SR_CANT_UPDATE_OWNER';
WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Update_Owner',
itemtype, itemkey, actid, funmode);
END Update_Owner;
PROCEDURE Update_Status( itemtype VARCHAR2,
itemkey VARCHAR2,
actid NUMBER,
funmode VARCHAR2,
result OUT NOCOPY VARCHAR2 ) IS
l_owner_id NUMBER;
l_api_name CONSTANT VARCHAR2(60) := 'CS_WF_ACTIVITIES_PKG.Update_status';
/* Commenting out this call, l_user_id used for update_service_request
(last_updated_by) should always be the FND_USER .
CS_WORKFLOW_PUB.Get_Emp_Fnd_User_ID(
p_api_version => 1.0,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_employee_id => l_owner_id,
p_fnd_user_id => l_user_id );
select object_version_number,incident_id
INTO l_object_version_number,l_request_id
from cs_incidents_all_b
where incident_number = l_request_number;
SELECT login_id INTO l_login_id
FROM fnd_logins
WHERE login_id = FND_GLOBAL.LOGIN_ID
AND user_id = l_user_id;
SELECT org_id INTO l_org_id
FROM CS_INCIDENTS_ALL_B
WHERE incident_number = l_request_number;
CS_ServiceRequest_PUB.Update_Status (
p_api_version => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_user_id => l_user_id,
p_login_id => l_login_id,
-- Don't need Org id for updates , SR API modified so comment out here
-- p_org_id => l_org_id,
p_request_number => l_request_number,
p_object_version_number => l_object_version_number,
p_status_id => l_new_status_id,
p_closed_date => sysdate,
p_audit_comments => CS_WF_ACTIVITIES_PKG.Audit_Comments,
p_called_by_workflow => FND_API.G_TRUE,
p_workflow_process_id => l_wf_process_id,
x_interaction_id => l_dummy_id );
proc_name => 'Update_Status',
arg1 => 'p_user_id=>'||l_user_id,
arg2 => 'p_org_id=>'||l_org_id,
arg3 => 'p_request_number=>'||l_request_number,
arg4 => 'p_status_id=>'||l_new_status_id,
arg5 => 'p_msg_data=>'||l_msg_data );
l_errmsg_name := 'CS_SR_CANT_UPDATE_STATUS';
l_service_request_rec.last_update_program_code := 'SUPPORT.WF';
CS_ServiceRequest_PVT.Update_ServiceRequest
( p_api_version => 3.0, -- Changed from 2.0 for 11.5.9.
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_true,
p_validation_level => fnd_api.g_valid_level_full,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_request_id => l_request_id,
p_last_updated_by => l_user_id,
p_last_update_date => sysdate,
p_service_request_rec => l_service_request_rec,
p_notes => l_notes,
p_contacts => l_contacts,
p_object_version_number => l_object_version_number,
p_resp_appl_id => l_resp_appl_id,
p_resp_id => l_resp_id,
x_interaction_id => out_interaction_id,
x_workflow_process_id => out_wf_process_id
);
proc_name => 'Update_Status',
arg1 => 'p_user_id=>'||l_user_id,
arg2 => 'p_org_id=>'||l_org_id,
arg3 => 'p_request_number=>'||l_request_number,
arg4 => 'p_status_id=>'||l_new_status_id,
arg5 => 'p_msg_data=>'||l_msg_data );
l_errmsg_name := 'CS_SR_CANT_UPDATE_STATUS';
to see if Update_SR API is successful
IF (FND_MSG_PUB.Count_Msg > 1) THEN
--Display all the error messages
FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
FND_MSG_PUB.Get(p_msg_index=>j,
p_encoded=>'F',
p_data=>l_msg_data,
p_msg_index_out=>l_msg_index_out);
proc_name => 'Update_ServiceRequest',
arg1 => 'p_user_id=>'||l_user_id,
arg2 => 'p_org_id=>'||l_org_id,
arg3 => 'p_request_number=>'||l_request_number,
arg4 => 'p_status_id=>'||l_new_status_id,
arg5 => 'p_msg_data=>'||l_msg_data );
l_errmsg_name := 'CS_SR_CANT_UPDATE_STATUS';
SELECT name
INTO l_new_status
FROM cs_incident_statuses
WHERE incident_status_id = 2;
WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Update_Status',
itemtype, itemkey, actid, funmode);
END Update_Status;
PROCEDURE Action_Selector
( itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
result OUT NOCOPY VARCHAR2
)
IS
l_user_id NUMBER;
WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Action_Selector',
itemtype, itemkey, actid, funcmode);
END Action_Selector;
SELECT *
FROM cs_inc_actions_workflow_v
WHERE incident_id = l_request_id
AND action_number = l_action_number;
SELECT dispatcher_orig_syst, dispatcher_orig_syst_id, dispatch_role_name
FROM cs_inc_actions_workflow_v
WHERE incident_id = l_request_id
AND action_number = l_action_number;
SELECT display_name
FROM wf_roles
WHERE name = l_role_name;
SELECT NVL(UPPER(USE_MOBILE_FLD_SRV_FLAG) , 'N')
INTO l_mobile_installed
FROM CS_SYSTEM_PARAMETERS;
SELECT b.close_flag
FROM CS_INCIDENT_ACTIONS a, CS_INCIDENT_STATUSES b
WHERE a.incident_id = l_request_id AND
a.action_num = l_action_number AND
a.action_status_id = b.incident_status_id;
PROCEDURE IS_FS_INSERT (
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
result OUT NOCOPY VARCHAR2
) IS
l_fs_mode VARCHAR2(10) := NULL;
--- This attribute identifies whether to do insert or update
--- on the interface table
l_fs_mode := WF_ENGINE.GetItemAttrText (
itemtype => itemtype,
itemkey => itemkey,
aname => 'FS_INTERFACE_MODE');
WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'IS_FS_INSERT',
itemtype, itemkey, actid, funcmode);
END IS_FS_INSERT;
/*PROCEDURE INSERT_FS_INTERFACE (
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
result OUT VARCHAR2) IS
action_rec fs_action_csr%ROWTYPE;
proc_name => 'INSERT_FS_INTERFACE',
arg1 => 'p_itemkey=>'||itemkey );
SELECT CS_MFS_INTERFACE_S.nextval
INTO l_fs_interface_id FROM DUAL;
INSERT INTO CS_MFS_INTERFACE
(
FIELD_SERVICE_INTERFACE_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
STATUS_FLAG,
ORG_ID,
INCIDENT_NUMBER,
ACTION_NUM,
INCIDENT_DATE,
BUSINESS_PROCESS_ID,
PROBLEM_CODE,
PROBLEM_DESCRIPTION,
RESOLUTION_CODE,
RESOLUTION_DESCRIPTION,
INCIDENT_URGENCY_ID,
URGENCY,
INCIDENT_STATUS_ID,
STATUS_CODE,
STATUS_DATE,
INCIDENT_TYPE_ID,
INCIDENT_TYPE,
DISPATCHER_ID,
DISPATCHER_NAME,
COVERED_BY_CONTRACT,
CURRENT_CONTACT_NAME,
CURRENT_CONTACT_TELEPHONE,
CURRENT_CONTACT_AREA_CODE,
CURRENT_CONTACT_EXTENSION,
CURRENT_CONTACT_FAX_NUMBER,
CURRENT_CONTACT_FAX_AREA_CODE,
CURRENT_CONTACT_EMAIL_ADDRESS,
SHIP_TO_ADDRESS_LINE1,
SHIP_TO_ADDRESS_LINE2,
POSTAL_CODE,
CITY,
STATE,
COUNTRY,
START_TIME,
END_TIME,
EARLIEST_START_TIME,
LATEST_FINISH_TIME,
APPOINTMENT,
REQUEST_DURATION,
EMPLOYEE_ID,
EMPLOYEE_NAME,
CUSTOMER_ID,
CUSTOMER_NUMBER,
--CUSTOMER_NAME,
INVENTORY_ITEM_ID,
PRODUCT,
PRODUCT_DESCRIPTION,
ORGANIZATION_ID,
REFERENCE_NUMBER,
CURRENT_SERIAL_NUMBER,
INSTALLATION_DATE,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CONTEXT,
SR_PROBLEM_DESCRIPTION,
SR_RESOLUTION_DESCRIPTION,
incident_severity_id,
incident_severity_name,
inc_prob_description,
action_status_id,
problem_summary)
VALUES(
l_fs_interface_id,
sysdate,
FND_GLOBAL.user_id,
sysdate,
FND_GLOBAL.user_id,
FND_GLOBAL.login_id,
'1',
NULL,
action_rec.incident_number,
action_rec.action_num,
action_rec.incident_date,
action_rec.business_process_id,
action_rec.problem_code,
--action_rec.problem_description,
action_rec.resolution_code,
action_rec.resolution_description,
action_rec.incident_urgency_id,
action_rec.urgency,
action_rec.INCIDENT_STATUS_ID,
action_rec.STATUS_CODE,
action_rec.status_date,
action_rec.incident_type_id,
action_rec.incident_type,
action_rec.dispatcher_id,
action_rec.dispatcher_name,
action_rec.covered_by_contract,
action_rec.current_contact_name,
action_rec.current_contact_telephone,
action_rec.current_contact_area_code,
action_rec.current_contact_extension,
action_rec.current_contact_fax_number,
action_rec.current_contact_fax_area_code,
action_rec.current_contact_email_address,
action_rec.ship_to_address_line1,
action_rec.ship_to_address_line2,
action_rec.postal_code,
action_rec.city,
action_rec.state,
action_rec.country,
action_rec.start_time,
action_rec.end_time,
action_rec.earliest_start_time,
action_rec.latest_finish_time,
action_rec.appointment,
action_rec.request_duration,
action_rec.employee_id,
wf_directory.getroledisplayname(action_rec.employee_name),
action_rec.customer_id,
action_rec.customer_number,
--action_rec.customer_name,
action_rec.inventory_item_id,
action_rec.product,
action_rec.product_description,
action_rec.organization_id,
action_rec.reference_number,
action_rec.current_serial_number,
action_rec.installation_date,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
-- action_rec.sr_problem_description,
action_rec.sr_resolution_description,
action_rec.incident_severity_id,
action_rec.incident_severity_name,
action_rec.inc_prob_description,
action_rec.action_status_id,
action_rec.problem_summary);
-- Set the mode to updated to have the workflow update this record
-- when it loops through next time
WF_ENGINE.SetItemAttrText(
itemtype => itemtype,
itemkey => itemkey,
aname => 'FS_INTERFACE_MODE',
avalue => 'CREATED');
WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'INSERT_FS_INTERFACE',
itemtype, itemkey, actid, funcmode);
END INSERT_FS_INTERFACE;*/
/*PROCEDURE UPDATE_FS_INTERFACE (
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
result OUT VARCHAR2) IS
action_rec fs_action_csr%ROWTYPE;
proc_name => 'UPDATE_FS_INTERFACE',
arg1 => 'p_itemkey=>'||itemkey );
UPDATE CS_MFS_INTERFACE
SET
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = FND_GLOBAL.user_id,
LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
STATUS_FLAG = 1,
INCIDENT_NUMBER =action_rec.incident_number,
ACTION_NUM =action_rec.action_num,
INCIDENT_DATE =action_rec.incident_date,
BUSINESS_PROCESS_ID =action_rec.business_process_id,
PROBLEM_CODE =action_rec.problem_code,
--PROBLEM_DESCRIPTION =action_rec.problem_description,
RESOLUTION_CODE =action_rec.resolution_code,
RESOLUTION_DESCRIPTION =action_rec.resolution_description,
INCIDENT_URGENCY_ID =action_rec.incident_urgency_id,
URGENCY =action_rec.urgency,
INCIDENT_STATUS_ID =action_rec.INCIDENT_STATUS_ID,
STATUS_CODE =action_rec.STATUS_CODE,
STATUS_DATE =action_rec.status_date,
INCIDENT_TYPE_ID =action_rec.incident_type_id,
INCIDENT_TYPE =action_rec.incident_type,
DISPATCHER_ID = action_rec.dispatcher_id,
DISPATCHER_NAME = action_rec.dispatcher_name,
COVERED_BY_CONTRACT =action_rec.covered_by_contract,
CURRENT_CONTACT_NAME = action_rec.current_contact_name,
CURRENT_CONTACT_TELEPHONE = action_rec.current_contact_telephone,
CURRENT_CONTACT_AREA_CODE = action_rec.current_contact_area_code,
CURRENT_CONTACT_EXTENSION =action_rec.current_contact_extension,
CURRENT_CONTACT_FAX_NUMBER =action_rec.current_contact_fax_number,
CURRENT_CONTACT_FAX_AREA_CODE =action_rec.current_contact_fax_area_code,
CURRENT_CONTACT_EMAIL_ADDRESS =action_rec.current_contact_email_address,
SHIP_TO_ADDRESS_LINE1 =action_rec.ship_to_address_line1,
SHIP_TO_ADDRESS_LINE2 = action_rec.ship_to_address_line2,
POSTAL_CODE =action_rec.postal_code,
CITY =action_rec.city,
STATE =action_rec.state,
COUNTRY =action_rec.country,
START_TIME =action_rec.start_time,
END_TIME =action_rec.end_time,
EARLIEST_START_TIME =action_rec.earliest_start_time,
LATEST_FINISH_TIME =action_rec.latest_finish_time,
APPOINTMENT =action_rec.appointment,
REQUEST_DURATION =action_rec.request_duration,
EMPLOYEE_ID =action_rec.employee_id,
EMPLOYEE_NAME =wf_directory.getroledisplayname(action_rec.employee_name),
CUSTOMER_ID =action_rec.customer_id,
CUSTOMER_NUMBER =action_rec.customer_number,
--CUSTOMER_NAME =action_rec.customer_name,
INVENTORY_ITEM_ID =action_rec.inventory_item_id,
PRODUCT =action_rec.product,
PRODUCT_DESCRIPTION =action_rec.product_description,
ORGANIZATION_ID = action_rec.organization_id,
REFERENCE_NUMBER =action_rec.reference_number,
CURRENT_SERIAL_NUMBER =action_rec.current_serial_number,
INSTALLATION_DATE =action_rec.installation_date
WHERE FIELD_SERVICE_INTERFACE_ID = l_fs_interface_id;
avalue => 'UPDATED');
WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'UPDATE_FS_INTERFACE',
itemtype, itemkey, actid, funcmode);
END UPDATE_FS_INTERFACE;*/
SELECT inc.incident_id,
act.workflow_process_id,
CS_WORKFLOW_PKG.IS_ACTION_ITEM_ACTIVE(
act.incident_id,
act.action_num,
act.workflow_process_id)
INTO l_incident_id,l_wf_id,l_wf_active
FROM CS_INCIDENT_ACTIONS ACT, CS_INCIDENTS_ALL_B INC
WHERE inc.incident_id = act.incident_id
AND inc.incident_number = p_incident_number
AND act.action_num = p_action_number ;