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.PON_AUC_DOCTYPES_PKG SQL Statements

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

Line: 6


PROCEDURE insert_row (
     p_doctype_id                    IN  pon_auc_doctypes.doctype_id%TYPE
    ,p_internal_name                 IN  pon_auc_doctypes.internal_name%TYPE
    ,p_scope                         IN  pon_auc_doctypes.scope%TYPE
    ,p_status                        IN  pon_auc_doctypes.status%TYPE
    ,p_transaction_type              IN  pon_auc_doctypes.transaction_type%TYPE
    ,p_message_suffix                IN  pon_auc_doctypes.message_suffix%TYPE
    ,p_created_by                    IN  pon_auc_doctypes.created_by%TYPE
    ,p_creation_date                 IN  pon_auc_doctypes.creation_date%TYPE
    ,p_last_updated_by               IN  pon_auc_doctypes.last_updated_by%TYPE
    ,p_last_update_date              IN  pon_auc_doctypes.last_update_date%TYPE
    ,p_doctype_group_name            IN  pon_auc_doctypes.doctype_group_name%TYPE
    ,p_document_type_code            IN  pon_auc_doctypes.document_type_code%TYPE
    ,p_document_subtype              IN  pon_auc_doctypes.document_subtype%TYPE
    ,p_name                          IN  pon_auc_doctypes_tl.name%TYPE) IS
BEGIN


 INSERT INTO  pon_auc_doctypes
     ( doctype_id
      ,internal_name
      ,scope
      ,status
      ,transaction_type
      ,message_suffix
      ,created_by
      ,creation_date
      ,last_updated_by
      ,last_update_date
      ,doctype_group_name
      ,document_type_code
      ,document_subtype)
 VALUES
     ( p_doctype_id
      ,p_internal_name
      ,p_scope
      ,p_status
      ,p_transaction_type
      ,p_message_suffix
      ,p_created_by
      ,p_creation_date
      ,p_last_updated_by
      ,p_last_update_date
      ,p_doctype_group_name
      ,p_document_type_code
      ,p_document_subtype);

Line: 54


  INSERT INTO pon_auc_doctypes_tl doctl
      (doctype_id
      ,name
      ,language
      ,created_by
      ,creation_date
      ,last_updated_by
      ,last_update_date
      ,source_lang)
    SELECT
       p_doctype_id
      ,p_name
      ,l.language_code
      ,p_created_by
      ,p_creation_date
      ,p_last_updated_by
      ,p_last_update_date
      ,USERENV('LANG')
     FROM
       fnd_languages l
     WHERE installed_flag  in ('I', 'B')
       AND NOT EXISTS
         (SELECT NULL
	    FROM pon_auc_doctypes_tl doctl
	   WHERE doctl.doctype_id  = p_doctype_id
	     AND doctl.language    = l.language_code);

Line: 81


END insert_row;

Line: 83


PROCEDURE update_row (
    p_internal_name                 IN  pon_auc_doctypes.internal_name%TYPE,
    p_scope                         IN  pon_auc_doctypes.scope%TYPE,
    p_status                        IN  pon_auc_doctypes.status%TYPE,
    p_transaction_type              IN  pon_auc_doctypes.transaction_type%TYPE,
    p_message_suffix                IN  pon_auc_doctypes.message_suffix%TYPE,
    p_last_updated_by               IN  pon_auc_doctypes.last_updated_by%TYPE,
    p_last_update_date              IN  pon_auc_doctypes.last_update_date%TYPE,
    p_doctype_group_name            IN  pon_auc_doctypes.doctype_group_name%TYPE,
    p_document_type_code            IN  pon_auc_doctypes.document_type_code%TYPE,
    p_document_subtype              IN  pon_auc_doctypes.document_subtype%TYPE,
    p_name                          IN  pon_auc_doctypes_tl.name%TYPE) IS

BEGIN

   UPDATE pon_auc_doctypes doctl
      SET scope              = p_scope
         ,status             = p_status
         ,transaction_type   = p_transaction_type
         ,message_suffix     = p_message_suffix
         ,last_updated_by    = p_last_updated_by
         ,last_update_date   = p_last_update_date
         ,doctype_group_name = p_doctype_group_name
         ,document_type_code = p_document_type_code
         ,document_subtype   = p_document_subtype
     WHERE doctl.internal_name  = p_internal_name;

Line: 116


 UPDATE pon_auc_doctypes_tl doctl
    SET  doctl.name  =  p_name
       ,doctl.last_updated_by  =  p_last_updated_by
       ,doctl.last_update_date  =  p_last_update_date
       ,doctl.source_lang      = userenv('LANG')
  WHERE doctype_id  =  (
        SELECT doc.doctype_id
	  FROM pon_auc_doctypes doc
	 WHERE doc.internal_name = p_internal_name)
    AND USERENV('LANG') IN ( doctl.language, doctl.source_lang);

Line: 132


END update_row;

Line: 141


     p_last_update_date             IN  VARCHAR2
) IS

 f_luby    number;  -- entity owner in file

Line: 145


 f_ludate  date;    -- entity update date in file

Line: 147


 db_ludate date;    -- entity update date in db

Line: 154


 f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 156


 select LAST_UPDATED_BY, LAST_UPDATE_DATE
 into db_luby, db_ludate
 from pon_auc_doctypes_tl
 where doctype_id  =  (
          SELECT doc.doctype_id
            FROM pon_auc_doctypes doc
           WHERE doc.internal_name = p_internal_name)
   and userenv('LANG') = LANGUAGE;

Line: 165


   UPDATE pon_auc_doctypes_tl doctl
      SET  doctl.name              =  p_name
          ,doctl.last_updated_by   =  f_luby
          ,doctl.last_update_date  =  f_ludate
          ,source_lang             =  userenv('LANG')
    WHERE doctype_id  =  (
          SELECT doc.doctype_id
  	    FROM pon_auc_doctypes doc
  	   WHERE doc.internal_name = p_internal_name)
      AND USERENV('LANG') IN ( doctl.language, doctl.source_lang);

Line: 188


    p_last_update_date              IN  VARCHAR2,
    p_custom_mode                   IN  VARCHAR2, -- Custom mode can be FORCE
                                                  -- to force data to be uploaded
						  -- irrespective of current status
    p_scope                         IN  pon_auc_doctypes.scope%TYPE,
    p_status                        IN  pon_auc_doctypes.status%TYPE,
    p_transaction_type              IN  pon_auc_doctypes.transaction_type%TYPE,
    p_message_suffix                IN  pon_auc_doctypes.message_suffix%TYPE,
    p_doctype_group_name            IN  pon_auc_doctypes.doctype_group_name%TYPE,
    p_document_type_code            IN  pon_auc_doctypes.document_type_code%TYPE,
    p_document_subtype              IN  pon_auc_doctypes.document_subtype%TYPE,
    p_name                          IN  pon_auc_doctypes_tl.name%TYPE) IS


 -- Last update information from the file being uploaded
    l_f_last_updated_by                 pon_auc_doctypes.last_updated_by%TYPE;

Line: 204


    l_f_last_update_date                pon_auc_doctypes.last_update_date%TYPE;

Line: 207


    l_db_last_updated_by                pon_auc_doctypes.last_updated_by%TYPE;

Line: 208


    l_db_last_update_date               pon_auc_doctypes.last_update_date%TYPE;

Line: 215


    l_f_last_updated_by := fnd_load_util.OWNER_ID(p_owner);

Line: 218


    l_f_last_update_date := NVL(TO_DATE(p_last_update_date, 'YYYY/MM/DD'), SYSDATE);

Line: 220


 SELECT last_updated_by,
        last_update_date
   INTO l_db_last_updated_by,
        l_db_last_update_date
   FROM pon_auc_doctypes doc
  WHERE doc.internal_name = p_internal_name;

Line: 227


  update_row (
    p_internal_name         => p_internal_name,
    p_scope                 => p_scope,
    p_status                => p_status,
    p_transaction_type      => p_transaction_type,
    p_message_suffix        => p_message_suffix,
    p_last_updated_by       => l_f_last_updated_by,
    p_last_update_date      => l_f_last_update_date,
    p_doctype_group_name    => p_doctype_group_name,
    p_document_type_code    => p_document_type_code,
    p_document_subtype      => p_document_subtype,
    p_name                  => p_name);

Line: 248


  SELECT pon_auc_doctypes_s.NEXTVAL
    INTO l_doctype_id
    FROM dual;

Line: 252


  insert_row (
     p_doctype_id         => l_doctype_id
    ,p_internal_name      => p_internal_name
    ,p_scope              => p_scope
    ,p_status             => p_status
    ,p_transaction_type   => p_transaction_type
    ,p_message_suffix     => p_message_suffix
    ,p_created_by         => l_f_last_updated_by
    ,p_creation_date      => l_f_last_update_date
    ,p_last_updated_by    => l_f_last_updated_by
    ,p_last_update_date   => l_f_last_update_date
    ,p_doctype_group_name => p_doctype_group_name
    ,p_document_type_code => p_document_type_code
    ,p_document_subtype   => p_document_subtype
    ,p_name               => p_name);

Line: 270


PROCEDURE delete_row (
            p_internal_name   pon_auc_doctypes.internal_name%TYPE
	        ) IS

l_doctype_id  pon_auc_doctypes.doctype_id%TYPE;

Line: 278


 DELETE FROM pon_auc_doctypes doc
       WHERE doc.internal_name = p_internal_name
   RETURNING doctype_id
        INTO l_doctype_id;

Line: 288


 DELETE FROM pon_auc_doctypes_tl doctl
       WHERE doctl.doctype_id = l_doctype_id;

Line: 291


END delete_row;

Line: 298


    INSERT INTO PON_AUC_DOCTYPES_TL (
      doctype_id,
      name,
      language,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      source_lang
    )
    SELECT
      doctl.doctype_id,
      doctl.name,
      lang.language_code,
      doctl.created_by,
      doctl.creation_date,
      doctl.last_updated_by,
      doctl.last_update_date,
      doctl.source_lang
    FROM pon_auc_doctypes_tl doctl,
         fnd_languages lang
    WHERE doctl.language = USERENV('LANG')
    AND lang.INSTALLED_FLAG in ('I', 'B')
    AND NOT EXISTS (SELECT NULL
                      FROM PON_AUC_DOCTYPES_TL doc2
                     WHERE doc2.doctype_id = doctl.doctype_id
                       AND doc2.language   = lang.language_code);