eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DOC_SEQ_CTG_S SQL Statements

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

Line: 49


  SELECT
    doc_sequence_category_id
  FROM
    wsh_doc_sequence_categories
  WHERE ((p_rowid IS NULL) OR (p_rowid <> rowid))
    AND document_type = p_document_type
    AND NVL(enabled_flag,'N') = 'Y'
    AND NVL(p_enabled_flag,'N') = 'Y'
    AND ((location_id = p_location_id AND document_code = p_document_code)
         OR
         (location_id = p_location_id AND document_code IS NULL)
	    OR
	    (location_id = p_location_id AND document_code IS NOT NULL
            AND p_document_code IS NULL)
         OR
	    (document_code = p_document_code AND location_id IS NOT NULL
	       AND (nvl(p_location_id,-99) = -99) )
         OR
	    ((nvl(location_id,-99) = -99) AND document_code = p_document_code)
         OR
         ((nvl(location_id,-99) = -99) AND document_code IS NULL)
	    OR
	    ((nvl(p_location_id,-99) = -99) AND p_document_code IS NULL));

Line: 123


PROCEDURE insert_row
  ( x_rowid                       IN OUT NOCOPY  VARCHAR2
  , x_doc_sequence_category_id    NUMBER
  , x_location_id                 NUMBER
  , x_document_type               VARCHAR2
  , x_document_code               VARCHAR2
  , x_application_id              VARCHAR2
  , x_category_code               VARCHAR2
  , x_name                        VARCHAR2
  , x_description                 VARCHAR2
  , x_prefix                      VARCHAR2
  , x_suffix                      VARCHAR2
  , x_delimiter                   VARCHAR2
  , x_enabled_flag                VARCHAR2
  , x_created_by                  NUMBER
  , x_creation_date               DATE
  , x_last_updated_by             NUMBER
  , x_last_update_date            DATE
  , x_last_update_login           NUMBER
  , x_program_application_id      NUMBER
  , x_program_id                  NUMBER
  , x_program_update_date         DATE
  , x_request_id                  NUMBER
  , x_attribute_category          VARCHAR2
  , x_attribute1                  VARCHAR2
  , x_attribute2                  VARCHAR2
  , x_attribute3                  VARCHAR2
  , x_attribute4                  VARCHAR2
  , x_attribute5                  VARCHAR2
  , x_attribute6                  VARCHAR2
  , x_attribute7                  VARCHAR2
  , x_attribute8                  VARCHAR2
  , x_attribute9                  VARCHAR2
  , x_attribute10                 VARCHAR2
  , x_attribute11                 VARCHAR2
  , x_attribute12                 VARCHAR2
  , x_attribute13                 VARCHAR2
  , x_attribute14                 VARCHAR2
  , x_attribute15                 VARCHAR2
)
IS

  -- cursor to check successful insert of the row based on primary key
  CURSOR insert_csr (p_doc_sequence_category_id NUMBER) IS
  SELECT
    rowid
  FROM
    wsh_doc_sequence_categories
  WHERE doc_sequence_category_id = p_doc_sequence_category_id;

Line: 175


  SELECT wsh_doc_sequence_categories_s.nextval
  FROM dual;

Line: 180


  SELECT wsh_doc_categories_s.nextval category_code
  FROM dual;

Line: 190


l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_ROW';

Line: 230


        WSH_DEBUG_SV.log(l_module_name,'X_LAST_UPDATED_BY',X_LAST_UPDATED_BY);

Line: 231


        WSH_DEBUG_SV.log(l_module_name,'X_LAST_UPDATE_DATE',X_LAST_UPDATE_DATE);

Line: 232


        WSH_DEBUG_SV.log(l_module_name,'X_LAST_UPDATE_LOGIN',X_LAST_UPDATE_LOGIN);

Line: 235


        WSH_DEBUG_SV.log(l_module_name,'X_PROGRAM_UPDATE_DATE',X_PROGRAM_UPDATE_DATE);

Line: 303


  INSERT INTO wsh_doc_sequence_categories
  ( doc_sequence_category_id
  , location_id
  , document_type
  , document_code
  , application_id
  , category_code
  , prefix
  , suffix
  , delimiter
  , enabled_flag
  , created_by
  , creation_date
  , last_updated_by
  , last_update_date
  , last_update_login
  , program_application_id
  , program_id
  , program_update_date
  , request_id
  , attribute_category
  , attribute1
  , attribute2
  , attribute3
  , attribute4
  , attribute5
  , attribute6
  , attribute7
  , attribute8
  , attribute9
  , attribute10
  , attribute11
  , attribute12
  , attribute13
  , attribute14
  , attribute15
  ) VALUES (
    l_doc_sequence_category_id
  , x_location_id
  , x_document_type
  , x_document_code
  , x_application_id
  , l_category_code
  , x_prefix
  , x_suffix
  , x_delimiter
  , x_enabled_flag
  , x_created_by
  , x_creation_date
  , x_last_updated_by
  , x_last_update_date
  , x_last_update_login
  , x_program_application_id
  , x_program_id
  , x_program_update_date
  , x_request_id
  , x_attribute_category
  , x_attribute1
  , x_attribute2
  , x_attribute3
  , x_attribute4
  , x_attribute5
  , x_attribute6
  , x_attribute7
  , x_attribute8
  , x_attribute9
  , x_attribute10
  , x_attribute11
  , x_attribute12
  , x_attribute13
  , x_attribute14
  , x_attribute15 );

Line: 376


  OPEN insert_csr (l_doc_sequence_category_id);

Line: 377


  FETCH insert_csr INTO x_rowid;

Line: 378


  IF insert_csr%NOTFOUND
  THEN
    CLOSE insert_csr;

Line: 384


  CLOSE insert_csr;

Line: 399


  FND_SEQ_CATEGORIES_PKG.insert_cat
    ( x_application_id    => x_application_id
    , x_category_code     => l_category_code
    , x_category_name     => x_name
    , x_description       => x_description
    , x_table_name        => 'WSH_DOCUMENT_INSTANCES'
    , x_last_updated_by   => x_last_updated_by
    , x_created_by        => x_created_by
    , x_last_update_login => x_last_update_login
    );

Line: 429


END insert_row;

Line: 431


PROCEDURE update_row
  ( x_rowid                       VARCHAR2
  , x_doc_sequence_category_id    NUMBER
  , x_location_id                 NUMBER
  , x_document_type               VARCHAR2
  , x_document_code               VARCHAR2
  , x_application_id              VARCHAR2
  , x_category_code               VARCHAR2
  , x_name                        VARCHAR2
  , x_description                 VARCHAR2
  , x_prefix                      VARCHAR2
  , x_suffix                      VARCHAR2
  , x_delimiter                   VARCHAR2
  , x_enabled_flag                VARCHAR2
  , x_created_by                  NUMBER
  , x_creation_date               DATE
  , x_last_updated_by             NUMBER
  , x_last_update_date            DATE
  , x_last_update_login           NUMBER
  , x_program_application_id      NUMBER
  , x_program_id                  NUMBER
  , x_program_update_date         DATE
  , x_request_id                  NUMBER
  , x_attribute_category          VARCHAR2
  , x_attribute1                  VARCHAR2
  , x_attribute2                  VARCHAR2
  , x_attribute3                  VARCHAR2
  , x_attribute4                  VARCHAR2
  , x_attribute5                  VARCHAR2
  , x_attribute6                  VARCHAR2
  , x_attribute7                  VARCHAR2
  , x_attribute8                  VARCHAR2
  , x_attribute9                  VARCHAR2
  , x_attribute10                 VARCHAR2
  , x_attribute11                 VARCHAR2
  , x_attribute12                 VARCHAR2
  , x_attribute13                 VARCHAR2
  , x_attribute14                 VARCHAR2
  , x_attribute15                 VARCHAR2
)
IS
--
l_debug_on BOOLEAN;

Line: 475


l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ROW';

Line: 515


        WSH_DEBUG_SV.log(l_module_name,'X_LAST_UPDATED_BY',X_LAST_UPDATED_BY);

Line: 516


        WSH_DEBUG_SV.log(l_module_name,'X_LAST_UPDATE_DATE',X_LAST_UPDATE_DATE);

Line: 517


        WSH_DEBUG_SV.log(l_module_name,'X_LAST_UPDATE_LOGIN',X_LAST_UPDATE_LOGIN);

Line: 520


        WSH_DEBUG_SV.log(l_module_name,'X_PROGRAM_UPDATE_DATE',X_PROGRAM_UPDATE_DATE);

Line: 550


  UPDATE wsh_doc_sequence_categories SET
    doc_sequence_category_id = x_doc_sequence_category_id
  , location_id = x_location_id
  , document_type = x_document_type
  , document_code = x_document_code
  , application_id = x_application_id
  , category_code = x_category_code
  , prefix = x_prefix
  , suffix = x_suffix
  , delimiter = x_delimiter
  , enabled_flag = x_enabled_flag
  , created_by = x_created_by
  , creation_date = x_creation_date
  , last_updated_by = x_last_updated_by
  , last_update_date = x_last_update_date
  , last_update_login = x_last_update_login
  , program_application_id = x_program_application_id
  , program_id = x_program_id
  , program_update_date  = x_program_update_date
  , request_id = x_request_id
  , attribute_category = x_attribute_category
  , attribute1 = x_attribute1
  , attribute2 = x_attribute2
  , attribute3 = x_attribute3
  , attribute4 = x_attribute4
  , attribute5 = x_attribute5
  , attribute6 = x_attribute6
  , attribute7 = x_attribute7
  , attribute8 = x_attribute8
  , attribute9 = x_attribute9
  , attribute10 = x_attribute10
  , attribute11 = x_attribute11
  , attribute12 = x_attribute12
  , attribute13 = x_attribute13
  , attribute14 = x_attribute14
  , attribute15 = x_attribute15
  WHERE rowid = x_rowid;

Line: 609


  FND_SEQ_CATEGORIES_PKG.update_cat
    ( x_application_id
    , x_category_code
    , x_name
    , x_description
    , x_last_updated_by
    );

Line: 636


END update_row;

Line: 653


  , x_last_updated_by             NUMBER
  , x_last_update_date            DATE
  , x_last_update_login           NUMBER
  , x_program_application_id      NUMBER
  , x_program_id                  NUMBER
  , x_program_update_date         DATE
  , x_request_id                  NUMBER
  , x_attribute_category          VARCHAR2
  , x_attribute1                  VARCHAR2
  , x_attribute2                  VARCHAR2
  , x_attribute3                  VARCHAR2
  , x_attribute4                  VARCHAR2
  , x_attribute5                  VARCHAR2
  , x_attribute6                  VARCHAR2
  , x_attribute7                  VARCHAR2
  , x_attribute8                  VARCHAR2
  , x_attribute9                  VARCHAR2
  , x_attribute10                 VARCHAR2
  , x_attribute11                 VARCHAR2
  , x_attribute12                 VARCHAR2
  , x_attribute13                 VARCHAR2
  , x_attribute14                 VARCHAR2
  , x_attribute15                 VARCHAR2
)
IS
  counter NUMBER;

Line: 680


    SELECT
      doc_sequence_category_id
    , location_id
    , document_type
    , document_code
    , application_id
    , category_code
    , prefix
    , suffix
    , delimiter
    , enabled_flag
    , created_by
    , creation_date
    , last_updated_by
    , last_update_date
    , last_update_login
    , program_application_id
    , program_id
    , program_update_date
    , request_id
    , attribute_category
    , attribute1
    , attribute2
    , attribute3
    , attribute4
    , attribute5
    , attribute6
    , attribute7
    , attribute8
    , attribute9
    , attribute10
    , attribute11
    , attribute12
    , attribute13
    , attribute14
    , attribute15
    FROM
      wsh_doc_sequence_categories
    WHERE rowid = x_rowid
    FOR UPDATE OF doc_sequence_category_id NOWAIT;

Line: 754


      WSH_DEBUG_SV.log(l_module_name,'X_LAST_UPDATED_BY',X_LAST_UPDATED_BY);

Line: 755


      WSH_DEBUG_SV.log(l_module_name,'X_LAST_UPDATE_DATE',X_LAST_UPDATE_DATE);

Line: 756


      WSH_DEBUG_SV.log(l_module_name,'X_LAST_UPDATE_LOGIN',X_LAST_UPDATE_LOGIN);

Line: 759


      WSH_DEBUG_SV.log(l_module_name,'X_PROGRAM_UPDATE_DATE',X_PROGRAM_UPDATE_DATE);

Line: 784


    FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');

Line: 795


    AND lock_rec.last_updated_by = x_last_updated_by
    AND lock_rec.last_update_date = x_last_update_date
    -- verify the nullable columns are either identical or both null
    AND ((lock_rec.document_code = x_document_code)
	OR
	(lock_rec.document_code IS NULL AND x_document_code IS NULL))
    AND ((lock_rec.location_id = x_location_id)
	OR
	(lock_rec.location_id IS NULL AND x_location_id IS NULL))
    AND ((lock_rec.prefix = x_prefix)
        OR
        (lock_rec.prefix IS NULL AND x_prefix IS NULL))
    AND ((lock_rec.suffix = x_suffix)
        OR
        (lock_rec.suffix IS NULL AND x_suffix IS NULL))
    AND ((lock_rec.delimiter = x_delimiter)
        OR
        (lock_rec.delimiter IS NULL AND x_delimiter IS NULL))
    AND ((lock_rec.enabled_flag = x_enabled_flag)
        OR
        (lock_rec.enabled_flag IS NULL AND x_enabled_flag IS NULL))
    AND ((lock_rec.last_update_login = x_last_update_login)
        OR
        (lock_rec.last_update_login IS NULL AND x_last_update_login IS NULL))
    AND ((lock_rec.program_application_id = x_program_application_id)
        OR
        (lock_rec.program_application_id IS NULL
                                     AND x_program_application_id IS NULL))
    AND ((lock_rec.program_id = x_program_id)
        OR
        (lock_rec.program_id IS NULL AND x_program_id IS NULL))
    AND ((lock_rec.request_id = x_request_id)
        OR
        (lock_rec.request_id IS NULL AND x_request_id IS NULL))
    AND ((lock_rec.attribute_category = x_attribute_category)
        OR
        (lock_rec.attribute_category IS NULL AND x_attribute_category IS NULL))
    AND ((lock_rec.attribute1 = x_attribute1)
        OR
        (lock_rec.attribute1 IS NULL AND x_attribute1 IS NULL))
    AND ((lock_rec.attribute2 = x_attribute2)
        OR
        (lock_rec.attribute2 IS NULL AND x_attribute2 IS NULL))
    AND ((lock_rec.attribute3 = x_attribute3)
        OR
        (lock_rec.attribute3 IS NULL AND x_attribute3 IS NULL))
    AND ((lock_rec.attribute4 = x_attribute4)
        OR
        (lock_rec.attribute4 IS NULL AND x_attribute4 IS NULL))
    AND ((lock_rec.attribute5 = x_attribute5)
        OR
        (lock_rec.attribute5 IS NULL AND x_attribute5 IS NULL))
    AND ((lock_rec.attribute6 = x_attribute6)
        OR
        (lock_rec.attribute6 IS NULL AND x_attribute6 IS NULL))
    AND ((lock_rec.attribute7 = x_attribute7)
        OR
        (lock_rec.attribute7 IS NULL AND x_attribute7 IS NULL))
    AND ((lock_rec.attribute8 = x_attribute8)
        OR
        (lock_rec.attribute8 IS NULL AND x_attribute8 IS NULL))
    AND ((lock_rec.attribute9 = x_attribute9)
        OR
        (lock_rec.attribute9 IS NULL AND x_attribute9 IS NULL))
    AND ((lock_rec.attribute10 = x_attribute10)
        OR
        (lock_rec.attribute10 IS NULL AND x_attribute10 IS NULL))
    AND ((lock_rec.attribute11 = x_attribute11)
        OR
        (lock_rec.attribute11 IS NULL AND x_attribute11 IS NULL))
    AND ((lock_rec.attribute12 = x_attribute12)
        OR
        (lock_rec.attribute12 IS NULL AND x_attribute12 IS NULL))
    AND ((lock_rec.attribute13 = x_attribute13)
        OR
        (lock_rec.attribute13 IS NULL AND x_attribute13 IS NULL))
    AND ((lock_rec.attribute14 = x_attribute14)
        OR
        (lock_rec.attribute14 IS NULL AND x_attribute14 IS NULL))
    AND ((lock_rec.attribute15 = x_attribute15)
        OR
        (lock_rec.attribute15 IS NULL AND x_attribute15 IS NULL))
  )
  THEN
    --
    -- Debug Statements
    --
    IF l_debug_on THEN
        WSH_DEBUG_SV.pop(l_module_name);

Line: 900


PROCEDURE delete_row ( x_rowid VARCHAR2 )
IS
--
l_debug_on BOOLEAN;

Line: 905


l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_ROW';

Line: 935


END delete_row;