DBA Data[Home] [Help]

APPS.OKC_TERMS_TEMPLATES_GRP dependencies on OKC_TERMS_TEMPLATES_ALL

Line 270: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;

266: ) IS
267:
268: l_api_version CONSTANT NUMBER := 1;
269: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
270: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
271: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
272: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
273: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
274: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;

Line 271: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;

267:
268: l_api_version CONSTANT NUMBER := 1;
269: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
270: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
271: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
272: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
273: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
274: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
275: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;

Line 272: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;

268: l_api_version CONSTANT NUMBER := 1;
269: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
270: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
271: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
272: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
273: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
274: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
275: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
276: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;

Line 273: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;

269: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_row';
270: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
271: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
272: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
273: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
274: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
275: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
276: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
277:

Line 274: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;

270: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE := 1;
271: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
272: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
273: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
274: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
275: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
276: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
277:
278: BEGIN

Line 275: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;

271: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
272: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
273: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
274: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
275: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
276: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
277:
278: BEGIN
279:

Line 276: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;

272: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
273: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
274: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
275: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
276: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
277:
278: BEGIN
279:
280: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 546: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;

542: ) IS
543:
544: l_api_version CONSTANT NUMBER := 1;
545: l_api_name CONSTANT VARCHAR2(30) := 'g_update_template';
546: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
547:
548:
549: BEGIN
550: