APPS.OKC_TERMS_QA_PVT dependencies on OKC_QA_ERRORS_T_S

Line 238: heading OKC_QA_ERRORS_T.section_name%TYPE,

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:
242: TYPE qa_detail_type IS RECORD (

Line 317: SELECT OKC_QA_ERRORS_T_S.NEXTVAL FROM DUAL;

313: IS
314:
315: l_api_name CONSTANT VARCHAR2(30) := 'get_seq_id';
316: CURSOR l_seq_csr IS
317: SELECT OKC_QA_ERRORS_T_S.NEXTVAL FROM DUAL;
318:
319: BEGIN
320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered get_seq_id');

Line 3866: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;

3862: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3863: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3864:
3865: l_title OKC_QA_ERRORS_T.TITLE%TYPE;
3866: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;
3867:
3868: CURSOR l_draft_art_csr IS
3869: SELECT DRA.article_id, DRA.article_version_id,
3870: --NVL(VER.display_name, ART.article_title) title, DRA.section_name section