eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CLS_UTIL dependencies on OKC_CLS_CLAUSE_BUFFER_T

Line 78: INSERT INTO OKC_CLS_CLAUSE_BUFFER_T(

74: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
75: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,'okc.plsql.OKC_CLS_UTIL.'||l_api_name,'LOAD_CLAUSE_XML: LIB mode processing started');
76: END IF;
77:
78: INSERT INTO OKC_CLS_CLAUSE_BUFFER_T(
79: BUFFER_SEQ_ID,
80: CLAUSE_SEQUENCE,
81: FULLTEXT_YN,
82: PRESECRIBED_YN,

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 176: DELETE FROM OKC_CLS_CLAUSE_BUFFER_T

172: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,'okc.plsql.OKC_CLS_UTIL.'||l_api_name,'LOAD_CLAUSE_XML: DOC mode processing started');
173: END IF;
174:
175: -- delete the rows against the received token
176: DELETE FROM OKC_CLS_CLAUSE_BUFFER_T
177: WHERE token = p_token;
178:
179: insert into OKC_CLS_CLAUSE_BUFFER_T(
180: BUFFER_SEQ_ID,

Line 179: insert into OKC_CLS_CLAUSE_BUFFER_T(

175: -- delete the rows against the received token
176: DELETE FROM OKC_CLS_CLAUSE_BUFFER_T
177: WHERE token = p_token;
178:
179: insert into OKC_CLS_CLAUSE_BUFFER_T(
180: BUFFER_SEQ_ID,
181: CLAUSE_SEQUENCE,
182: FULLTEXT_YN,
183: PRESECRIBED_YN,

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,

Line 291: FROM OKC_CLS_CLAUSE_BUFFER_T

287: CURSOR cur_distinct_sections_in_xml(p_tok VARCHAR2) IS
288: SELECT DISTINCT SECTION_ID,
289: SECTION_NAME,
290: SECTION_TITLE
291: FROM OKC_CLS_CLAUSE_BUFFER_T
292: WHERE token = p_tok;
293:
294: CURSOR cur_id_if_sync(param_token OKC_CLS_CLAUSE_BUFFER_T.token%TYPE) IS
295: SELECT buf.buffer_seq_id buffer_seq_id,

Line 294: CURSOR cur_id_if_sync(param_token OKC_CLS_CLAUSE_BUFFER_T.token%TYPE) IS

290: SECTION_TITLE
291: FROM OKC_CLS_CLAUSE_BUFFER_T
292: WHERE token = p_tok;
293:
294: CURSOR cur_id_if_sync(param_token OKC_CLS_CLAUSE_BUFFER_T.token%TYPE) IS
295: SELECT buf.buffer_seq_id buffer_seq_id,
296: art.ARTICLE_ID art_id,
297: ver.ARTICLE_VERSION_ID ver_id
298: FROM OKC_CLS_CLAUSE_BUFFER_T buf,

Line 298: FROM OKC_CLS_CLAUSE_BUFFER_T buf,

294: CURSOR cur_id_if_sync(param_token OKC_CLS_CLAUSE_BUFFER_T.token%TYPE) IS
295: SELECT buf.buffer_seq_id buffer_seq_id,
296: art.ARTICLE_ID art_id,
297: ver.ARTICLE_VERSION_ID ver_id
298: FROM OKC_CLS_CLAUSE_BUFFER_T buf,
299: OKC_ARTICLES_ALL ART
300: ,OKC_ARTICLE_VERSIONS ver
301: WHERE buf.token = param_token
302: AND art.article_number = buf.CLAUSE_NUMBER

Line 322: CURSOR cur_id_if_not_sync(param_token OKC_CLS_CLAUSE_BUFFER_T.token%type) IS

318: )
319: );
320:
321:
322: CURSOR cur_id_if_not_sync(param_token OKC_CLS_CLAUSE_BUFFER_T.token%type) IS
323: SELECT buf.buffer_seq_id buffer_seq_id,
324: art.ARTICLE_ID art_id,
325: ver.ARTICLE_VERSION_ID ver_id
326: FROM OKC_CLS_CLAUSE_BUFFER_T buf,

Line 326: FROM OKC_CLS_CLAUSE_BUFFER_T buf,

322: CURSOR cur_id_if_not_sync(param_token OKC_CLS_CLAUSE_BUFFER_T.token%type) IS
323: SELECT buf.buffer_seq_id buffer_seq_id,
324: art.ARTICLE_ID art_id,
325: ver.ARTICLE_VERSION_ID ver_id
326: FROM OKC_CLS_CLAUSE_BUFFER_T buf,
327: OKC_ARTICLES_ALL ART
328: ,OKC_ARTICLE_VERSIONS ver
329: WHERE buf.token = '96aebdf2d5525841ddcf5bb9097714e0'
330: AND art.article_number = buf.CLAUSE_NUMBER

Line 346: seq_id OKC_CLS_CLAUSE_BUFFER_T.buffer_seq_id%TYPE,

342: )
343: );
344:
345: TYPE art_ver_id IS RECORD (
346: seq_id OKC_CLS_CLAUSE_BUFFER_T.buffer_seq_id%TYPE,
347: art_id OKC_CLS_CLAUSE_BUFFER_T.ORIG_ARTICLE_ID%TYPE,
348: ver_id OKC_CLS_CLAUSE_BUFFER_T.ORIG_ARTICLE_VERSION_ID%TYPE
349: );
350:

Line 347: art_id OKC_CLS_CLAUSE_BUFFER_T.ORIG_ARTICLE_ID%TYPE,

343: );
344:
345: TYPE art_ver_id IS RECORD (
346: seq_id OKC_CLS_CLAUSE_BUFFER_T.buffer_seq_id%TYPE,
347: art_id OKC_CLS_CLAUSE_BUFFER_T.ORIG_ARTICLE_ID%TYPE,
348: ver_id OKC_CLS_CLAUSE_BUFFER_T.ORIG_ARTICLE_VERSION_ID%TYPE
349: );
350:
351: TYPE art_ver_ids_tbl IS TABLE OF art_ver_id INDEX BY BINARY_INTEGER;

Line 348: ver_id OKC_CLS_CLAUSE_BUFFER_T.ORIG_ARTICLE_VERSION_ID%TYPE

344:
345: TYPE art_ver_id IS RECORD (
346: seq_id OKC_CLS_CLAUSE_BUFFER_T.buffer_seq_id%TYPE,
347: art_id OKC_CLS_CLAUSE_BUFFER_T.ORIG_ARTICLE_ID%TYPE,
348: ver_id OKC_CLS_CLAUSE_BUFFER_T.ORIG_ARTICLE_VERSION_ID%TYPE
349: );
350:
351: TYPE art_ver_ids_tbl IS TABLE OF art_ver_id INDEX BY BINARY_INTEGER;
352:

Line 490: -- update the sections in respective OKC_CLS_CLAUSE_BUFFER_T/ORIG_SECTION_ID

486: --------------------------------------------
487:
488: END IF;
489:
490: -- update the sections in respective OKC_CLS_CLAUSE_BUFFER_T/ORIG_SECTION_ID
491: UPDATE OKC_CLS_CLAUSE_BUFFER_T
492: SET ORIG_SECTION_ID = l_section_id,
493: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
494: LAST_UPDATE_DATE = SYSDATE,

Line 491: UPDATE OKC_CLS_CLAUSE_BUFFER_T

487:
488: END IF;
489:
490: -- update the sections in respective OKC_CLS_CLAUSE_BUFFER_T/ORIG_SECTION_ID
491: UPDATE OKC_CLS_CLAUSE_BUFFER_T
492: SET ORIG_SECTION_ID = l_section_id,
493: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
494: LAST_UPDATE_DATE = SYSDATE,
495: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 568: UPDATE OKC_CLS_CLAUSE_BUFFER_T buf

564: FETCH cur_id_if_sync BULK COLLECT INTO l_art_ver_ids_tbl;
565: CLOSE cur_id_if_sync;
566:
567: FORALL i IN l_art_ver_ids_tbl.first .. l_art_ver_ids_tbl.last
568: UPDATE OKC_CLS_CLAUSE_BUFFER_T buf
569: SET ORIG_ARTICLE_ID = l_art_ver_ids_tbl(i).art_id ,
570: ORIG_ARTICLE_VERSION_ID = l_art_ver_ids_tbl(i).ver_id,
571: CLAUSE_DISPLAY_SEQUENCE = (l_max_seq + (SERIAL_NUMBER * 10)),
572: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 592: FROM okc_k_articles_b art, OKC_CLS_CLAUSE_BUFFER_T buf

588: SELECT CASE WHEN art.ARTICLE_VERSION_ID <> buf.ORIG_ARTICLE_VERSION_ID THEN 'Y'
589: ELSE 'N'
590: END AS wrong_version_yn,
591: CLAUSE_NUMBER
592: FROM okc_k_articles_b art, OKC_CLS_CLAUSE_BUFFER_T buf
593: WHERE art.DOCUMENT_TYPE = p_doc_type
594: AND art.DOCUMENT_ID = p_doc_id
595: AND art.SAV_SAE_ID = buf.ORIG_ARTICLE_ID
596: )

Line 627: UPDATE OKC_CLS_CLAUSE_BUFFER_T buf

623: FETCH cur_id_if_not_sync BULK COLLECT INTO l_art_ver_ids_tbl;
624: CLOSE cur_id_if_not_sync;
625:
626: FORALL i IN l_art_ver_ids_tbl.first .. l_art_ver_ids_tbl.last
627: UPDATE OKC_CLS_CLAUSE_BUFFER_T buf
628: SET ORIG_ARTICLE_ID = l_art_ver_ids_tbl(i).art_id ,
629: ORIG_ARTICLE_VERSION_ID = l_art_ver_ids_tbl(i).ver_id,
630: CLAUSE_DISPLAY_SEQUENCE = (l_max_seq + (SERIAL_NUMBER * 10)),
631: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 652: from OKC_CLS_CLAUSE_BUFFER_T

648: END IF;
649: l_missing_clause_count := -1;
650: SELECT Count(1)
651: INTO l_missing_clause_count
652: from OKC_CLS_CLAUSE_BUFFER_T
653: WHERE token = p_token
654: AND ORIG_ARTICLE_ID IS NULL;
655:
656: IF l_missing_clause_count > 0 THEN

Line 707: FROM OKC_CLS_CLAUSE_BUFFER_T buf

703: ORIG_ARTICLE_VERSION_ID,
704: 'CLS',
705: CLAUSE_CLS_ID,
706: ORIG_ARTICLE_ID
707: FROM OKC_CLS_CLAUSE_BUFFER_T buf
708: WHERE TOKEN = p_token
709: AND NOT EXISTS (SELECT 1
710: FROM okc_k_articles_b
711: WHERE DOCUMENT_TYPE = p_doc_type