APPS.PON_CONTRACTS_TL_PKG SQL Statements

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

Line: 7

    INSERT INTO PON_CONTRACTS_TL (
      CONTRACT_ID,
      VERSION_NUM,
      TITLE,
      ABSTRACT,
      BODY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      language,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      source_lang
    )
    SELECT
      cont.CONTRACT_ID,
      cont.VERSION_NUM,
      cont.TITLE,
      cont.ABSTRACT,
      cont.BODY,
      cont.ATTRIBUTE1,
      cont.ATTRIBUTE2,
      cont.ATTRIBUTE3,
      cont.ATTRIBUTE4,
      cont.ATTRIBUTE5,
      lang.language_code,
      cont.created_by,
      SYSDATE,
      cont.last_updated_by,
      SYSDATE,
      cont.source_lang
    FROM pon_contracts_tl cont,
         fnd_languages lang
    WHERE cont.language = USERENV('LANG')
    AND lang.INSTALLED_FLAG in ('I', 'B')
    AND NOT EXISTS (SELECT NULL
                      FROM pon_contracts_tl cont2
                     WHERE cont2.contract_id = cont.contract_id
                     and cont2.version_num = cont.version_num
                       AND cont2.language   = lang.language_code);

Line: 62

Select language_code
from fnd_languages_vl
where installed_flag in ('I','B');

Line: 70

           FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
        ( x_entity_name             => 'entity_name',
          x_pk1_value               => pk1,
          x_pk2_value               => pk3,
          x_pk3_value               => rec.language_code,
          x_pk4_value               => pk4,
          x_delete_document_flag    => 'Y'
        );

Line: 93

              X_last_update_login => fnd_global.user_id
              );