189: ) IS
190:
191: l_api_version CONSTANT NUMBER := 1;
192: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Number_Scheme_Dtl';
193: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE := 1;
194: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
195: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
196: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
197: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
190:
191: l_api_version CONSTANT NUMBER := 1;
192: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Number_Scheme_Dtl';
193: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE := 1;
194: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
195: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
196: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
197: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
198: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
191: l_api_version CONSTANT NUMBER := 1;
192: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Number_Scheme_Dtl';
193: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE := 1;
194: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
195: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
196: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
197: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
198: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
199: BEGIN
192: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Number_Scheme_Dtl';
193: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE := 1;
194: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
195: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
196: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
197: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
198: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
199: BEGIN
200:
193: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE := 1;
194: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
195: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
196: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
197: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
198: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
199: BEGIN
200:
201: /*IF (l_debug = 'Y') THEN
194: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
195: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
196: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
197: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
198: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
199: BEGIN
200:
201: /*IF (l_debug = 'Y') THEN
202: okc_debug.log('600: Entered Insert_Number_Scheme_Dtl', 2);