APPS.GMO_DOCUMENT_NUMBERS_PVT SQL Statements

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

Line: 20

  SELECT DISTINCT(OV.ORGANIZATION_CODE || ' ' || OV.ORGANIZATION_NAME)
  FROM   ORG_ACCESS_VIEW OV
  WHERE  OV.ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 27

  SELECT LK.MEANING
  FROM   FND_LOOKUP_VALUES_VL LK
  WHERE  LK.LOOKUP_TYPE = 'GMO_TRANSACTION_TYPES'
  AND    LK.LOOKUP_CODE = P_TRANSACTION_TYPE;

Line: 106

  SELECT DOC_TYPE
  FROM   GMO_DOCUMENT_NUMBERS
  WHERE  ORGANIZATION_ID  = P_ORGANIZATION_ID
  AND    TRANSACTION_TYPE = P_TRANSACTION_TYPE;

Line: 113

  SELECT DOC_TYPE
  FROM   GMO_DOCUMENT_NUMBERS
  WHERE  ORGANIZATION_ID IS NULL
  AND    TRANSACTION_TYPE = P_TRANSACTION_TYPE;

Line: 335

  SELECT DOC_TYPE,
         DOC_ZERO_PAD,
         DOC_START,
         DOC_CURRENTVAL,
         DOC_INCREMENT,
         DOC_LENGTH,
         DOC_PREFIX,
         DOC_SUFFIX,
         DOC_SEPARATOR
  FROM   GMO_DOCUMENT_NUMBERS
  WHERE  ORGANIZATION_ID  = P_ORGANIZATION_ID
  AND    TRANSACTION_TYPE = P_TRANSACTION_TYPE;

Line: 351

  SELECT DOC_TYPE,
         DOC_ZERO_PAD,
         DOC_START,
         DOC_CURRENTVAL,
         DOC_INCREMENT,
         DOC_LENGTH,
         DOC_PREFIX,
         DOC_SUFFIX,
         DOC_SEPARATOR
  FROM   GMO_DOCUMENT_NUMBERS
  WHERE  ORGANIZATION_ID IS NULL
  AND    TRANSACTION_TYPE = P_TRANSACTION_TYPE;

Line: 558

      UPDATE GMO_DOCUMENT_NUMBERS
      SET    DOC_CURRENTVAL    = L_NEXTVAL,
             LAST_UPDATE_DATE  = SYSDATE,
             LAST_UPDATED_BY   = FND_GLOBAL.USER_ID,
             LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
      WHERE  ORGANIZATION_ID  = P_ORGANIZATION_ID
      AND    TRANSACTION_TYPE = P_TRANSACTION_TYPE;

Line: 568

      UPDATE GMO_DOCUMENT_NUMBERS
      SET    DOC_CURRENTVAL    = L_NEXTVAL,
             LAST_UPDATE_DATE  = SYSDATE,
             LAST_UPDATED_BY   = FND_GLOBAL.USER_ID,
             LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
      WHERE  ORGANIZATION_ID  IS NULL
      AND    TRANSACTION_TYPE = P_TRANSACTION_TYPE;

Line: 750

    SELECT COUNT(*) INTO L_COUNT
    FROM   GMO_DOCUMENT_NUMBERS
    WHERE  ORGANIZATION_ID IS NULL
    AND    TRANSACTION_TYPE = P_TRANSACTION_TYPE;

Line: 757

    SELECT COUNT(*) INTO L_COUNT
    FROM   GMO_DOCUMENT_NUMBERS
    WHERE  ORGANIZATION_ID = P_ORGANIZATION_ID
    AND    TRANSACTION_TYPE = P_TRANSACTION_TYPE;