The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Doc_Qa_List(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qa_code IN VARCHAR2,
p_document_type IN VARCHAR2,
p_severity_flag IN VARCHAR2,
p_enable_qa_yn IN VARCHAR2,
x_qa_code OUT NOCOPY VARCHAR2,
x_document_type OUT NOCOPY VARCHAR2
) IS
l_api_version CONSTANT NUMBER := 1;
l_last_updated_by OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
okc_debug.log('600: Entered Insert_Doc_Qa_List', 2);
SAVEPOINT g_Insert_Doc_Qa_List_GRP;
OKC_DOC_QA_LIST_PVT.Insert_Row(
p_validation_level => p_validation_level,
x_return_status => x_return_status,
p_qa_code => p_qa_code,
p_document_type => p_document_type,
p_severity_flag => p_severity_flag,
p_enable_qa_yn => p_enable_qa_yn,
x_qa_code => x_qa_code,
x_document_type => x_document_type
);
okc_debug.log('700: Leaving Insert_Doc_Qa_List', 2);
okc_debug.log('800: Leaving Insert_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
ROLLBACK TO g_Insert_Doc_Qa_List_GRP;
okc_debug.log('900: Leaving Insert_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
ROLLBACK TO g_Insert_Doc_Qa_List_GRP;
okc_debug.log('1000: Leaving Insert_Doc_Qa_List because of EXCEPTION: '||sqlerrm, 2);
ROLLBACK TO g_Insert_Doc_Qa_List_GRP;
END Insert_Doc_Qa_List;
PROCEDURE Update_Doc_Qa_List(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qa_code IN VARCHAR2,
p_document_type IN VARCHAR2,
p_severity_flag IN VARCHAR2,
p_enable_qa_yn IN VARCHAR2,
p_object_version_number IN NUMBER
) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'g_Update_Doc_Qa_List';
okc_debug.log('1600: Entered Update_Doc_Qa_List', 2);
SAVEPOINT g_Update_Doc_Qa_List_GRP;
OKC_DOC_QA_LIST_PVT.Update_Row(
p_validation_level => p_validation_level,
x_return_status => x_return_status,
p_qa_code => p_qa_code,
p_document_type => p_document_type,
p_severity_flag => p_severity_flag,
p_enable_qa_yn => p_enable_qa_yn,
p_object_version_number => p_object_version_number
);
okc_debug.log('1800: Leaving Update_Doc_Qa_List', 2);
okc_debug.log('1900: Leaving Update_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
ROLLBACK TO g_Update_Doc_Qa_List_GRP;
okc_debug.log('2000: Leaving Update_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
ROLLBACK TO g_Update_Doc_Qa_List_GRP;
okc_debug.log('2100: Leaving Update_Doc_Qa_List because of EXCEPTION: '||sqlerrm, 2);
ROLLBACK TO g_Update_Doc_Qa_List_GRP;
END Update_Doc_Qa_List;
PROCEDURE Delete_Doc_Qa_List(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qa_code IN VARCHAR2,
p_document_type IN VARCHAR2,
p_object_version_number IN NUMBER
) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'g_Delete_Doc_Qa_List';
okc_debug.log('2200: Entered Delete_Doc_Qa_List', 2);
SAVEPOINT g_Delete_Doc_Qa_List_GRP;
OKC_DOC_QA_LIST_PVT.Delete_Row(
x_return_status => x_return_status,
p_qa_code => p_qa_code,
p_document_type => p_document_type,
p_object_version_number => p_object_version_number
);
okc_debug.log('2300: Leaving Delete_Doc_Qa_List', 2);
okc_debug.log('2400: Leaving Delete_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
ROLLBACK TO g_Delete_Doc_Qa_List_GRP;
okc_debug.log('2500: Leaving Delete_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
ROLLBACK TO g_Delete_Doc_Qa_List_GRP;
okc_debug.log('2600: Leaving Delete_Doc_Qa_List because of EXCEPTION: '||sqlerrm, 2);
ROLLBACK TO g_Delete_Doc_Qa_List_GRP;
END Delete_Doc_Qa_List;