The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 1 into l_ParamCount from dual
where exists ( select LOOKUP_CODE
from CSI_LOOKUPS
where LOOKUP_CODE = Param
and lookup_type = 'CSI_EXTEND_ATTRIB_POOL');
select 1 into l_ParamCount from dual
where exists (
select XFA.PARAMETER_NAME
from XDP_FA_PARAMETERS XFA
where FULFILLMENT_ACTION_ID = FAID
and XFA.PARAMETER_NAME = Param );
* Need to find the DECLARE word location and delete the users declare string (can be case sensitive)
*/
l_declare_loc := INSTR(UPPER(l_temp_str), 'DECLARE', 1, 1);
* Find the first users's Send string and insert the SEND_SYNC procedure call before the
* first call to send.
*/
l_send_loc := INSTR(UPPER(l_final_str), 'XDP_PROC_CTL.SEND(', 1, 1);
* Need to find the DECLARE word location and delete the users declare string (can be case sensitive)
*/
l_declare_loc := INSTR(UPPER(l_temp_str), 'DECLARE', 1, 1);
* Find the first users's Send string and insert the SEND_SYNC procedure call before the
* first call to send.
*/
l_send_loc := INSTR(UPPER(l_final_str), 'XDP_PROC_CTL.SEND(', 1, 1);
SELECT SUBSTR(text,1,80)
FROM user_errors
WHERE UPPER(name) = UPPER(p_ProcName)
and sequence < 3
order by line;
SELECT XDP_CHANNEL_S.NEXTVAL into l_Seq
FROM dual;
* Insert into the audit trail table.
*/
INSERT INTO XDP_FE_CMD_AUD_TRAILS (
fa_instance_id,
fe_command_seq,
fulfillment_element_name,
fulfillment_element_type,
sw_generic,
command_sent,
command_sent_date,
response,
response_date,
provisioning_procedure)
VALUES (
FAInstanceID,
XDP_FE_CMD_AUD_TRAILS_S.NEXTVAL,
l_FeName,
l_FeType,
l_Sw_Generic,
l_CommandSent,
SentDate,
SUBSTR(l_Response,1,3999),
RespDate,
ProcName);
XDP_ADAPTER_CORE_DB.Update_Adapter_Status (
p_ChannelName => ChannelName,
p_Status => XDP_ADAPTER.pv_statusSessionLost);
select 1 into l_ParamCount from dual
where exists (
select FE_ATTRIBUTE_ID
from XDP_FE_ATTRIBUTE_DEF xad, XDP_FE_SW_GEN_LOOKUP xfl
where xad.FE_ATTRIBUTE_NAME = Param
and xad.FE_SW_GEN_LOOKUP_ID = xfl.FE_SW_GEN_LOOKUP_ID
and xfl.FETYPE_ID = FeTypeID);
* Need to find the DECLARE word location and delete the users declare string (can be case sensitive)
*/
l_declare_loc := INSTR(UPPER(l_temp_str), 'DECLARE', 1, 1);
* Find the first users's Send string and insert the RESET_BUFFER procedure call before the
* first call to send.
*/
l_send_loc := INSTR(UPPER(l_final_str), 'XDP_PROC_CTL.SEND_CONNECT(', 1, 1);
* Need to find the DECLARE word location and delete the users declare string (can be case sensitive)
*/
l_declare_loc := INSTR(UPPER(l_temp_str), 'DECLARE', 1, 1);
* Find the first users's DISCONNECT string and insert the RESET_BUFFER procedure call
* before the first call to send.
*/
l_sync_loc := INSTR(UPPER(l_final_str), 'XDP_PROC_CTL.SEND_CONNECT', 1, 1);
pv_ConnectCommands.delete;