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.CS_KB_CTX_PKG dependencies on FND_GLOBAL

Line 219: l_newline VARCHAR2(4) := fnd_global.newline;

215: p_clob IN OUT NOCOPY CLOB)
216: IS
217: l_temp_clob CLOB;
218: l_amt BINARY_INTEGER;
219: l_newline VARCHAR2(4) := fnd_global.newline;
220: l_data VARCHAR2(32000);
221:
222: CURSOR set_title_csr(p_set_id NUMBER, p_lang VARCHAR2) IS
223: SELECT name

Line 516: l_newline VARCHAR2(4) := fnd_global.newline;

512: p_clob IN OUT NOCOPY CLOB)
513: IS
514: l_temp_clob CLOB;
515: l_amt BINARY_INTEGER;
516: l_newline VARCHAR2(4) := fnd_global.newline;
517: l_data VARCHAR2(32000);
518:
519: CURSOR set_title_csr(p_set_id NUMBER, p_lang VARCHAR2) IS
520: SELECT name

Line 993: l_newline VARCHAR2(4) := fnd_global.newline;

989: l_soln_title VARCHAR2(2000);
990: l_soln_number VARCHAR2(30);
991: l_data VARCHAR2(2000);
992: l_amt BINARY_INTEGER;
993: l_newline VARCHAR2(4) := fnd_global.newline;
994: BEGIN
995: -- Fetch the solution header
996: OPEN c2(p_solution_id, p_lang);
997: FETCH c2 INTO l_soln_number, l_soln_title;

Line 1028: l_newline VARCHAR2(4) := fnd_global.newline;

1024: l_soln_number VARCHAR2(30);
1025: l_type_id NUMBER;
1026: l_data VARCHAR2(2000);
1027: l_amt BINARY_INTEGER;
1028: l_newline VARCHAR2(4) := fnd_global.newline;
1029: BEGIN
1030:
1031: OPEN c2(p_solution_id);
1032: FETCH c2 INTO l_type_id, l_soln_number;

Line 1101: l_newline VARCHAR2(4) := fnd_global.newline;

1097: blob_csid NUMBER := dbms_lob.default_csid;
1098: lang_context INTEGER := dbms_lob.default_lang_ctx;
1099: warning INTEGER;
1100: -- blob_length INTEGER;
1101: l_newline VARCHAR2(4) := fnd_global.newline;
1102:
1103: BEGIN
1104: -- For each Statement linked to the solution header,
1105: -- write all of the Statement content (summary, description)

Line 1181: l_newline VARCHAR2(4) := fnd_global.newline;

1177: l_amt BINARY_INTEGER;
1178: l_setid NUMBER;
1179: l_lang VARCHAR2(4);
1180: rec1 c1%ROWTYPE;
1181: l_newline VARCHAR2(4) := fnd_global.newline;
1182: BEGIN
1183: -- Write out statement Section to statements section
1184: l_data := l_newline||'';
1185: l_amt := LENGTH(l_data);

Line 1225: l_newline VARCHAR2(4) := fnd_global.newline;

1221:
1222: l_data VARCHAR2(32000);
1223: l_amt BINARY_INTEGER;
1224: l_category_id NUMBER;
1225: l_newline VARCHAR2(4) := fnd_global.newline;
1226: BEGIN
1227: -- write category section
1228:
1229: l_data := l_newline||'';

Line 1271: l_newline VARCHAR2(4) := fnd_global.newline;

1267: AND t.LANGUAGE = c_lang
1268: AND s.set_id = c_set_id;
1269: l_data VARCHAR2(32000);
1270: l_amt BINARY_INTEGER;
1271: l_newline VARCHAR2(4) := fnd_global.newline;
1272: BEGIN
1273: --write product name and description to clob
1274: l_data := '';
1275: l_amt := 0;

Line 1306: l_newline VARCHAR2(4) := fnd_global.newline;

1302: l_setid NUMBER;
1303: l_product_id NUMBER;
1304: l_product_org_id NUMBER;
1305: rec3 c3%ROWTYPE;
1306: l_newline VARCHAR2(4) := fnd_global.newline;
1307: BEGIN
1308: -- write the start product section info
1309:
1310: l_data := l_newline||'';

Line 1356: l_newline VARCHAR2(4) := fnd_global.newline;

1352: AND t.LANGUAGE = c_lang
1353: AND s.set_id = c_set_id;
1354: l_data VARCHAR2(32000);
1355: l_amt BINARY_INTEGER;
1356: l_newline VARCHAR2(4) := fnd_global.newline;
1357: BEGIN
1358: --write platform name and description to clob
1359: l_data := '';
1360: l_amt := 0;

Line 1388: l_newline VARCHAR2(4) := fnd_global.newline;

1384: l_amt BINARY_INTEGER;
1385: l_platform_id NUMBER;
1386: l_platform_org_id NUMBER;
1387: rec4 c4%ROWTYPE;
1388: l_newline VARCHAR2(4) := fnd_global.newline;
1389: BEGIN
1390: -- write the start platform section info
1391:
1392: l_data := l_newline||'';

Line 1444: l_newline VARCHAR2(4) := fnd_global.newline;

1440: l_soln_vis NUMBER;
1441: l_vis NUMBER;
1442: rec4 c4%ROWTYPE;
1443: rec5 c5%ROWTYPE;
1444: l_newline VARCHAR2(4) := fnd_global.newline;
1445: BEGIN
1446: -- write the start category group section info
1447:
1448: l_data := l_newline||'';

Line 1514: l_newline VARCHAR2(4) := fnd_global.newline;

1510: l_amt BINARY_INTEGER;
1511: l_clob CLOB := NULL;
1512: l_clob_len NUMBER;
1513: p_clob_len NUMBER;
1514: l_newline VARCHAR2(4) := fnd_global.newline;
1515: BEGIN
1516: -- For each Statement linked to the solution header,
1517: -- write all of the Statement content (summary, description)
1518: -- into the clob.

Line 1564: l_newline VARCHAR2(4) := fnd_global.newline;

1560: l_amt BINARY_INTEGER;
1561: l_setid NUMBER;
1562: l_lang VARCHAR2(4);
1563: rec1 c1%ROWTYPE;
1564: l_newline VARCHAR2(4) := fnd_global.newline;
1565: BEGIN
1566: -- Write out statement Section to statements section
1567: l_data := l_newline||'';
1568: l_amt := LENGTH(l_data);

Line 1611: l_newline VARCHAR2(4) := fnd_global.newline;

1607: -- and tl.element_id = b.element_id;
1608: -- rec1 c1%ROWTYPE;
1609: l_data VARCHAR2(2000);
1610: l_amt BINARY_INTEGER;
1611: l_newline VARCHAR2(4) := fnd_global.newline;
1612: -- l_statement_number varchar2(30);
1613: -- l_name varchar2(2000);
1614: l_description CLOB := NULL;
1615: l_clob_len NUMBER;

Line 1659: l_newline VARCHAR2(4) := fnd_global.newline;

1655: --rec1 c1%ROWTYPE;
1656: l_data VARCHAR2(2000);
1657: l_amt BINARY_INTEGER;
1658: --l_type_id number;
1659: l_newline VARCHAR2(4) := fnd_global.newline;
1660: --l_statement_number varchar(30);
1661:
1662: -- Add access level section
1663: CURSOR access_levels_csr IS --(p_element_id in NUMBER) is

Line 1751: l_newline VARCHAR2(4) := fnd_global.newline;

1747: l_max_vis NUMBER;
1748: rec4 c4%ROWTYPE;
1749: rec5 c5%ROWTYPE;
1750: rec6 c6%ROWTYPE;
1751: l_newline VARCHAR2(4) := fnd_global.newline;
1752:
1753: -- perf11510
1754: CURSOR max_vis_pos_csr (p_statement_id NUMBER,
1755: p_set_id NUMBER,

Line 1947: l_newline VARCHAR2(4) := fnd_global.newline;

1943:
1944: l_data VARCHAR2(32000);
1945: l_amt BINARY_INTEGER;
1946:
1947: l_newline VARCHAR2(4) := fnd_global.newline;
1948:
1949: ROWS NATURAL := 30000;
1950: TYPE list_ids IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1951: l_ele_ids list_ids;