95: G_PARTY_ROLE_PARTNER CONSTANT VARCHAR2(30) := 'PARTNER_ORG';
96: G_PARTY_ROLE_CUSTOMER CONSTANT VARCHAR2(30) := 'CUSTOMER_ORG';
97: G_PARTY_ROLE_SUPPLIER CONSTANT VARCHAR2(30) := 'SUPPLIER_ORG';
98:
99: TYPE okc_doc_qa_lists_rec_type IS RECORD (
100: qa_code OKC_DOC_QA_LISTS.QA_CODE%TYPE,
101: severity_flag OKC_DOC_QA_LISTS.severity_flag%TYPE,
102: enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE);
103:
96: G_PARTY_ROLE_CUSTOMER CONSTANT VARCHAR2(30) := 'CUSTOMER_ORG';
97: G_PARTY_ROLE_SUPPLIER CONSTANT VARCHAR2(30) := 'SUPPLIER_ORG';
98:
99: TYPE okc_doc_qa_lists_rec_type IS RECORD (
100: qa_code OKC_DOC_QA_LISTS.QA_CODE%TYPE,
101: severity_flag OKC_DOC_QA_LISTS.severity_flag%TYPE,
102: enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE);
103:
104: TYPE okc_doc_qa_lists_tbl_type IS TABLE OF okc_doc_qa_lists_rec_type
97: G_PARTY_ROLE_SUPPLIER CONSTANT VARCHAR2(30) := 'SUPPLIER_ORG';
98:
99: TYPE okc_doc_qa_lists_rec_type IS RECORD (
100: qa_code OKC_DOC_QA_LISTS.QA_CODE%TYPE,
101: severity_flag OKC_DOC_QA_LISTS.severity_flag%TYPE,
102: enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE);
103:
104: TYPE okc_doc_qa_lists_tbl_type IS TABLE OF okc_doc_qa_lists_rec_type
105: INDEX BY BINARY_INTEGER;
98:
99: TYPE okc_doc_qa_lists_rec_type IS RECORD (
100: qa_code OKC_DOC_QA_LISTS.QA_CODE%TYPE,
101: severity_flag OKC_DOC_QA_LISTS.severity_flag%TYPE,
102: enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE);
103:
104: TYPE okc_doc_qa_lists_tbl_type IS TABLE OF okc_doc_qa_lists_rec_type
105: INDEX BY BINARY_INTEGER;
106:
100: qa_code OKC_DOC_QA_LISTS.QA_CODE%TYPE,
101: severity_flag OKC_DOC_QA_LISTS.severity_flag%TYPE,
102: enable_qa_yn OKC_DOC_QA_LISTS.enable_qa_yn%TYPE);
103:
104: TYPE okc_doc_qa_lists_tbl_type IS TABLE OF okc_doc_qa_lists_rec_type
105: INDEX BY BINARY_INTEGER;
106:
107: -----------------------------------------------------------
108:
154: -- Start of comments
155: --API name : insert_deliverables_qa_checks
156: --Type : Private.
157: --Function : This API inserts QA check list of Deliverables for the specified
158: -- Contract Type into the table OKC_DOC_QA_LISTS
159: --Pre-reqs : None.
160: --Parameters :
161: --IN : p_api_version IN NUMBER Required
162: -- : p_init_msg_list IN VARCHAR2 Required