139: G_PARTY_ROLE_PARTNER CONSTANT VARCHAR2(30) := 'PARTNER_ORG';
140: G_PARTY_ROLE_CUSTOMER CONSTANT VARCHAR2(30) := 'CUSTOMER_ORG';
141: G_PARTY_ROLE_SUPPLIER CONSTANT VARCHAR2(30) := 'SUPPLIER_ORG';
142:
143: TYPE okc_doc_qa_lists_rec_type IS RECORD (
144: qa_code OKC_DOC_QA_LISTS.QA_CODE%TYPE,
145: severity_flag OKC_DOC_QA_LISTS.severity_flag%TYPE,
146: enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE);
147:
140: G_PARTY_ROLE_CUSTOMER CONSTANT VARCHAR2(30) := 'CUSTOMER_ORG';
141: G_PARTY_ROLE_SUPPLIER CONSTANT VARCHAR2(30) := 'SUPPLIER_ORG';
142:
143: TYPE okc_doc_qa_lists_rec_type IS RECORD (
144: qa_code OKC_DOC_QA_LISTS.QA_CODE%TYPE,
145: severity_flag OKC_DOC_QA_LISTS.severity_flag%TYPE,
146: enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE);
147:
148: TYPE okc_doc_qa_lists_tbl_type IS TABLE OF okc_doc_qa_lists_rec_type
141: G_PARTY_ROLE_SUPPLIER CONSTANT VARCHAR2(30) := 'SUPPLIER_ORG';
142:
143: TYPE okc_doc_qa_lists_rec_type IS RECORD (
144: qa_code OKC_DOC_QA_LISTS.QA_CODE%TYPE,
145: severity_flag OKC_DOC_QA_LISTS.severity_flag%TYPE,
146: enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE);
147:
148: TYPE okc_doc_qa_lists_tbl_type IS TABLE OF okc_doc_qa_lists_rec_type
149: INDEX BY BINARY_INTEGER;
142:
143: TYPE okc_doc_qa_lists_rec_type IS RECORD (
144: qa_code OKC_DOC_QA_LISTS.QA_CODE%TYPE,
145: severity_flag OKC_DOC_QA_LISTS.severity_flag%TYPE,
146: enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE);
147:
148: TYPE okc_doc_qa_lists_tbl_type IS TABLE OF okc_doc_qa_lists_rec_type
149: INDEX BY BINARY_INTEGER;
150:
144: qa_code OKC_DOC_QA_LISTS.QA_CODE%TYPE,
145: severity_flag OKC_DOC_QA_LISTS.severity_flag%TYPE,
146: enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE);
147:
148: TYPE okc_doc_qa_lists_tbl_type IS TABLE OF okc_doc_qa_lists_rec_type
149: INDEX BY BINARY_INTEGER;
150:
151: -----------------------------------------------------------
152:
200: -- Start of comments
201: --API name : insert_deliverables_qa_checks
202: --Type : Private.
203: --Function : This API inserts QA check list of Deliverables for the specified
204: -- Contract Type into the table OKC_DOC_QA_LISTS
205: --Pre-reqs : None.
206: --Parameters :
207: --IN : p_api_version IN NUMBER Required
208: -- : p_init_msg_list IN VARCHAR2 Required