The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select EXECUTE_FLAG
into l_execute
from
JTF_USER_HOOKS
Where
pkg_name = p_pkg_name and
api_name = p_api_name and
processing_type = p_process_type and
user_hook_type = p_user_hook_type;
Select bind_name, bind_value, data_type
From JTF_BIND_DATA
Where bind_data_id = l_bind_data_id And
bind_type = 'W';
Select bind_name, bind_value, data_type
From JTF_BIND_DATA
Where bind_data_id = l_bind_data_id And
bind_type = 'W';
select bus_obj_sql, nvl(msg_mode,1) , bus_obj_name
into l_msg_SQL, l_msg_mode, l_bus_obj_name
from JTF_MESSAGE_OBJECTS
where
PRODUCT_CODE = p_prod_code and
BUS_OBJ_CODE = p_bus_obj_code and
ACTION_CODE = p_action_code and
ACTIVE_FLAG = 'Y';
select bus_obj_sql ,nvl(msg_mode,1) , bus_obj_name
into l_msg_SQL, l_msg_mode, l_bus_obj_name
from JTF_MESSAGE_OBJECTS
where
PRODUCT_CODE = p_prod_code and
BUS_OBJ_CODE = p_bus_obj_code and
ACTION_CODE = p_action_code and
ACTIVE_FLAG = 'Y';
select bus_obj_sql ,nvl(msg_mode,1) , bus_obj_name
into l_msg_SQL, l_msg_mode, l_bus_obj_name
from JTF_MESSAGE_OBJECTS
where
PRODUCT_CODE = p_prod_code and
BUS_OBJ_CODE = p_bus_obj_code and
ACTION_CODE = p_action_code and
ACTIVE_FLAG = 'Y';
select jtf_msg_id_s.nextval
into x_msg_id
from dual;
delete from JTF_SYNC_REPLY_MSG
where msg_id = x_msg_id
returning reply_msg into x_reply_msg;
select jtf_msg_id_s.nextval
into x_msg_id
from dual;
delete from JTF_SYNC_REPLY_MSG
where msg_id = x_msg_id
returning reply_msg into x_reply_msg;
Insert into JTF_BIND_DATA(
bind_data_id,
bind_name,
bind_value,
bind_type,
data_type )
Values (
p_bind_data_id,
p_bind_name,
p_bind_value,
p_bind_type,
p_data_type );
Delete from JTF_BIND_DATA
Where BIND_DATA_ID = p_Bind_Data_Id And
BIND_TYPE = p_bind_type ;
Select JTF_USER_HOOKS_S.NEXTVAL
into l_hk_id
from Dual;
Select JTF_MSG_OBJ_S.NEXTVAL
into l_bo_id
from Dual;
Select bind_name, bind_value
From JTF_BIND_DATA
Where bind_data_id = v_bind_data_id And
bind_type = 'S';
select bus_obj_sql, nvl(msg_mode,1), bus_obj_name
into l_msg_SQL, l_msg_mode, l_bus_obj_name
from JTF_MESSAGE_OBJECTS
where
PRODUCT_CODE = p_prod_code and
BUS_OBJ_CODE = p_bus_obj_code and
ACTION_CODE = p_action_code and
ACTIVE_FLAG = 'Y';
select HEADER_DTD into l_hdr_DTD
from JTF_HEADER_DTD
where
ACTIVE_FLAG = 'Y';