DBA Data[Home] [Help]

APPS.OKC_DOC_QA_LIST_GRP dependencies on OKC_DOC_QA_LISTS

Line 161: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE := 1;

157: ) IS
158:
159: l_api_version CONSTANT NUMBER := 1;
160: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Doc_Qa_List';
161: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE := 1;
162: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
163: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
164: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
165: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;

Line 162: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;

158:
159: l_api_version CONSTANT NUMBER := 1;
160: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Doc_Qa_List';
161: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE := 1;
162: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
163: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
164: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
165: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
166: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;

Line 163: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;

159: l_api_version CONSTANT NUMBER := 1;
160: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Doc_Qa_List';
161: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE := 1;
162: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
163: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
164: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
165: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
166: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
167: BEGIN

Line 164: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;

160: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Doc_Qa_List';
161: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE := 1;
162: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
163: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
164: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
165: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
166: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
167: BEGIN
168:

Line 165: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;

161: l_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE := 1;
162: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
163: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
164: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
165: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
166: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
167: BEGIN
168:
169: IF (l_debug = 'Y') THEN

Line 166: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;

162: l_created_by OKC_DOC_QA_LISTS.CREATED_BY%TYPE;
163: l_creation_date OKC_DOC_QA_LISTS.CREATION_DATE%TYPE;
164: l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
165: l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
166: l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
167: BEGIN
168:
169: IF (l_debug = 'Y') THEN
170: okc_debug.log('600: Entered Insert_Doc_Qa_List', 2);