The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure insert_log(msg varchar2,dt date:=SYSDATE) IS
PRAGMA AUTONOMOUS_TRANSACTION;
END INSERT_LOG;
SELECT DECODE(master_organization_id, p_organization_id, 'Y', 'N'),
organization_code
INTO x_master_org_flag,
x_organization_code
FROM MTL_PARAMETERS
WHERE organization_id = p_organization_id;
SELECT CONCATENATED_SEGMENTS, DESCRIPTION
INTO x_item_number, x_item_description
FROM MTL_SYSTEM_ITEMS_KFV
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = p_organization_id;
SELECT CONCATENATED_SEGMENTS
INTO x_category_name
FROM MTL_CATEGORIES_KFV
WHERE category_id = p_category_id;
update to the tables by checking the records with process_flag=7 */
CURSOR c_raise_item_change_event(cp_request_id NUMBER
,cp_xset_id NUMBER) IS
SELECT 'x' FROM dual
WHERE EXISTS( SELECT NULL
FROM mtl_system_items_interface
WHERE set_process_id = cp_xset_id
AND process_flag = 7
AND request_id = cp_request_id
AND transaction_type in ('UPDATE','CREATE'));
SELECT 'x' FROM dual
WHERE EXISTS(SELECT NULL
FROM mtl_item_revisions_interface
WHERE set_process_id = cp_xset_id
AND process_flag = 7
AND request_id = cp_request_id);
SELECT 'x' FROM dual
WHERE EXISTS(SELECT NULL
FROM mtl_item_categories_interface
WHERE set_process_id = cp_xset_id
AND process_flag = 7
AND request_id = cp_request_id);
WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT' THEN
-- Populate Item and Orgnanization Information
get_Org_Info(
p_organization_id => p_organization_id
,x_organization_code => l_organization_code
,x_master_org_flag => l_master_org_flag);
' EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event( '||
' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT '||
' ,p_request_id => :p_request_id '||
' ,p_Organization_Id => :p_organization_id '||
' ,p_organization_code => :l_organization_code '||
' ,p_Inventory_Item_Id => :p_inventory_item_id '||
' ,p_item_number => :l_item_number '||
' ,p_item_description => :l_item_description '||
' ,p_is_master_attr_modified => :l_is_master_attr_modified '|| /* Added for bug 6407303*/
' ,x_msg_data => :l_msg_data '||
' ,x_return_status => :l_ret_status); '||
' EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event( '||
' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_CREATE_EVENT '||
' ,p_request_id => :p_request_id '||
' ,p_Organization_Id => :p_organization_id '||
' ,p_organization_code => :l_organization_code '||
' ,p_Inventory_Item_Id => :p_inventory_item_id '||
' ,p_item_number => :l_item_number '||
' ,p_item_description => :l_item_description '||
' ,x_msg_data => :l_msg_data '||
' ,x_return_status => :l_ret_status); '||
update to the tables by checking the records with process_flag=7 */
CURSOR c_raise_item_change_event(cp_request_id NUMBER
,cp_xset_id NUMBER) IS
SELECT 'x' FROM dual
WHERE EXISTS( SELECT NULL
FROM mtl_system_items_interface
WHERE set_process_id = cp_xset_id
AND process_flag = 7
AND request_id = cp_request_id
AND transaction_type in ('UPDATE','CREATE'));
SELECT 'x' FROM dual
WHERE EXISTS(SELECT NULL
FROM mtl_item_categories_interface
WHERE set_process_id = cp_xset_id
AND process_flag = 7
AND request_id = cp_request_id);
' ICX_CAT_POPULATE_CATG_GRP.populateValidCategorySetInsert( '||
' P_API_VERSION => 1.0 '||
' ,P_COMMIT => :l_commit '||
' ,P_INIT_MSG_LIST => NULL '||
' ,P_VALIDATION_LEVEL => NULL '||
' ,P_CATEGORY_SET_ID => :p_category_set_id '||
' ,P_CATEGORY_ID => :p_category_id '||
' ,X_RETURN_STATUS => :l_ret_status); '||
WHEN p_dml_type = 'UPDATE' THEN
EXECUTE IMMEDIATE
'BEGIN '||
' ICX_CAT_POPULATE_CATG_GRP.populateValidCategorySetDelete( '||
' P_API_VERSION => 1.0 '||
' ,P_COMMIT => :l_commit '||
' ,P_INIT_MSG_LIST => NULL '||
' ,P_VALIDATION_LEVEL => NULL '||
' ,P_CATEGORY_SET_ID => :p_category_set_id '||
' ,P_NEW_CATEGORY_ID => :p_category_id '||
' ,P_OLD_CATEGORY_ID => :p_old_category_id '||
' ,X_RETURN_STATUS => :l_ret_status); '||
WHEN p_dml_type = 'DELETE' THEN
EXECUTE IMMEDIATE
'BEGIN '||
' ICX_CAT_POPULATE_CATG_GRP.populateValidCategorySetDelete( '||
' P_API_VERSION => 1.0 '||
' ,P_COMMIT => :l_commit '||
' ,P_INIT_MSG_LIST => NULL '||
' ,P_VALIDATION_LEVEL => NULL '||
' ,P_CATEGORY_SET_ID => :p_category_set_id '||
' ,P_CATEGORY_ID => :p_category_id '||
' ,X_RETURN_STATUS => :l_ret_status); '||
select DECODE(ORG_INFORMATION_CONTEXT,
'Accounting Information',
TO_NUMBER(ORG_INFORMATION3),
TO_NUMBER(NULL))
into l_operating_unit
from hr_organization_information
where organization_id = p_organization_id
and (org_information_context|| '') ='Accounting Information';