The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE UpdateTxnDetails
(itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
resultout OUT NOCOPY VARCHAR2) ;
PROCEDURE UPDATE_TXN_DETAILS
(itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout OUT NOCOPY VARCHAR2) IS
x_progress VARCHAR2(4000);
UpdateTxnDetails
(itemtype => update_txn_details.itemtype,
itemkey => update_txn_details.itemkey,
actid => update_txn_details.actid ,
resultout => l_resultout );
wf_core.context('XDPCORE_OM', 'UPDATE_TXN_DETAILS', itemtype, itemkey, to_char(actid), funcmode);
END UPDATE_TXN_DETAILS;
PROCEDURE UPDATE_OM_LINE_STATUS
(itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout OUT NOCOPY VARCHAR2) IS
x_progress VARCHAR2(4000);
l_org_id := wf_engine.GetItemAttrNumber( itemtype => update_om_line_status.itemtype,
itemkey => update_om_line_status.itemkey,
aname => 'ORG_ID');
OE_ORDER_WF_UTIL.Update_Flow_Status_Code
(p_line_id => l_line_id,
p_flow_status_code => 'PROV_SUCCESS',
x_return_status => l_resultout );
wf_core.context('XDPCORE_OM', 'UPDATE_OM_LINE_STATUS', itemtype, itemkey, to_char(actid), x_progress);
wf_core.context('XDPCORE_OM', 'UPDATE_OM_LINE_STATUS', itemtype, itemkey, to_char(actid), x_progress);
END UPDATE_OM_LINE_STATUS ;
SELECT NVL(l.org_id,h.org_id), h.order_number
INTO l_org_id,l_order_number
FROM oe_order_lines_all l,
oe_order_headers_all h
WHERE l.line_id = to_number(l_line_id)
AND l.header_id = h.header_id ;
SELECT line_id ,
flow_status_code
FROM oe_order_lines_all l
WHERE l.header_id = p_header_id ;
g_order_line_list.DELETE ;
OE_ORDER_WF_UTIL.Update_Flow_Status_Code
(p_line_id => C_lines_rec.line_id,
p_flow_status_code => 'PROV_REQUEST',
x_return_status => l_resultout );
OE_ORDER_WF_UTIL.Update_Flow_Status_Code
(p_line_id => C_lines_rec.line_id,
p_flow_status_code => 'PROV_FAILED',
x_return_status => l_resultout );
SELECT order_number ,
version_number ,
request_date ,
expiration_date ,
header_id ,
sold_to_contact_id,
sold_to_org_id ,
org_id
FROM oe_order_headers_all
WHERE header_id = p_header_id ;
SELECT l.line_id ,
l.line_number ,
l.header_id ,
l.line_type_id ,
l.ship_from_org_id ,
l.schedule_ship_date,
l.promise_date ,
l.request_date ,
l.top_model_line_id ,
l.link_to_line_id ,
l.inventory_item_id ,
l.configuration_id,
l.config_header_id,
l.config_rev_nbr,
l.sort_order
FROM oe_order_lines_all l
WHERE l.header_id = p_header_id
AND l.link_to_line_id IS NULL
ORDER BY l.line_number ;
SELECT l.line_id ,
l.line_number ,
l.header_id ,
l.line_type_id ,
l.ship_from_org_id ,
l.schedule_ship_date,
l.promise_date ,
l.request_date ,
l.top_model_line_id ,
l.link_to_line_id ,
l.inventory_item_id ,
l.configuration_id,
l.config_header_id,
l.config_rev_nbr,
l.sort_order
FROM oe_order_lines_all l
WHERE l.header_id = p_header_id
AND l.top_model_line_id = p_top_line_id
AND l.link_to_line_id IS NOT NULL
AND l.line_id <> p_top_line_id
ORDER BY l.sort_order ;
OE_ORDER_WF_UTIL.Update_Flow_Status_Code
(p_line_id => l_line_id,
p_flow_status_code => 'PROV_REQUEST',
x_return_status => l_resultout );
OE_ORDER_WF_UTIL.Update_Flow_Status_Code
(p_line_id => l_line_id,
p_flow_status_code => 'PROV_FAILED',
x_return_status => l_resultout );
SELECT h.order_number ,
NVL(h.version_number,'1.0') ,
h.header_id
INTO l_order_number ,
l_order_version ,
l_header_id
FROM oe_order_lines_all l ,
oe_order_headers_all h
WHERE l.line_id = l_line_id
AND l.header_id = h.header_id ;
SELECT l.status_code,
l.line_item_id,
l.order_id
INTO l_line_status ,
l_line_item_id,
l_order_id
FROM xdp_order_headers h,
xdp_order_line_items l
WHERE h.external_order_number = to_char(l_order_number)
AND h.external_order_version = l_order_version
AND h.order_ref_name = 'SALES'
AND h.order_id = l.order_id
AND l.line_number = l_line_id ;
PROCEDURE UpdateTxnDetails
(itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER ,
resultout OUT NOCOPY VARCHAR2) IS
l_line_id NUMBER := to_number(itemkey);
l_order_id := wf_engine.GetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype,
itemkey => UpdateTxnDetails.itemkey,
aname => 'ORDER_ID');
l_line_item_id := wf_engine.GetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype,
itemkey => UpdateTxnDetails.itemkey,
aname => 'LINE_ITEM_ID');
XDP_INSTALL_BASE.UPDATE_IB(p_order_id => l_order_id,
p_line_id => l_line_item_id,
p_error_code => l_errcode,
p_error_description => l_error_description);
SELECT h.order_number ,
NVL(h.version_number,'1.0') ,
h.header_id
INTO l_order_number ,
l_order_version ,
l_header_id
FROM oe_order_lines_all l ,
oe_order_headers_all h
WHERE l.line_id = l_line_id
AND l.header_id = h.header_id ;
SELECT l.line_item_id,
l.order_id
INTO l_line_item_id,
l_order_id
FROM xdp_order_headers h,
xdp_order_line_items l
--Date: 05-JUL-2006, Author: DPUTHIYE, Bug#5370624/5222928
--Description: Implicit conversion of l_order_number and l_order_version to number fails.
--Dependencies: None.
-- WHERE h.external_order_number = l_order_number
-- AND h.external_order_version = l_order_version
WHERE h.external_order_number = to_char(l_order_number)
AND h.external_order_version = to_char(l_order_version)
AND h.order_ref_name = 'SALES'
AND h.order_id = l.order_id
AND l.line_number = l_line_id ;
XDP_INSTALL_BASE.UPDATE_IB(p_order_id => l_order_id,
p_line_id => l_line_item_id,
p_error_code => l_errcode,
p_error_description => l_error_description);
'UpdateTxnDetails. Error: ' || substr(sqlerrm,1,1500);
WF_ENGINE.SetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype ,
itemkey => UpdateTxnDetails.itemkey ,
aname => 'NOTIF_ERROR_CODE',
avalue => l_errcode );
WF_ENGINE.SetItemAttrText(itemtype => UpdateTxnDetails.itemtype ,
itemkey => UpdateTxnDetails.itemkey ,
aname => 'NOTIF_ERROR_MESSAGE',
avalue => l_error_description);
l_org_id := wf_engine.GetItemAttrNumber( itemtype => UpdateTxnDetails.itemtype,
itemkey => UpdateTxnDetails.itemkey,
aname => 'ORG_ID');
OE_ORDER_WF_UTIL.Update_Flow_Status_Code
(p_line_id => l_line_id,
p_flow_status_code => 'PROV_FAILED',
x_return_status => l_resultout );
l_org_id := wf_engine.GetItemAttrNumber( itemtype => UpdateTxnDetails.itemtype,
itemkey => UpdateTxnDetails.itemkey,
aname => 'ORG_ID');
OE_ORDER_WF_UTIL.Update_Flow_Status_Code
(p_line_id => l_line_id,
p_flow_status_code => 'PROV_REQUEST',
x_return_status => l_resultout );
wf_core.context('XDPCORE_OM', 'UpdateTxnDetails',itemtype,itemkey,actid,x_progress);
wf_core.context('XDPCORE_OM', 'UpdateTxnDetails',itemtype,itemkey,actid,x_progress);
END UpdateTxnDetails ;