APPS.OKC_TERMS_QA_PVT dependencies on OKC_SECTIONS_B

Line 234: id OKC_SECTIONS_B.ID%TYPE,

230: );
231: */
232:
233: TYPE section_rec_type IS RECORD (
234: id OKC_SECTIONS_B.ID%TYPE,
235: amendment_operation_code OKC_SECTIONS_B.amendment_operation_code%TYPE,
236: amendment_description OKC_SECTIONS_B.amendment_description%TYPE,
237: scn_id OKC_SECTIONS_B.scn_id%TYPE,
238: heading OKC_QA_ERRORS_T.section_name%TYPE,

Line 235: amendment_operation_code OKC_SECTIONS_B.amendment_operation_code%TYPE,

231: */
232:
233: TYPE section_rec_type IS RECORD (
234: id OKC_SECTIONS_B.ID%TYPE,
235: amendment_operation_code OKC_SECTIONS_B.amendment_operation_code%TYPE,
236: amendment_description OKC_SECTIONS_B.amendment_description%TYPE,
237: scn_id OKC_SECTIONS_B.scn_id%TYPE,
238: heading OKC_QA_ERRORS_T.section_name%TYPE,
239: scn_code OKC_SECTIONS_B.scn_code%TYPE

Line 236: amendment_description OKC_SECTIONS_B.amendment_description%TYPE,

232:
233: TYPE section_rec_type IS RECORD (
234: id OKC_SECTIONS_B.ID%TYPE,
235: amendment_operation_code OKC_SECTIONS_B.amendment_operation_code%TYPE,
236: amendment_description OKC_SECTIONS_B.amendment_description%TYPE,
237: scn_id OKC_SECTIONS_B.scn_id%TYPE,
238: heading OKC_QA_ERRORS_T.section_name%TYPE,
239: scn_code OKC_SECTIONS_B.scn_code%TYPE
240: );

Line 237: scn_id OKC_SECTIONS_B.scn_id%TYPE,

233: TYPE section_rec_type IS RECORD (
234: id OKC_SECTIONS_B.ID%TYPE,
235: amendment_operation_code OKC_SECTIONS_B.amendment_operation_code%TYPE,
236: amendment_description OKC_SECTIONS_B.amendment_description%TYPE,
237: scn_id OKC_SECTIONS_B.scn_id%TYPE,
238: heading OKC_QA_ERRORS_T.section_name%TYPE,
239: scn_code OKC_SECTIONS_B.scn_code%TYPE
240: );
241:

Line 239: scn_code OKC_SECTIONS_B.scn_code%TYPE

235: amendment_operation_code OKC_SECTIONS_B.amendment_operation_code%TYPE,
236: amendment_description OKC_SECTIONS_B.amendment_description%TYPE,
237: scn_id OKC_SECTIONS_B.scn_id%TYPE,
238: heading OKC_QA_ERRORS_T.section_name%TYPE,
239: scn_code OKC_SECTIONS_B.scn_code%TYPE
240: );
241:
242: TYPE qa_detail_type IS RECORD (
243: qa_code FND_LOOKUPS.LOOKUP_CODE%TYPE,

Line 2319: OKC_SECTIONS_B SCN

2315: kart.id id,
2316: kart.sav_sae_id article_id,
2317: kart.scn_id scn_id
2318: FROM OKC_K_ARTICLES_B KART,
2319: OKC_SECTIONS_B SCN
2320: WHERE kart.document_type=p_doc_type
2321: AND kart.document_id =p_doc_id
2322: AND scn.id = kart.scn_id
2323: AND scn.scn_code = G_UNASSIGNED_SECTION_CODE

Line 2426: FROM OKC_SECTIONS_B SCN

2422: CURSOR l_get_empty_section_csr IS
2423: SELECT
2424: id id,
2425: scn_id scn_id
2426: FROM OKC_SECTIONS_B SCN
2427: WHERE document_type=p_doc_type
2428: AND document_id =p_doc_id
2429: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED
2430: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED

Line 2434: AND not exists ( SELECT 'x' FROM OKC_SECTIONS_B SCN1 WHERE SCN1.scn_id = scn.id

2430: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED
2431: AND not exists ( SELECT 'x' FROM OKC_K_ARTICLES_B WHERE scn_id=scn.id
2432: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED
2433: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED)
2434: AND not exists ( SELECT 'x' FROM OKC_SECTIONS_B SCN1 WHERE SCN1.scn_id = scn.id
2435: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED
2436: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED);
2437: -- if section has sub sections then it is not considered empty Bug 3219528
2438: BEGIN

Line 4537: FROM OKC_SECTIONS_B

4533: okc_terms_util_pvt.get_message('OKC',
4534: 'OKC_TERMS_LABEL_AND_NAME',
4535: 'LABEL', LABEL,
4536: 'NAME', HEADING)) HEADING
4537: FROM OKC_SECTIONS_B
4538: WHERE DOCUMENT_TYPE = p_doc_type
4539: AND DOCUMENT_ID = p_doc_id;
4540:
4541: CURSOR l_get_effective_date IS