APPS.OKC_BUS_DOC_TYPES_PVT dependencies on OKC_DOC_QA_LISTS

Line 318: -- delete from okc_doc_qa_lists

314: ) is
315: begin
316:
317: -- skekkar
318: -- delete from okc_doc_qa_lists
319: delete from okc_doc_qa_lists
320: where DOCUMENT_TYPE = X_DOCUMENT_TYPE;
321: --
322: --

Line 319: delete from okc_doc_qa_lists

315: begin
316:
317: -- skekkar
318: -- delete from okc_doc_qa_lists
319: delete from okc_doc_qa_lists
320: where DOCUMENT_TYPE = X_DOCUMENT_TYPE;
321: --
322: --
323:

Line 404: insert into OKC_DOC_QA_LISTS(

400: ) IS
401:
402: BEGIN
403:
404: insert into OKC_DOC_QA_LISTS(
405: QA_CODE,
406: DOCUMENT_TYPE,
407: SEVERITY_FLAG,
408: OBJECT_VERSION_NUMBER,

Line 426: and lkp.lookup_code NOT IN ( select qa_code from okc_doc_qa_lists where document_type = p_document_type );

422: sysdate,
423: 'Y'
424: from fnd_lookups lkp
425: where lkp.lookup_type = 'OKC_TERM_QA_LIST'
426: and lkp.lookup_code NOT IN ( select qa_code from okc_doc_qa_lists where document_type = p_document_type );
427:
428: commit;
429:
430: EXCEPTION