The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT order_number, order_type_id, order_category_code,
org_id, VERSION_NUMBER, FLOW_STATUS_CODE
into l_order_number, l_order_type_id, l_order_category_code,
l_org_id, l_version_number, l_flow_status_code
from oe_blanket_headers_all
where header_id = err_itemkey;
SELECT T.NAME
INTO l_order_type_name
FROM OE_TRANSACTION_TYPES_TL T
WHERE T.LANGUAGE = userenv('LANG')
AND T.TRANSACTION_TYPE_ID = l_order_type_id;
SELECT name
INTO l_oper_unit_name
FROM HR_OPerating_units
WHERE ORGANIZATION_ID = l_org_id;
SELECT MEANING
INTO l_flow_status_code_meaning
FROM oe_lookups
where LOOKUP_CODE = l_flow_status_code
AND LOOKUP_TYPE = 'FLOW_STATUS';
select ITEM_TYPE, ITEM_KEY, ROOT_ACTIVITY
from wf_items
where ITEM_TYPE IN ('OMERROR','WFERROR')
and PARENT_ITEM_TYPE = p_item_type
and PARENT_ITEM_KEY = p_item_key
and END_DATE is null;
procedure update_process_messages (itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout in out NOCOPY /* file.sql.39 change */ varchar2)
is
l_conc_req_id number;
select header_id
into l_header_id
from oe_order_lines_all
where line_id = l_line_id;
end update_process_messages;
SELECT order_number, order_type_id, order_category_code,
org_id, SALESREP_ID, VERSION_NUMBER, FLOW_STATUS_CODE
into l_order_number, l_order_type_id, l_order_category_code,
l_org_id, l_salesrep_id, l_version_number, l_flow_status_code
from oe_order_headers_all
where header_id = err_itemkey;
SELECT T.NAME
INTO l_order_type_name
FROM OE_TRANSACTION_TYPES_TL T
WHERE T.LANGUAGE = userenv('LANG')
AND T.TRANSACTION_TYPE_ID = l_order_type_id;
SELECT name
INTO l_oper_unit_name
FROM HR_OPerating_units
WHERE ORGANIZATION_ID = l_org_id;
SELECT name
INTO l_salesrep
FROM ra_salesreps
WHERE salesrep_id = l_salesrep_id;
SELECT MEANING
INTO l_flow_status_code_meaning
FROM oe_lookups
where LOOKUP_CODE = l_flow_status_code
AND LOOKUP_TYPE = 'FLOW_STATUS';
SELECT header_id, FLOW_STATUS_CODE,
line_number, shipment_number, option_number, service_number
into l_header_id, l_flow_status_code,
l_line_number, l_shipment_number, l_option_number, l_service_number
FROM oe_order_lines_all
WHERE line_id = err_itemkey;
SELECT order_number, order_type_id, order_category_code,
org_id, SALESREP_ID, VERSION_NUMBER
into l_order_number, l_order_type_id, l_order_category_code,
l_org_id, l_salesrep_id, l_version_number
from oe_order_headers_all
where header_id = l_header_id;
SELECT T.NAME
INTO l_order_type_name
FROM OE_TRANSACTION_TYPES_TL T
WHERE T.LANGUAGE = userenv('LANG')
AND T.TRANSACTION_TYPE_ID = l_order_type_id;
SELECT name
INTO l_oper_unit_name
FROM HR_OPerating_units
WHERE ORGANIZATION_ID = l_org_id;
SELECT name
INTO l_salesrep
FROM ra_salesreps
WHERE salesrep_id = l_salesrep_id;
SELECT MEANING
INTO l_flow_status_code_meaning
FROM oe_lookups
where LOOKUP_CODE = l_flow_status_code
AND LOOKUP_TYPE = 'LINE_FLOW_STATUS';
SELECT name
INTO l_oper_unit_name
FROM HR_OPerating_units
WHERE ORGANIZATION_ID = l_org_id;
SELECT order_number, order_type_id, order_category_code,
SALESREP_ID, VERSION_NUMBER, FLOW_STATUS_CODE
into l_order_number, l_order_type_id, l_order_category_code,
l_salesrep_id, l_version_number, l_flow_status_code
from oe_order_headers_all
where header_id = l_header_id;
SELECT T.NAME
INTO l_order_type_name
FROM OE_TRANSACTION_TYPES_TL T
WHERE T.LANGUAGE = userenv('LANG')
AND T.TRANSACTION_TYPE_ID = l_order_type_id;
SELECT MEANING
INTO l_flow_status_code_meaning
FROM oe_lookups
where LOOKUP_CODE = l_flow_status_code
AND LOOKUP_TYPE = 'FLOW_STATUS';
select WIAS.ACTIVITY_STATUS
from WF_ITEM_ACTIVITY_STATUSES WIAS
where WIAS.ITEM_TYPE = litemtype
and WIAS.ITEM_KEY = litemkey
and WIAS.PROCESS_ACTIVITY = lactid;
OE_MSG_PUB.Update_Status_Code(
p_header_id => l_header_id,
p_process_activity => err_actid,
p_status_code => 'CLOSED');
OE_MSG_PUB.Update_Status_Code(
p_header_id => l_header_id,
p_line_id => err_itemkey,
p_process_activity => err_actid,
p_status_code => 'CLOSED');
OE_MSG_PUB.Update_Status_Code(
p_order_source_id => l_order_source_id,
p_orig_sys_document_ref => l_orig_sys_document_ref,
p_entity_code => 'ELECMSG_'||err_itemtype,
p_entity_id => to_number(err_itemkey),
p_process_activity => err_actid,
p_status_code => 'CLOSED');
Select header_id
Into x_header_id
From oe_order_headers_all
Where orig_sys_document_ref = x_orig_sys_document_ref
And decode(l_customer_key_profile, 'Y',
nvl(sold_to_org_id, -999), 1)
= decode(l_customer_key_profile, 'Y',
nvl(x_sold_to_org_id, -999), 1)
And order_source_id = x_order_source_id;
SELECT display_name
INTO l_activity_display_name
FROM WF_Activities_VL
WHERE Name = p_activity_name
AND Item_Type = p_activity_item_type
AND Version = (SELECT max(version)
FROM WF_Activities_VL
WHERE Name = p_activity_name
AND Item_Type = p_activity_item_type);
SELECT 1
INTO l_count
FROM wsh_delivery_details
WHERE source_line_id = to_number(p_item_key)
AND source_code = l_source_code_oe
AND released_status = l_released_status_closed
AND rownum < 2;
PROCEDURE Call_OM_Selector (p_item_type IN VARCHAR2,
p_item_key IN VARCHAR2,
p_activity_id IN NUMBER,
p_mode IN VARCHAR2,
p_x_result IN OUT NOCOPY VARCHAR2)
IS
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
oe_debug_pub.add('Entering Call_OM_Selector');
oe_debug_pub.add('Calling selector function for item type: '|| p_item_type || ' item key: ' || p_item_key || ' activity_id: ' || p_activity_id || ' mode: ' || p_mode);
OE_Standard_Wf.OEOH_Selector (p_item_type,
p_item_key,
p_activity_id,
p_mode, p_x_result);
OE_Standard_Wf.OEOL_Selector (p_item_type,
p_item_key,
p_activity_id,
p_mode, p_x_result);
OE_Standard_Wf.OEBH_Selector (p_item_type,
p_item_key,
p_activity_id,
p_mode, p_x_result);
OE_Standard_Wf.OENH_Selector (p_item_type,
p_item_key,
p_activity_id,
p_mode, p_x_result);
OE_Order_Import_Wf.OEOI_Selector (p_item_type,
p_item_key,
p_activity_id,
p_mode, p_x_result);
OE_Order_Import_Wf.OEOA_Selector (p_item_type,
p_item_key,
p_activity_id,
p_mode, p_x_result);
OE_Order_Import_Wf.OESO_Selector (p_item_type,
p_item_key,
p_activity_id,
p_mode, p_x_result);
OE_Elecmsgs_Pvt.OEEM_Selector (p_item_type,
p_item_key,
p_activity_id,
p_mode, p_x_result);
OE_Update_Ack_Util.OE_Edi_Selector (p_item_type,
p_item_key,
p_activity_id,
p_mode, p_x_result);
oe_debug_pub.add('Exiting Call_OM_Selector with result: ' || p_x_result);
SELECT 1
INTO l_count
FROM WF_ITEM_ACTIVITY_STATUSES IAS
WHERE IAS.ITEM_TYPE = p_item_type
AND IAS.ITEM_KEY = p_item_key
AND IAS.PROCESS_ACTIVITY = p_activity_id
AND IAS.ACTIVITY_STATUS = l_error_status
AND rownum = 1;
SELECT tl.message_text
FROM oe_processing_msgs msg, oe_processing_msgs_tl tl
WHERE msg.transaction_id = tl.transaction_id
AND msg.header_id = to_number(p_item_key)
AND nvl(msg.message_status_code, l_open) <> l_closed
AND tl.language = USERENV('LANG')
ORDER BY msg.transaction_id;
SELECT tl.message_text
FROM oe_processing_msgs msg, oe_processing_msgs_tl tl
WHERE msg.transaction_id = tl.transaction_id
AND msg.header_id = p_header_id
AND msg.line_id = to_number (p_item_key)
AND nvl(msg.message_status_code, l_open) <> l_closed
AND tl.language = USERENV('LANG')
ORDER BY msg.transaction_id;
SELECT tl.message_text
FROM oe_processing_msgs msg, oe_processing_msgs_tl tl
WHERE msg.transaction_id = tl.transaction_id
AND msg.entity_id = to_number(p_item_key)
AND msg.entity_code = l_entity_code
AND nvl(msg.message_status_code, l_open) <> l_closed
AND tl.language = USERENV('LANG')
ORDER BY msg.transaction_id;
SELECT tl.message_text
FROM oe_processing_msgs msg, oe_processing_msgs_tl tl
WHERE msg.transaction_id = tl.transaction_id
AND msg.entity_id = to_number(p_item_key)
AND msg.entity_code = l_entity_code
AND msg.order_source_id = p_order_source_id
AND msg.original_sys_document_ref = p_orig_sys_document_ref
AND nvl(msg.message_status_code, l_open) <> l_closed
AND tl.language = USERENV('LANG')
ORDER BY msg.transaction_id;
SELECT ORDER_NUMBER into l_ord_num
FROM OE_ORDER_HEADERS_ALL
WHERE header_id = to_number(p_item_key)
FOR UPDATE NOWAIT;
SELECT header_id into l_hdr_id
FROM OE_ORDER_LINES_ALL
WHERE line_id = to_number(p_item_key)
FOR UPDATE NOWAIT;
SELECT order_number into l_ord_num
FROM OE_ORDER_HEADERS_ALL
WHERE header_id = l_hdr_id
FOR UPDATE NOWAIT;
SELECT header_id into l_hdr_id
FROM OE_BLANKET_HEADERS_ALL
WHERE header_id = to_number(p_item_key)
FOR UPDATE NOWAIT;
OE_MSG_PUB.Update_Status_Code(
p_header_id => to_number(p_item_key),
p_process_activity => p_activity_id,
p_status_code => 'CLOSED');
OE_MSG_PUB.Update_Status_Code(
p_entity_code => 'BLANKET_HEADER',
p_entity_id => to_number(p_item_key),
p_process_activity => p_activity_id,
p_status_code => 'CLOSED');
OE_MSG_PUB.Update_Status_Code(
p_header_id => p_header_id,
p_line_id => to_number(p_item_key),
p_process_activity => p_activity_id,
p_status_code => 'CLOSED');
OE_MSG_PUB.Update_Status_Code(
p_order_source_id => l_order_source_id,
p_orig_sys_document_ref => l_orig_sys_document_ref,
p_entity_code => 'ELECMSG_'||p_item_type,
p_entity_id => to_number(p_item_key),
p_process_activity => p_activity_id,
p_status_code => 'CLOSED');
SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
FROM WF_PROCESS_ACTIVITIES PA,
WF_ITEMS I,
WF_ITEM_ACTIVITY_STATUSES IAS,
WF_ITEM_ATTRIBUTE_VALUES WAT,
WF_ACTIVITIES WA
WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
AND IAS.ITEM_KEY = I.ITEM_KEY
AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
AND IAS.ITEM_TYPE = OE_GLOBALS.G_WFI_LIN
AND I.PARENT_ITEM_KEY = p_item_key
AND I.PARENT_ITEM_TYPE = OE_GLOBALS.G_WFI_HDR
AND PA.PROCESS_ITEM_TYPE = OE_GLOBALS.G_WFI_LIN
AND IAS.ACTIVITY_STATUS = l_error_status
AND I.END_DATE IS NULL
AND WAT.ITEM_TYPE = IAS.ITEM_TYPE
AND WAT.ITEM_KEY = IAS.ITEM_KEY
AND WAT.NAME = l_org_id
AND WA.ITEM_TYPE = PA.ACTIVITY_ITEM_TYPE
AND WA.NAME = PA.ACTIVITY_NAME
AND WA.TYPE NOT IN ('PROCESS','FOLDER')
AND I.BEGIN_DATE >= WA.BEGIN_DATE
AND I.BEGIN_DATE < NVL(WA.END_DATE, I.BEGIN_DATE+1) --Modified for bug 6443885
ORDER BY WAT.NUMBER_VALUE;
SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
FROM WF_PROCESS_ACTIVITIES PA,
WF_ITEMS I,
WF_ITEM_ACTIVITY_STATUSES IAS,
WF_ITEM_ATTRIBUTE_VALUES WAT,
WF_ACTIVITIES WA
WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
AND IAS.ITEM_KEY = I.ITEM_KEY
AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
AND IAS.ITEM_TYPE = OE_GLOBALS.G_WFI_HDR
AND IAS.ITEM_KEY = p_item_key
AND PA.PROCESS_ITEM_TYPE = OE_GLOBALS.G_WFI_HDR
AND IAS.ACTIVITY_STATUS = l_error_status
AND I.END_DATE IS NULL
AND WAT.ITEM_TYPE = IAS.ITEM_TYPE
AND WAT.ITEM_KEY = IAS.ITEM_KEY
AND WAT.NAME = l_org_id
AND WA.ITEM_TYPE = PA.ACTIVITY_ITEM_TYPE
AND WA.NAME = PA.ACTIVITY_NAME
AND WA.TYPE NOT IN ('PROCESS','FOLDER')
AND I.BEGIN_DATE >= WA.BEGIN_DATE
AND I.BEGIN_DATE < NVL(WA.END_DATE, I.BEGIN_DATE+1) --Modified for bug 6443885
ORDER BY WAT.NUMBER_VALUE;
SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
FROM WF_PROCESS_ACTIVITIES PA,
WF_ITEMS I,
WF_ITEM_ACTIVITY_STATUSES IAS,
WF_ITEM_ATTRIBUTE_VALUES WAT,
WF_ACTIVITIES WA
WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
AND IAS.ITEM_KEY = I.ITEM_KEY
AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
AND IAS.ITEM_TYPE = p_item_type
AND PA.PROCESS_ITEM_TYPE = p_item_type
AND PA.ACTIVITY_NAME = p_activity_name
AND IAS.ACTIVITY_STATUS = l_error_status
AND IAS.BEGIN_DATE BETWEEN nvl(p_activity_error_date_from, IAS.BEGIN_DATE)
AND nvl(p_activity_error_date_to, IAS.BEGIN_DATE)
AND I.END_DATE IS NULL
AND WAT.ITEM_TYPE = IAS.ITEM_TYPE
AND WAT.ITEM_KEY = IAS.ITEM_KEY
AND WAT.NAME = l_org_id
AND WA.ITEM_TYPE = PA.ACTIVITY_ITEM_TYPE
AND WA.NAME = PA.ACTIVITY_NAME
AND WA.TYPE NOT IN ('PROCESS','FOLDER')
AND I.BEGIN_DATE >= WA.BEGIN_DATE
AND I.BEGIN_DATE < NVL(WA.END_DATE, I.BEGIN_DATE+1) --Modified for bug 6443885
ORDER BY WAT.NUMBER_VALUE;
SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
FROM WF_PROCESS_ACTIVITIES PA,
WF_ITEMS I,
WF_ITEM_ACTIVITY_STATUSES IAS,
WF_ITEM_ATTRIBUTE_VALUES WAT,
WF_ACTIVITIES WA
WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
AND IAS.ITEM_KEY = I.ITEM_KEY
AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
AND IAS.ITEM_TYPE = p_item_type
AND PA.PROCESS_ITEM_TYPE = p_item_type
AND IAS.ACTIVITY_STATUS = l_error_status
AND IAS.BEGIN_DATE BETWEEN nvl(p_activity_error_date_from, IAS.BEGIN_DATE)
AND nvl(p_activity_error_date_to, IAS.BEGIN_DATE)
AND I.END_DATE IS NULL
AND WAT.ITEM_TYPE = IAS.ITEM_TYPE
AND WAT.ITEM_KEY = IAS.ITEM_KEY
AND WAT.NAME = l_org_id
AND WA.ITEM_TYPE = PA.ACTIVITY_ITEM_TYPE
AND WA.NAME = PA.ACTIVITY_NAME
AND WA.TYPE NOT IN ('PROCESS','FOLDER')
AND I.BEGIN_DATE >= WA.BEGIN_DATE
AND I.BEGIN_DATE < NVL(WA.END_DATE, I.BEGIN_DATE+1) --Modified for bug 6443885
ORDER BY WAT.NUMBER_VALUE;
SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
FROM WF_PROCESS_ACTIVITIES PA,
WF_ITEMS I,
WF_ITEM_ACTIVITY_STATUSES IAS,
WF_ITEM_ATTRIBUTE_VALUES WAT,
WF_ACTIVITIES WA
WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
AND IAS.ITEM_KEY = I.ITEM_KEY
AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
AND IAS.ITEM_TYPE = p_item_type
AND PA.PROCESS_ITEM_TYPE = p_item_type
AND PA.ACTIVITY_NAME = p_activity_name
AND IAS.ACTIVITY_STATUS = l_error_status
AND IAS.BEGIN_DATE BETWEEN nvl(p_activity_error_date_from, IAS.BEGIN_DATE)
AND nvl(p_activity_error_date_to, IAS.BEGIN_DATE)
AND I.END_DATE IS NULL
AND WAT.ITEM_TYPE = I.PARENT_ITEM_TYPE
AND WAT.ITEM_KEY = I.PARENT_ITEM_KEY
AND WAT.NAME = l_org_id
AND WA.ITEM_TYPE = PA.ACTIVITY_ITEM_TYPE
AND WA.NAME = PA.ACTIVITY_NAME
AND WA.TYPE NOT IN ('PROCESS','FOLDER')
AND I.BEGIN_DATE >= WA.BEGIN_DATE
AND I.BEGIN_DATE < NVL(WA.END_DATE, I.BEGIN_DATE+1) --Modified for bug 6443885
ORDER BY WAT.NUMBER_VALUE;
SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
FROM WF_PROCESS_ACTIVITIES PA,
WF_ITEMS I,
WF_ITEM_ACTIVITY_STATUSES IAS,
WF_ITEM_ATTRIBUTE_VALUES WAT,
WF_ACTIVITIES WA
WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
AND IAS.ITEM_KEY = I.ITEM_KEY
AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
AND IAS.ITEM_TYPE = p_item_type
AND PA.PROCESS_ITEM_TYPE = p_item_type
AND IAS.ACTIVITY_STATUS = l_error_status
AND IAS.BEGIN_DATE BETWEEN nvl(p_activity_error_date_from, IAS.BEGIN_DATE)
AND nvl(p_activity_error_date_to, IAS.BEGIN_DATE)
AND I.END_DATE IS NULL
AND WAT.ITEM_TYPE = I.PARENT_ITEM_TYPE
AND WAT.ITEM_KEY = I.PARENT_ITEM_KEY
AND WAT.NAME = l_org_id
AND WA.ITEM_TYPE = PA.ACTIVITY_ITEM_TYPE
AND WA.NAME = PA.ACTIVITY_NAME
AND WA.TYPE NOT IN ('PROCESS','FOLDER')
AND I.BEGIN_DATE >= WA.BEGIN_DATE
AND I.BEGIN_DATE < NVL(WA.END_DATE, I.BEGIN_DATE+1) --Modified for bug 6443885
ORDER BY WAT.NUMBER_VALUE;
SELECT header_id
INTO l_header_id
FROM OE_Order_Lines_All
WHERE line_id = to_number(l_retry_rec.item_key(i));
-- Call Selector function
----------------------------------------------------------------------------
p_x_result := NULL;
Call_OM_Selector(p_item_type => l_retry_rec.parent_item_type(i),
p_item_key => l_retry_rec.parent_item_key(i),
p_activity_id => NULL, -- this should be ok as we do not have activity
-- specific logic in the selector functions
p_mode => 'TEST_CTX',
p_x_result => p_x_result);
-- call the parent selector function
Call_OM_Selector(p_item_type => l_retry_rec.parent_item_type(i),
p_item_key => l_retry_rec.parent_item_key(i),
p_activity_id => NULL, -- this should be ok as we do not have activity
-- specific logic in the selector functions
p_mode => 'SET_CTX',
p_x_result => p_x_result);
Call_OM_Selector(p_item_type => p_item_type,
p_item_key => l_retry_rec.item_key(i),
p_activity_id => NULL, -- this should be ok as we do not have activity
-- specific logic in the selector functions
p_mode => 'TEST_CTX',
p_x_result => p_x_result);
Call_OM_Selector(p_item_type => p_item_type,
p_item_key => l_retry_rec.item_key(i),
p_activity_id => NULL, -- this should be ok as we do not have activity
-- specific logic in the selector functions
p_mode => 'SET_CTX',
p_x_result => p_x_result);
oe_debug_pub.add('Org context unchanged, not calling selector function for org id: ' || l_retry_rec.org_id(i));
SELECT hsecs INTO l_start_total_time from v$timer;
SELECT hsecs INTO l_end_total_time from v$timer;
FND_FILE.PUT_LINE(FND_FILE.LOG, 'The above activity is not retried because header and line records can not be locked for update. Please try later');
SELECT display_name
INTO l_item_type_display_name
FROM wf_item_types_vl
WHERE name = p_item_type;
SELECT order_number into l_order_num
from oe_order_headers_all
where header_id = p_item_key;
SELECT MEANING into l_user_mode
FROM OE_LOOKUPS
WHERE LOOKUP_CODE= p_mode
AND LOOKUP_TYPE='ONT_RETRY_MODE'
AND ENABLED_FLAG='Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE);
SELECT DISPLAY_NAME into l_act_display_name FROM wf_activities_vl
WHERE ROW_ID IN (SELECT MAX(ROWID) FROM WF_ACTIVITIES WA
WHERE WA.TYPE NOT IN ('PROCESS','FOLDER')
AND EXISTS (SELECT ACTIVITY_NAME FROM WF_PROCESS_ACTIVITIES WPA
WHERE WA.NAME = WPA.ACTIVITY_NAME
AND WPA.PROCESS_ITEM_TYPE = P_ITEM_TYPE
AND WA.ITEM_TYPE=WPA.ACTIVITY_ITEM_TYPE)
AND WA.VERSION = (SELECT MAX(WA2.VERSION) FROM WF_ACTIVITIES WA2
WHERE WA2.ITEM_TYPE = WA.ITEM_TYPE
AND WA2.NAME=WA.NAME)
GROUP BY WA.NAME)
AND NAME = p_activity_name;
SELECT display_name
INTO l_item_type_display_name2
FROM wf_item_types_vl
WHERE name = OE_GLOBALS.G_WFI_LIN;