APPS.PA_PARCPRJR_XMLP_PKG SQL Statements

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

Line: 27

    IF P_SELECTION_OPTION = 'EMP_RANGE' THEN
      IF (P_FROM_EMP_NUM IS NULL OR P_TO_EMP_NUM IS NULL) THEN
        CP_CHK_EMP_RANGE := 'N';

Line: 32

    ELSIF P_SELECTION_OPTION = 'EMP_RANGE_ORG' THEN
      IF (P_ORGANIZATION_ID IS NULL OR P_FROM_EMP_NUM IS NULL OR P_TO_EMP_NUM IS NULL) THEN
        CP_CHK_ORG_AND_EMP_RANGE := 'N';

Line: 37

    ELSIF P_SELECTION_OPTION = 'SINGLE_ORG' THEN
      IF (P_ORGANIZATION_ID IS NULL) THEN
        CP_CHK_SINGLE_ORG := 'N';

Line: 42

    ELSIF P_SELECTION_OPTION = 'START_ORG' THEN
      IF (P_ORG_STR_VERSION_ID IS NULL OR P_START_ORGANIZATION_ID IS NULL) THEN
        CP_CHK_START_ORG := 'N';

Line: 50

      SELECT
        SYSDATE
      INTO L_DATE
      FROM
        DUAL;

Line: 60

                   ,' OTHER PROBLEM IN SELECTING THE SYSDATE ' || SQLERRM)*/NULL;

Line: 70

                                              ,P_SELECTION_OPTION => P_SELECTION_OPTION
                                              ,P_ORG_STR_VERSION_ID => P_ORG_STR_VERSION_ID
                                              ,P_START_ORGANIZATION_ID => P_START_ORGANIZATION_ID
                                              ,X_RETURN_STATUS => L_RETURN_STATUS
                                              ,X_MSG_COUNT => L_MSG_COUNT
                                              ,X_MSG_DATA => L_MSG_DATA
                                              ,X_RESOURCE_ID => L_RESOURCE_ID);

Line: 87

    SELECT
      count(*)
    INTO CP_COUNT
    FROM
      PA_RESOURCES RES,
      PA_RESOURCES_DENORM OU,
      HR_ALL_ORGANIZATION_UNITS HRORG
    WHERE RES.RESOURCE_ID = OU.RESOURCE_ID
      AND HRORG.ORGANIZATION_ID = OU.RESOURCE_ORGANIZATION_ID
      AND ( DECODE(RES.REQUEST_ID
          ,P_CONC_REQUEST_ID
          ,RES.REQUEST_ID
          ,NULL) = P_CONC_REQUEST_ID
    OR DECODE(OU.REQUEST_ID
          ,P_CONC_REQUEST_ID
          ,OU.REQUEST_ID
          ,NULL) = P_CONC_REQUEST_ID );

Line: 126

      SELECT
        SUBSTR(NAME
              ,1
              ,60)
      INTO L_NAME
      FROM
        PA_R_EXPENDITURE_ORGS_V
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 142

      SELECT
        MEANING
      INTO L_MEANING
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = 'Y';

Line: 150

      SELECT
        MEANING
      INTO L_MEANING
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = 'N';

Line: 161

  FUNCTION CF_SELECTION_OPTIONFORMULA RETURN CHAR IS
    L_SELECTION_OPTION PA_LOOKUPS.MEANING%TYPE := NULL;

Line: 164

    IF P_SELECTION_OPTION IS NOT NULL THEN
      SELECT
        MEANING
      INTO L_SELECTION_OPTION
      FROM
        PA_LOOKUPS
      WHERE LOOKUP_TYPE = 'PA_RES_PULL_SELECT_TYPE'
        AND LOOKUP_CODE = P_SELECTION_OPTION;

Line: 173

    RETURN L_SELECTION_OPTION;

Line: 174

  END CF_SELECTION_OPTIONFORMULA;

Line: 181

      SELECT
        SUBSTR(POS.NAME
              ,1
              ,60),
        POSV.VERSION_NUMBER
      INTO L_ORG_STR_VERSION_ID,L_ORG_STR_VERSION_NUM
      FROM
        PER_ORGANIZATION_STRUCTURES POS,
        PER_ORG_STRUCTURE_VERSIONS POSV
      WHERE POSV.ORGANIZATION_STRUCTURE_ID = POS.ORGANIZATION_STRUCTURE_ID
        AND POSV.ORG_STRUCTURE_VERSION_ID = P_ORG_STR_VERSION_ID;

Line: 204

      SELECT
        SUBSTR(NAME
              ,1
              ,60)
      INTO L_START_ORG_ID
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_START_ORGANIZATION_ID;

Line: 220

      SELECT
        MEANING
      INTO L_PULL_TERM_RES
      FROM
        PA_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_PULL_TERM_RES;

Line: 235

      SELECT
        MEANING
      INTO L_PERSON_TYPE
      FROM
        FND_LOOKUP_VALUES
      WHERE LOOKUP_TYPE in ( 'PA_REP_ALL' , 'PERSON_TYPE' )
        AND LOOKUP_CODE = P_PERSON_TYPE
        AND LANGUAGE = USERENV('LANG');