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_TERMS_TEMPLATES_GRP SQL Statements

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

Line: 274


    l_last_updated_by         OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;

Line: 275


    l_last_update_login       OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;

Line: 276


    l_last_update_date        OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;

Line: 286


    SAVEPOINT g_insert_row_GRP;

Line: 301


    OKC_TERMS_TEMPLATES_PVT.Insert_Row(
      p_validation_level           =>   p_validation_level,
      x_return_status              =>   x_return_status,
      p_template_name           => p_template_name,
      p_template_id             => p_template_id,
      p_working_copy_flag       => p_working_copy_flag,
      p_intent                  => p_intent,
      p_status_code             => p_status_code,
      p_start_date              => p_start_date,
      p_end_date                => p_end_date,
      p_global_flag             => p_global_flag,
      p_parent_template_id      => p_parent_template_id,
      p_print_template_id       => p_print_template_id,
      p_contract_expert_enabled => p_contract_expert_enabled,
	 p_xprt_clause_mandatory_flag => p_xprt_clause_mandatory_flag, -- Added for 11.5.10+: Contract Expert Changes
	 p_xprt_scn_code           => p_xprt_scn_code, -- Added for 11.5.10+: Contract Expert Changes
      p_template_model_id       => p_template_model_id,
      p_instruction_text        => p_instruction_text,
      p_tmpl_numbering_scheme   => p_tmpl_numbering_scheme,
      p_description             => p_description,
      p_approval_wf_key         => p_approval_wf_key,
      p_cz_export_wf_key        => p_cz_export_wf_key,
      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_id1,
      p_org_id                  => p_org_id,
	  p_cls_enabled             => p_cls_enabled,
      p_attribute_category      => p_attribute_category,
      p_attribute1              => p_attribute1,
      p_attribute2              => p_attribute2,
      p_attribute3              => p_attribute3,
      p_attribute4              => p_attribute4,
      p_attribute5              => p_attribute5,
      p_attribute6              => p_attribute6,
      p_attribute7              => p_attribute7,
      p_attribute8              => p_attribute8,
      p_attribute9              => p_attribute9,
      p_attribute10             => p_attribute10,
      p_attribute11             => p_attribute11,
      p_attribute12             => p_attribute12,
      p_attribute13             => p_attribute13,
      p_attribute14             => p_attribute14,
      p_attribute15             => p_attribute15,
--MLS for templates
      p_translated_from_tmpl_id => p_translated_from_tmpl_id,
      p_language               	=> p_language,
      x_template_id             => x_template_id
    );

Line: 373


      ROLLBACK TO g_insert_row_GRP;

Line: 381


      ROLLBACK TO g_insert_row_GRP;

Line: 390


      ROLLBACK TO g_insert_row_GRP;

Line: 489


  PROCEDURE update_template(
    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_template_name           IN VARCHAR2,
    p_template_id             IN NUMBER,
    p_working_copy_flag       IN VARCHAR2,
    p_intent                  IN VARCHAR2,
    p_status_code             IN VARCHAR2,
    p_start_date              IN DATE,
    p_end_date                IN DATE,
    p_global_flag             IN VARCHAR2,
    p_parent_template_id      IN NUMBER,
    p_print_template_id       IN NUMBER,
    p_contract_expert_enabled IN VARCHAR2,
    p_xprt_clause_mandatory_flag IN VARCHAR2, -- Added for 11.5.10+: Contract Expert Changes
    p_xprt_scn_code           IN VARCHAR2, -- Added for 11.5.10+: Contract Expert Changes
    p_template_model_id       IN NUMBER,
    p_instruction_text        IN VARCHAR2,
    p_tmpl_numbering_scheme   IN NUMBER,
    p_description             IN VARCHAR2,
    p_approval_wf_key         IN VARCHAR2 := NULL,
    p_cz_export_wf_key        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_org_id                  IN NUMBER,
	p_cls_enabled             IN VARCHAR2 := 'N',

    p_attribute_category      IN VARCHAR2 := NULL,
    p_attribute1              IN VARCHAR2 := NULL,
    p_attribute2              IN VARCHAR2 := NULL,
    p_attribute3              IN VARCHAR2 := NULL,
    p_attribute4              IN VARCHAR2 := NULL,
    p_attribute5              IN VARCHAR2 := NULL,
    p_attribute6              IN VARCHAR2 := NULL,
    p_attribute7              IN VARCHAR2 := NULL,
    p_attribute8              IN VARCHAR2 := NULL,
    p_attribute9              IN VARCHAR2 := NULL,
    p_attribute10             IN VARCHAR2 := NULL,
    p_attribute11             IN VARCHAR2 := NULL,
    p_attribute12             IN VARCHAR2 := NULL,
    p_attribute13             IN VARCHAR2 := NULL,
    p_attribute14             IN VARCHAR2 := NULL,
    p_attribute15             IN VARCHAR2 := NULL,
    p_translated_from_tmpl_id IN NUMBER := NULL,
    p_language                IN VARCHAR2 := NULL,

    p_object_version_number   IN NUMBER

   ) IS

    l_api_version             CONSTANT NUMBER := 1;

Line: 548


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

Line: 555


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

Line: 560


    SAVEPOINT g_update_row_GRP;

Line: 575


    OKC_TERMS_TEMPLATES_PVT.Update_Row(
      p_validation_level           => p_validation_level,
      x_return_status              => x_return_status,
      p_template_name           => p_template_name,
      p_template_id             => p_template_id,
      p_working_copy_flag       => p_working_copy_flag,
      p_intent                  => p_intent,
      p_status_code             => p_status_code,
      p_start_date              => p_start_date,
      p_end_date                => p_end_date,
      p_global_flag             => p_global_flag,
      p_parent_template_id      => p_parent_template_id,
      p_print_template_id       => p_print_template_id,
      p_contract_expert_enabled => p_contract_expert_enabled,
      p_xprt_clause_mandatory_flag => p_xprt_clause_mandatory_flag, -- Added for 11.5.10+ : Contract Expert Changes
      p_xprt_scn_code           => p_xprt_scn_code, -- Added for 11.5.10+ : Contract Expert Changes
      p_template_model_id       => p_template_model_id,
      p_instruction_text        => p_instruction_text,
      p_tmpl_numbering_scheme   => p_tmpl_numbering_scheme,
      p_description             => p_description,
      p_approval_wf_key         => p_approval_wf_key,
      p_cz_export_wf_key        => p_cz_export_wf_key,
      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_id1,
      p_org_id                  => p_org_id,
	  p_cls_enabled             => p_cls_enabled,
      p_attribute_category      => p_attribute_category,
      p_attribute1              => p_attribute1,
      p_attribute2              => p_attribute2,
      p_attribute3              => p_attribute3,
      p_attribute4              => p_attribute4,
      p_attribute5              => p_attribute5,
      p_attribute6              => p_attribute6,
      p_attribute7              => p_attribute7,
      p_attribute8              => p_attribute8,
      p_attribute9              => p_attribute9,
      p_attribute10             => p_attribute10,
      p_attribute11             => p_attribute11,
      p_attribute12             => p_attribute12,
      p_attribute13             => p_attribute13,
      p_attribute14             => p_attribute14,
      p_attribute15             => p_attribute15,
--MLS for templates
      p_translated_from_tmpl_id => p_translated_from_tmpl_id,
      p_language               	=> p_language,
      p_object_version_number   => p_object_version_number
    );

Line: 640


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

Line: 646


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

Line: 648


      ROLLBACK TO g_update_row_GRP;

Line: 654


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

Line: 656


      ROLLBACK TO g_update_row_GRP;

Line: 662


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

Line: 665


      ROLLBACK TO g_update_row_GRP;

Line: 672


  END update_template;

Line: 677


  PROCEDURE delete_template(
    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_template_id             IN NUMBER,
    p_object_version_number   IN NUMBER
  ) IS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 690


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

Line: 694


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

Line: 698


    SAVEPOINT g_delete_row_GRP;

Line: 713


    OKC_TERMS_TEMPLATES_PVT.Delete_Row(
      x_return_status              =>   x_return_status,
      p_template_id             => p_template_id,
      p_object_version_number   => p_object_version_number
    );

Line: 734


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

Line: 740


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

Line: 742


      ROLLBACK TO g_delete_row_GRP;

Line: 748


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

Line: 750


      ROLLBACK TO g_delete_row_GRP;

Line: 756


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

Line: 759


      ROLLBACK TO g_delete_row_GRP;

Line: 766


  END delete_template;