APPS.AP_APXIIMPT_XMLP_PKG SQL Statements

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

Line: 65

    SELECT
      LY.MEANING,
      LN.MEANING,
      L1.DISPLAYED_FIELD,
      L2.DISPLAYED_FIELD,
      L3.DISPLAYED_FIELD
    INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
    FROM
      FND_LOOKUPS LY,
      FND_LOOKUPS LN,
      AP_LOOKUP_CODES L1,
      AP_LOOKUP_CODES L2,
      AP_LOOKUP_CODES L3
    WHERE LY.LOOKUP_TYPE = 'YES_NO'
      AND LY.LOOKUP_CODE = 'Y'
      AND LN.LOOKUP_TYPE = 'YES_NO'
      AND LN.LOOKUP_CODE = 'N'
      AND L1.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
      AND L1.LOOKUP_CODE = 'ALL'
      AND L2.LOOKUP_TYPE = 'NLS TRANSLATION'
      AND L2.LOOKUP_CODE = 'VOID'
      AND L3.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
      AND L3.LOOKUP_CODE = 'NA';

Line: 121

      select SUBSTR(argument1,INSTR(argument1,'=',1)+1,LENGTH(argument1)),
      SUBSTR(argument2,INSTR(argument2,'=',1)+1,LENGTH(argument2)),
      SUBSTR(argument3,INSTR(argument3,'=',1)+1,LENGTH(argument3)),
      SUBSTR(argument4,INSTR(argument4,'=',1)+1,LENGTH(argument4)),
      SUBSTR(argument5,INSTR(argument5,'=',1)+1,LENGTH(argument5)),
      SUBSTR(argument6,INSTR(argument6,'=',1)+1,LENGTH(argument6)),
      to_date(SUBSTR(argument7,INSTR(argument7,'=',1)+1,LENGTH(argument7)),'YYYY/MM/DD HH24:MI:SS'),
      SUBSTR(argument8,INSTR(argument8,'=',1)+1,LENGTH(argument8)),
      SUBSTR(argument9,INSTR(argument9,'=',1)+1,LENGTH(argument9)),
      SUBSTR(argument10,INSTR(argument10,'=',1)+1,LENGTH(argument10)),
      SUBSTR(argument11,INSTR(argument11,'=',1)+1,LENGTH(argument11))
      into
      p_org_id_t,p_source_t,p_group_id_t,p_batch_name_t,p_hold_code_t,p_hold_reason_t,p_gl_date_t,
      p_purge_flag_t,p_trace_switch_t,p_debug_switch_t,p_summary_flag_t
      from FND_CONCURRENT_REQUESTS
      where request_id=P_CONC_REQUEST_ID;

Line: 292

        DEBUG_INFO := '(After report trigger 2) Delete records in ap_invoices_interface';

Line: 305

      DEBUG_INFO := '(After report 3) Delete record in ap_interface_controls';

Line: 310

      DELETE FROM AP_INTERFACE_CONTROLS
       WHERE SOURCE = p_source_t
         AND ( ( p_group_id_t IS NULL )
       OR ( GROUP_ID = p_group_id_t ) )
         AND REQUEST_ID = P_CONC_REQUEST_ID;

Line: 372

      SELECT
        'OLD BATCH',
        BATCH_ID
      INTO P_BATCH_TYPE,L_BATCH_ID
      FROM
        AP_BATCHES
      WHERE BATCH_NAME = p_batch_name_t;

Line: 389

      SELECT
        AP_BATCHES_S.NEXTVAL
      INTO L_BATCH_ID
      FROM
        SYS.DUAL;

Line: 421

    SELECT
      NVL(MAX(DISTRIBUTION_LINE_NUMBER)
         ,0)
    INTO P_CURRENT_DIST_NUM
    FROM
      AP_INVOICE_DISTRIBUTIONS
    WHERE INVOICE_ID = P_INVOICE_ID;

Line: 459

      SELECT
        DISPLAYED_FIELD
      INTO L_SOURCES
      FROM
        AP_LOOKUP_CODES
      WHERE LOOKUP_TYPE = 'SOURCE'
        AND LOOKUP_CODE = p_source_t;

Line: 493

      SELECT
        MEANING
      INTO L_PURGE_FLAG
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_CODE = p_purge_flag_t
        AND LOOKUP_TYPE = 'YES_NO';