The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
SAVEPOINT g_insert_row_GRP;
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_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
);
ROLLBACK TO g_insert_row_GRP;
ROLLBACK TO g_insert_row_GRP;
ROLLBACK TO g_insert_row_GRP;
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_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;
l_api_name CONSTANT VARCHAR2(30) := 'g_update_template';
FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Entered update_template');
SAVEPOINT g_update_row_GRP;
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_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
);
FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Leaving update_template');
FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1900: Leaving update_template: OKC_API.G_EXCEPTION_ERROR Exception');
ROLLBACK TO g_update_row_GRP;
FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving update_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
ROLLBACK TO g_update_row_GRP;
FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2100: Leaving update_template because of EXCEPTION: '||sqlerrm);
ROLLBACK TO g_update_row_GRP;
END update_template;
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;
l_api_name CONSTANT VARCHAR2(30) := 'g_delete_template';
FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: Entered delete_template');
SAVEPOINT g_delete_row_GRP;
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
);
FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving delete_template');
FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving delete_template: OKC_API.G_EXCEPTION_ERROR Exception');
ROLLBACK TO g_delete_row_GRP;
FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving delete_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
ROLLBACK TO g_delete_row_GRP;
FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving delete_template because of EXCEPTION: '||sqlerrm);
ROLLBACK TO g_delete_row_GRP;
END delete_template;