DBA Data[Home] [Help]

APPS.OKC_NUMBER_SCHEME_DTL_GRP dependencies on OKC_NUMBER_SCHEME_DTLS

Line 193: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE := 1;

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;

Line 194: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%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;

Line 195: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_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

Line 196: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;

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:

Line 197: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

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

Line 198: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

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);