APPS.XDP_PROC_CTL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 292

        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');

Line: 308

        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 );

Line: 972

  * 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);

Line: 1028

  * 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);

Line: 1176

  * 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);

Line: 1209

  * 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);

Line: 1263

 SELECT SUBSTR(text,1,80)
 FROM user_errors
 WHERE UPPER(name) = UPPER(p_ProcName)
 and sequence < 3
 order by line;

Line: 1429

   SELECT XDP_CHANNEL_S.NEXTVAL into l_Seq
   FROM dual;

Line: 1516

  * 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);

Line: 2065

XDP_ADAPTER_CORE_DB.Update_Adapter_Status (
	p_ChannelName => ChannelName,
	p_Status => XDP_ADAPTER.pv_statusSessionLost);

Line: 2677

    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);

Line: 3306

  * 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);

Line: 3341

  * 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);

Line: 3450

  * 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);

Line: 3486

     * 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);

Line: 3514

 pv_ConnectCommands.delete;