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

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

Line: 231


    l_last_updated_by        OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;

Line: 232


    l_last_update_login      OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line: 233


    l_last_update_date       OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;

Line: 243


    SAVEPOINT g_insert_row_GRP;

Line: 269


    OKC_TEMPLATE_USAGES_PVT.Insert_Row(
      p_validation_level           =>   p_validation_level,
      x_return_status              =>   x_return_status,
      p_document_type          => p_document_type,
      p_document_id            => p_document_id,
      p_template_id            => p_template_id,
      p_doc_numbering_scheme   => p_doc_numbering_scheme,
      p_document_number        => p_document_number,
      p_article_effective_date => p_article_effective_date,
      p_config_header_id       => p_config_header_id,
      p_config_revision_number => p_config_revision_number,
      p_valid_config_yn        => p_valid_config_yn,
      p_orig_system_reference_code => p_orig_system_reference_code,
      p_orig_system_reference_id1 => p_orig_system_reference_id1,
      p_orig_system_reference_id2 => p_orig_system_reference_id2,
      x_document_type          => x_document_type,
      x_document_id            => x_document_id,

      p_approval_abstract_text => p_approval_abstract_text,
      p_contract_source_code   => p_contract_source_code ,
      p_authoring_party_code   => l_authoring_party_code ,
      p_autogen_deviations_flag => p_autogen_deviations_flag,
	 --Fix for bug# 3990983
	 p_source_change_allowed_flag => p_source_change_allowed_flag,
	 p_lock_terms_flag => p_lock_terms_flag,
	 p_enable_reporting_flag => p_enable_reporting_flag,
	 p_contract_admin_id => p_contract_admin_id,
	 p_legal_contact_id => p_legal_contact_id,
     p_locked_by_user_id => p_locked_by_user_id
    );

Line: 323


      ROLLBACK TO g_insert_row_GRP;

Line: 329


         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving insert_row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line: 331


      ROLLBACK TO g_insert_row_GRP;

Line: 337


        FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving insert_row because of EXCEPTION: '||sqlerrm);

Line: 340


      ROLLBACK TO g_insert_row_GRP;

Line: 441


  PROCEDURE update_template_usages(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    p_validation_level             IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    p_commit                       IN VARCHAR2 := FND_API.G_FALSE,

    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,

    p_document_type          IN VARCHAR2,
    p_document_id            IN NUMBER,
    p_template_id            IN NUMBER := NULL,
    p_doc_numbering_scheme   IN NUMBER := NULL,
    p_document_number        IN VARCHAR2 := NULL,
    p_article_effective_date IN DATE := NULL,
    p_config_header_id       IN NUMBER := NULL,
    p_config_revision_number IN NUMBER := NULL,
    p_valid_config_yn        IN VARCHAR2 := NULL,
    p_orig_system_reference_code IN VARCHAR2 := NULL,
    p_orig_system_reference_id1 IN NUMBER := NULL,
    p_orig_system_reference_id2 IN NUMBER := NULL,

    p_approval_abstract_text  IN CLOB := NULL,
    p_contract_source_code    IN VARCHAR2 := NULL,
    p_authoring_party_code    IN VARCHAR2 := NULL,
    p_autogen_deviations_flag IN VARCHAR2 := NULL,
    -- Fix for bug# 3990983
    p_source_change_allowed_flag IN VARCHAR2 := NULL,

    p_object_version_number  IN NUMBER := NULL,
    p_lock_terms_flag        IN VARCHAR2 := NULL,
    p_enable_reporting_flag  IN VARCHAR2 := NULL,
    p_contract_admin_id      IN NUMBER := NULL,
    p_legal_contact_id       IN NUMBER := NULL,
    p_locked_by_user_id       IN NUMBER := NULL

   ) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 481


    l_api_name                     CONSTANT VARCHAR2(30) := 'g_update_template_usages';

Line: 486


       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Entered update_template_usages');

Line: 491


    SAVEPOINT g_update_row_GRP;

Line: 506


    OKC_TEMPLATE_USAGES_PVT.Update_Row(
      p_validation_level           => p_validation_level,
      x_return_status              => x_return_status,
      p_document_type          => p_document_type,
      p_document_id            => p_document_id,
      p_template_id            => p_template_id,
      p_doc_numbering_scheme   => p_doc_numbering_scheme,
      p_document_number        => p_document_number,
      p_article_effective_date => p_article_effective_date,
      p_config_header_id       => p_config_header_id,
      p_config_revision_number => p_config_revision_number,
      p_valid_config_yn        => p_valid_config_yn,
      p_orig_system_reference_code => p_orig_system_reference_code,
      p_orig_system_reference_id1 => p_orig_system_reference_id1,
      p_orig_system_reference_id2 => p_orig_system_reference_id2,
      p_object_version_number  => p_object_version_number,
      p_contract_source_code   => p_contract_source_code,
      p_authoring_party_code   => p_authoring_party_code,
      p_autogen_deviations_flag => p_autogen_deviations_flag,
	 -- Fix for bug# 3990983
	 p_source_change_allowed_flag => p_source_change_allowed_flag,
 	 p_lock_terms_flag => p_lock_terms_flag,
	 p_enable_reporting_flag => p_enable_reporting_flag,
	 p_contract_admin_id => p_contract_admin_id,
	 p_legal_contact_id => p_legal_contact_id,
     p_locked_by_user_id => p_locked_by_user_id
    );

Line: 549


      FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Leaving update_template_usages');

Line: 555


         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1900: Leaving update_template_usages: OKC_API.G_EXCEPTION_ERROR Exception');

Line: 557


      ROLLBACK TO g_update_row_GRP;

Line: 563


         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving update_template_usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line: 565


      ROLLBACK TO g_update_row_GRP;

Line: 571


        FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2100: Leaving update_template_usages because of EXCEPTION: '||sqlerrm);

Line: 574


      ROLLBACK TO g_update_row_GRP;

Line: 581


  END update_template_usages;

Line: 586


  PROCEDURE delete_template_usages(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    p_commit                       IN VARCHAR2 := FND_API.G_FALSE,

    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,

    p_document_type          IN VARCHAR2,
    p_document_id            IN NUMBER,
    p_object_version_number  IN NUMBER
  ) IS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 600


    l_api_name                     CONSTANT VARCHAR2(30) := 'g_delete_template_usages';

Line: 604


       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: Entered delete_template_usages');

Line: 608


    SAVEPOINT g_delete_row_GRP;

Line: 623


    OKC_TEMPLATE_USAGES_PVT.Delete_Row(
      x_return_status              =>   x_return_status,
      p_document_type          => p_document_type,
      p_document_id            => p_document_id,
      p_object_version_number  => p_object_version_number
    );

Line: 645


       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving delete_template_usages');

Line: 651


         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving delete_template_usages: OKC_API.G_EXCEPTION_ERROR Exception');

Line: 653


      ROLLBACK TO g_delete_row_GRP;

Line: 659


         FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving delete_template_usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line: 661


      ROLLBACK TO g_delete_row_GRP;

Line: 667


        FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving delete_template_usages because of EXCEPTION: '||sqlerrm);

Line: 670


      ROLLBACK TO g_delete_row_GRP;

Line: 677


  END delete_template_usages;

Line: 705


     SELECT 'Y'
     FROM  OKC_TEMPLATE_USAGES
     WHERE document_id = p_document_id
     AND   document_type = p_document_type;

Line: 711


      SELECT contract_source_code,
             authoring_party_code
      FROM OKC_TEMPLATE_USAGES
      WHERE document_type = p_document_type
            AND document_id = p_document_id;

Line: 786


       OKC_TEMPLATE_USAGES_PVT.update_row(
                  x_return_status          => x_return_status ,

                  p_document_type          => p_document_type ,
                  p_document_id            => p_document_id ,
                  p_authoring_party_code   => p_authoring_party_code,
                  p_contract_source_code   => p_contract_source_code,
		  p_document_number        => p_document_number);

Line: 797


       OKC_TEMPLATE_USAGES_PVT.insert_row(
                  x_return_status          =>  x_return_status,

                  p_document_type          =>  p_document_type ,
                  p_document_id            =>  p_document_id ,
                  p_template_id            =>  null,
                  p_doc_numbering_scheme   =>  null,
                  p_document_number        =>  p_document_number,
                  p_article_effective_date =>  null,
                  p_config_header_id       =>  null,
                  p_config_revision_number =>  null,
                  p_valid_config_yn        =>  null,
                  p_authoring_party_code   =>  p_authoring_party_code,
                  p_contract_source_code   =>  p_contract_source_code,

                  x_document_type          =>  l_document_type,
                  x_document_id            =>  l_document_id );

Line: 899


     SELECT 'Y'
     FROM  OKC_TEMPLATE_USAGES
     WHERE document_id = p_document_id
     AND   document_type = p_document_type;

Line: 905


      SELECT contract_source_code,
             authoring_party_code
      FROM OKC_TEMPLATE_USAGES
      WHERE document_type = p_document_type
            AND document_id = p_document_id;

Line: 971


       OKC_TEMPLATE_USAGES_PVT.update_row(
                  x_return_status          => x_return_status ,

                  p_document_type          => p_document_type ,
                  p_document_id            => p_document_id ,
                  p_authoring_party_code   => p_authoring_party_code,
                  p_contract_source_code   => p_contract_source_code,
		          p_document_number        => p_document_number,
                  p_enable_reporting_flag  => p_enable_reporting_flag,
                  p_contract_admin_id      => p_contract_admin_id,
                  p_legal_contact_id       => p_legal_contact_id
        );

Line: 999


       OKC_TEMPLATE_USAGES_PVT.insert_row(
                  x_return_status          =>  x_return_status,

                  p_document_type          =>  p_document_type ,
                  p_document_id            =>  p_document_id ,
                  p_template_id            =>  null,
                  p_doc_numbering_scheme   =>  null,
                  p_document_number        =>  p_document_number,
                  p_article_effective_date =>  null,
                  p_config_header_id       =>  null,
                  p_config_revision_number =>  null,
                  p_valid_config_yn        =>  null,
                  p_authoring_party_code   =>  p_authoring_party_code,
                  p_contract_source_code   =>  p_contract_source_code,
                  p_enable_reporting_flag  => p_enable_reporting_flag,
                  p_contract_admin_id      => l_contract_admin_id,
                  p_legal_contact_id       => l_legal_contact_id,

                  x_document_type          =>  l_document_type,
                  x_document_id            =>  l_document_id );