APPS.OKC_CLS_UTIL dependencies on OKC_CLS_CLAUSE_BUFFER_T_S

Line 110: (SELECT OKC_CLS_CLAUSE_BUFFER_T_S.NEXTVAL,

106: CREATION_DATE,
107: LAST_UPDATED_BY,
108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN)
110: (SELECT OKC_CLS_CLAUSE_BUFFER_T_S.NEXTVAL,
111: CLAUSE_SEQUENCE,
112: decode(FULLTEXT_YN,'true','Y','false','N',null),
113: decode(PRESECRIBED_YN,'true','Y','false','N',null),
114: decode(REQUIRED_YN,'true','Y','false','N',null),

Line 205: (SELECT OKC_CLS_CLAUSE_BUFFER_T_S.NEXTVAL,

201: CREATION_DATE,
202: LAST_UPDATED_BY,
203: LAST_UPDATE_DATE,
204: LAST_UPDATE_LOGIN)
205: (SELECT OKC_CLS_CLAUSE_BUFFER_T_S.NEXTVAL,
206: ROWNUM,
207: NULL,
208: --CLAUSE_SEQUENCE,
209: --decode(FULLTEXT_YN,'true','Y','false','N',null),

Line 283: l_xml_section_id OKC_CLS_CLAUSE_BUFFER_T.SECTION_ID%TYPE;

279: x_err_msg OUT NOCOPY VARCHAR2,
280: x_err_msg_code OUT NOCOPY VARCHAR2) AS
281:
282: l_api_name CONSTANT VARCHAR2(30) := 'LOAD_CLAUSES_FOR_DOC';
283: l_xml_section_id OKC_CLS_CLAUSE_BUFFER_T.SECTION_ID%TYPE;
284: l_xml_section_name OKC_CLS_CLAUSE_BUFFER_T.SECTION_NAME%TYPE;
285: l_xml_section_title OKC_CLS_CLAUSE_BUFFER_T.SECTION_TITLE%TYPE;
286:
287: CURSOR cur_distinct_sections_in_xml(p_tok VARCHAR2) IS

Line 284: l_xml_section_name OKC_CLS_CLAUSE_BUFFER_T.SECTION_NAME%TYPE;

280: x_err_msg_code OUT NOCOPY VARCHAR2) AS
281:
282: l_api_name CONSTANT VARCHAR2(30) := 'LOAD_CLAUSES_FOR_DOC';
283: l_xml_section_id OKC_CLS_CLAUSE_BUFFER_T.SECTION_ID%TYPE;
284: l_xml_section_name OKC_CLS_CLAUSE_BUFFER_T.SECTION_NAME%TYPE;
285: l_xml_section_title OKC_CLS_CLAUSE_BUFFER_T.SECTION_TITLE%TYPE;
286:
287: CURSOR cur_distinct_sections_in_xml(p_tok VARCHAR2) IS
288: SELECT DISTINCT SECTION_ID,

Line 285: l_xml_section_title OKC_CLS_CLAUSE_BUFFER_T.SECTION_TITLE%TYPE;

281:
282: l_api_name CONSTANT VARCHAR2(30) := 'LOAD_CLAUSES_FOR_DOC';
283: l_xml_section_id OKC_CLS_CLAUSE_BUFFER_T.SECTION_ID%TYPE;
284: l_xml_section_name OKC_CLS_CLAUSE_BUFFER_T.SECTION_NAME%TYPE;
285: l_xml_section_title OKC_CLS_CLAUSE_BUFFER_T.SECTION_TITLE%TYPE;
286:
287: CURSOR cur_distinct_sections_in_xml(p_tok VARCHAR2) IS
288: SELECT DISTINCT SECTION_ID,
289: SECTION_NAME,