The following lines contain the word 'select', 'insert', 'update' or 'delete':
* Call WMS_Task_Dispatch_Device. PROCEDURE insert_device
* And make the x_return_status of the Open API "S"
*/
PROCEDURE call_workflow
(
p_device_id IN NUMBER,
p_response_record IN MSG_COMPONENT_LOOKUP_TYPE
);
(p_device_id, 'Device is not signed on. Calling WMS_Task_Dispatch_Device.insert_device.');
WMS_Task_Dispatch_Device.insert_device
(p_Employee_Id => p_employee_id,
p_device_id => p_device_id,
p_org_id => p_organization_id,
x_return_status => x_return_status);
(p_device_id, 'Done inserting into temp table. p_employee_id='
|| p_employee_id
|| ', p_device_id='
|| p_device_id
|| ', p_organization_id='
|| p_organization_id
|| ', x_return_status='
|| x_return_status);
INSERT INTO wms_device_requests
(relation_id,
task_id,
task_summary,
business_event_id,
organization_id,
device_status,
xfer_lpn_id,
last_update_date,
last_updated_by,
last_update_login
)
VALUES (p_param_values_record.relation_id,
p_param_values_record.task_id,
p_param_values_record.task_summary,
p_param_values_record.business_event,
p_param_values_record.organization_id,
p_param_values_record.device_status,
p_param_values_record.transfer_lpn_id,
SYSDATE,
fnd_global.user_id,
fnd_global.login_id );
SELECT 1
INTO l_wf
FROM mtl_transaction_reasons
WHERE reason_id = p_response_record.reason_id
AND workflow_name IS NOT NULL
AND workflow_name <> ' '
AND workflow_process IS NOT NULL
AND workflow_process <> ' ';
INSERT INTO wms_carousel_log
(CAROUSEL_LOG_ID
,text
,device_id
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN
)
VALUES (wms_carousel_log_s.NEXTVAL
,p_data
,p_device_id
,SYSDATE
,fnd_global.user_id
,SYSDATE
,fnd_global.user_id
,fnd_global.login_id
);