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 2285: OKC_SECTIONS_B SCN

2281: kart.id id,
2282: kart.sav_sae_id article_id,
2283: kart.scn_id scn_id
2284: FROM OKC_K_ARTICLES_B KART,
2285: OKC_SECTIONS_B SCN
2286: WHERE kart.document_type=p_doc_type
2287: AND kart.document_id =p_doc_id
2288: AND scn.id = kart.scn_id
2289: AND scn.scn_code = G_UNASSIGNED_SECTION_CODE

Line 2392: FROM OKC_SECTIONS_B SCN

2388: CURSOR l_get_empty_section_csr IS
2389: SELECT
2390: id id,
2391: scn_id scn_id
2392: FROM OKC_SECTIONS_B SCN
2393: WHERE document_type=p_doc_type
2394: AND document_id =p_doc_id
2395: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED
2396: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED

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

2396: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED
2397: AND not exists ( SELECT 'x' FROM OKC_K_ARTICLES_B WHERE scn_id=scn.id
2398: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED
2399: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED)
2400: AND not exists ( SELECT 'x' FROM OKC_SECTIONS_B SCN1 WHERE SCN1.scn_id = scn.id
2401: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED
2402: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED);
2403: -- if section has sub sections then it is not considered empty Bug 3219528
2404: BEGIN

Line 4503: FROM OKC_SECTIONS_B

4499: okc_terms_util_pvt.get_message('OKC',
4500: 'OKC_TERMS_LABEL_AND_NAME',
4501: 'LABEL', LABEL,
4502: 'NAME', HEADING)) HEADING
4503: FROM OKC_SECTIONS_B
4504: WHERE DOCUMENT_TYPE = p_doc_type
4505: AND DOCUMENT_ID = p_doc_id;
4506:
4507: CURSOR l_get_effective_date IS