APPS.AP_APXHRUPD_XMLP_PKG SQL Statements

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

Line: 13

    SELECT
      P.BASE_CURRENCY_CODE,
      C.PRECISION,
      C.MINIMUM_ACCOUNTABLE_UNIT,
      C.DESCRIPTION
    INTO BASE_CURR,PREC,MIN_AU,DESCR
    FROM
      AP_SYSTEM_PARAMETERS P,
      FND_CURRENCIES C
    WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE;

Line: 59

    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: 158

      IF (AP_EMPLOYEE_UPDATE_PKG.UPDATE_EMPLOYEE(C_UPDATE_DATE
                                            ,P_FROM_SUPPLIER
                                            ,P_TO_SUPPLIER
                                            ,P_DEBUG_SWITCH
                                            ,'After Report Trigger') <> TRUE) THEN
        RAISE INIT_FAILURE;

Line: 167

                   ,'AP_EMPLOYEE_UPDATE_PKG.Update_Employee')*/NULL;

Line: 191

    SELECT
      NAME,
      CHART_OF_ACCOUNTS_ID
    INTO L_NAME,L_CHART_OF_ACCOUNTS_ID
    FROM
      GL_SETS_OF_BOOKS
    WHERE SET_OF_BOOKS_ID = L_SOB_ID;

Line: 211

    SELECT
      MAX(REQUESTED_START_DATE)
    INTO L_REQUESTED_START_DATE
    FROM
      FND_CONCURRENT_PROGRAMS FCONC,
      FND_CONCURRENT_REQUESTS FREQ
    WHERE FCONC.APPLICATION_ID = FREQ.PROGRAM_APPLICATION_ID
      AND FCONC.CONCURRENT_PROGRAM_ID = FREQ.CONCURRENT_PROGRAM_ID
      AND FCONC.CONCURRENT_PROGRAM_NAME = 'APXHRUPD'
      AND FREQ.STATUS_CODE = 'C';

Line: 222

      C_UPDATE_DATE := NULL;

Line: 224

      C_UPDATE_DATE := NVL(L_REQUESTED_START_DATE
                          ,TO_DATE('01/01/1951'
                                 ,'DD/MM/YYYY'));

Line: 230

                 ,'C_Update Date: ' || C_UPDATE_DATE)*/NULL;

Line: 255

  FUNCTION C_DUPLICATE_YES_NOFORMULA(UPDATED_VALUE IN VARCHAR2
                                    ,UPDATED_TO IN VARCHAR2) RETURN VARCHAR2 IS
    L_DUPLICATES VARCHAR2(1);

Line: 260

    /*SRW.REFERENCE(UPDATED_VALUE)*/NULL;

Line: 261

    IF UPDATED_VALUE = 'Name' THEN
      BEGIN
        SELECT
          'Y'
        INTO L_DUPLICATES
        FROM
          DUAL
        WHERE EXISTS (
          SELECT
            'Duplicates exist in Po_Vendors'
          FROM
            AP_SUPPLIERS
          WHERE VENDOR_NAME = UPDATED_TO );

Line: 277

          SELECT
            COUNT(PERSON_ID)
          INTO L_COUNT
          FROM
            PER_ALL_PEOPLE_F PPF
          WHERE TRUNC(SYSDATE) between PPF.EFFECTIVE_START_DATE
            AND PPF.EFFECTIVE_END_DATE
            AND DECODE(PPF.MIDDLE_NAMES
                ,NULL
                ,PPF.LAST_NAME || ', ' || PPF.FIRST_NAME
                ,PPF.LAST_NAME || ', ' || PPF.FIRST_NAME || ' ' || PPF.MIDDLE_NAMES) = UPDATED_TO;

Line: 303

      C_NAME_UPDATE_DATE := ' ';

Line: 304

      C_INACTIVE_UPDATE_DATE := ' ';

Line: 305

      C_HOME_UPDATE_DATE := ' ';

Line: 306

      C_OFFICE_UPDATE_DATE := ' ';

Line: 309

      C_NAME_UPDATE_DATE := ' and ppf.last_update_date  > ' || '''' || C_UPDATE_DATE || '''';

Line: 310

      C_INACTIVE_UPDATE_DATE := ' and ppos.last_update_date > ' || '''' || C_UPDATE_DATE || '''';

Line: 311

      C_HOME_UPDATE_DATE := ' and pa1.last_update_date > ' || '''' || C_UPDATE_DATE || '''';

Line: 312

      C_OFFICE_UPDATE_DATE := ' and (trunc(paf.last_update_date) >= ' || '''' || C_UPDATE_DATE || '''' || ' OR ' || 'trunc(locs.last_update_date) >= ' || '''' || C_UPDATE_DATE || '''' || ')';

Line: 317

               ,'C_name_update_date: ' || C_NAME_UPDATE_DATE)*/NULL;

Line: 319

               ,'C_inactive_update_date: ' || C_INACTIVE_UPDATE_DATE)*/NULL;

Line: 321

               ,'C_home_update_date: ' || C_HOME_UPDATE_DATE)*/NULL;

Line: 323

               ,'C_office_update_date: ' || C_OFFICE_UPDATE_DATE)*/NULL;

Line: 411

  FUNCTION C_NAME_UPDATE_DATE_P RETURN VARCHAR2 IS
  BEGIN
    RETURN C_NAME_UPDATE_DATE;

Line: 414

  END C_NAME_UPDATE_DATE_P;

Line: 416

  FUNCTION C_INACTIVE_UPDATE_DATE_P RETURN VARCHAR2 IS
  BEGIN
    RETURN C_INACTIVE_UPDATE_DATE;

Line: 419

  END C_INACTIVE_UPDATE_DATE_P;

Line: 421

  FUNCTION C_HOME_UPDATE_DATE_P RETURN VARCHAR2 IS
  BEGIN
    RETURN C_HOME_UPDATE_DATE;

Line: 424

  END C_HOME_UPDATE_DATE_P;

Line: 426

  FUNCTION C_OFFICE_UPDATE_DATE_P RETURN VARCHAR2 IS
  BEGIN
    RETURN C_OFFICE_UPDATE_DATE;

Line: 429

  END C_OFFICE_UPDATE_DATE_P;