267: ) IS
268:
269: l_api_version CONSTANT NUMBER := 1;
270: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
271: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
272: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
273: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
268:
269: l_api_version CONSTANT NUMBER := 1;
270: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
271: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
272: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
273: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
269: l_api_version CONSTANT NUMBER := 1;
270: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
271: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
272: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
273: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
277: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
270: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
271: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
272: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
273: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
277: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
278:
271: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
272: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
273: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
277: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
278:
279: BEGIN
272: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
273: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
277: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
278:
279: BEGIN
280:
273: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
277: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
278:
279: BEGIN
280:
281: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
545: ) IS
546:
547: l_api_version CONSTANT NUMBER := 1;
548: l_api_name CONSTANT VARCHAR2(30) := 'g_update_template';
549: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
550:
551:
552: BEGIN
553: