APPS.FND_SEQ_CATEGORIES_PKG SQL Statements

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

Line: 14

	SELECT  'Duplicate'
	FROM    fnd_doc_sequence_categories fcat
	WHERE   fcat.code = x_category_code
	AND     fcat.application_id = x_applicatio_id;

Line: 62

    PROCEDURE insert_cat( x_application_id         NUMBER,
			  x_category_code          VARCHAR2,
                          x_category_name          VARCHAR2,
                          x_description            VARCHAR2,
			  x_table_name	           VARCHAR2,
                          x_last_updated_by        NUMBER,
                          x_created_by             NUMBER,
                          x_last_update_login      NUMBER ) IS

    BEGIN
    IF (is_dublicate_cat(x_application_id,x_category_code)=0) THEN
      INSERT INTO fnd_doc_sequence_categories (
             application_id, last_update_date, last_updated_by,
             code, name, description,
             table_name, created_by, creation_date,
             last_update_login )
      SELECT x_application_id, sysdate, x_last_updated_by,
             x_category_code, x_category_name, x_description,
             x_table_name, x_created_by, sysdate,
             x_last_update_login
      FROM   sys.dual;

Line: 92

		'FND_SEQ_CATEGORIES_PKG.insert_cat');

Line: 97

    END insert_cat;

Line: 100

    PROCEDURE update_cat(  x_application_id         NUMBER,
			   x_category_code          VARCHAR2,
			   x_category_name          VARCHAR2,
                           x_description            VARCHAR2,
                           x_last_updated_by        NUMBER )  IS
    cat FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;

Line: 109

      UPDATE  fnd_doc_sequence_categories fcat
      SET     fcat.name = x_category_name,
              fcat.description = x_description,
              fcat.last_update_date = sysdate,
              fcat.last_updated_by = x_last_updated_by
      WHERE   fcat.application_id = x_application_id
      AND     fcat.code = x_category_code;

Line: 124

		'FND_SEQ_CATEGORIES_PKG.update_cat');

Line: 128

    END update_cat;