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 198: l_newline VARCHAR2(4) := fnd_global.newline;

194: p_clob IN OUT NOCOPY CLOB)
195: IS
196: l_temp_clob CLOB;
197: l_amt BINARY_INTEGER;
198: l_newline VARCHAR2(4) := fnd_global.newline;
199: l_data VARCHAR2(32000);
200:
201: CURSOR set_title_csr(p_set_id NUMBER, p_lang VARCHAR2) IS
202: SELECT name

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

550: l_soln_title VARCHAR2(2000);
551: l_soln_number VARCHAR2(30);
552: l_data VARCHAR2(2000);
553: l_amt BINARY_INTEGER;
554: l_newline VARCHAR2(4) := fnd_global.newline;
555: BEGIN
556: -- Fetch the solution header
557: OPEN c2(p_solution_id, p_lang);
558: FETCH c2 INTO l_soln_number, l_soln_title;

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

585: l_soln_number VARCHAR2(30);
586: l_type_id NUMBER;
587: l_data VARCHAR2(2000);
588: l_amt BINARY_INTEGER;
589: l_newline VARCHAR2(4) := fnd_global.newline;
590: BEGIN
591:
592: OPEN c2(p_solution_id);
593: FETCH c2 INTO l_type_id, l_soln_number;

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

628:
629: l_data VARCHAR2(32000);
630: l_amt BINARY_INTEGER;
631: l_category_id NUMBER;
632: l_newline VARCHAR2(4) := fnd_global.newline;
633: BEGIN
634: -- write category section
635:
636: l_data := l_newline||'';

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

674: AND t.LANGUAGE = c_lang
675: AND s.set_id = c_set_id;
676: l_data VARCHAR2(32000);
677: l_amt BINARY_INTEGER;
678: l_newline VARCHAR2(4) := fnd_global.newline;
679: BEGIN
680: --write product name and description to clob
681: l_data := '';
682: l_amt := 0;

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

709: l_setid NUMBER;
710: l_product_id NUMBER;
711: l_product_org_id NUMBER;
712: rec3 c3%ROWTYPE;
713: l_newline VARCHAR2(4) := fnd_global.newline;
714: BEGIN
715: -- write the start product section info
716:
717: l_data := l_newline||'';

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

759: AND t.LANGUAGE = c_lang
760: AND s.set_id = c_set_id;
761: l_data VARCHAR2(32000);
762: l_amt BINARY_INTEGER;
763: l_newline VARCHAR2(4) := fnd_global.newline;
764: BEGIN
765: --write platform name and description to clob
766: l_data := '';
767: l_amt := 0;

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

791: l_amt BINARY_INTEGER;
792: l_platform_id NUMBER;
793: l_platform_org_id NUMBER;
794: rec4 c4%ROWTYPE;
795: l_newline VARCHAR2(4) := fnd_global.newline;
796: BEGIN
797: -- write the start platform section info
798:
799: l_data := l_newline||'';

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

847: l_soln_vis NUMBER;
848: l_vis NUMBER;
849: rec4 c4%ROWTYPE;
850: rec5 c5%ROWTYPE;
851: l_newline VARCHAR2(4) := fnd_global.newline;
852: BEGIN
853: -- write the start category group section info
854:
855: l_data := l_newline||'';

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

917: l_amt BINARY_INTEGER;
918: l_clob CLOB := NULL;
919: l_clob_len NUMBER;
920: p_clob_len NUMBER;
921: l_newline VARCHAR2(4) := fnd_global.newline;
922: BEGIN
923: -- For each Statement linked to the solution header,
924: -- write all of the Statement content (summary, description)
925: -- into the clob.

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

967: l_amt BINARY_INTEGER;
968: l_setid NUMBER;
969: l_lang VARCHAR2(4);
970: rec1 c1%ROWTYPE;
971: l_newline VARCHAR2(4) := fnd_global.newline;
972: BEGIN
973: -- Write out statement Section to statements section
974: l_data := l_newline||'';
975: l_amt := LENGTH(l_data);

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

1014: -- and tl.element_id = b.element_id;
1015: -- rec1 c1%ROWTYPE;
1016: l_data VARCHAR2(2000);
1017: l_amt BINARY_INTEGER;
1018: l_newline VARCHAR2(4) := fnd_global.newline;
1019: -- l_statement_number varchar2(30);
1020: -- l_name varchar2(2000);
1021: l_description CLOB := NULL;
1022: l_clob_len NUMBER;

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

1062: --rec1 c1%ROWTYPE;
1063: l_data VARCHAR2(2000);
1064: l_amt BINARY_INTEGER;
1065: --l_type_id number;
1066: l_newline VARCHAR2(4) := fnd_global.newline;
1067: --l_statement_number varchar(30);
1068:
1069: -- Add access level section
1070: CURSOR access_levels_csr IS --(p_element_id in NUMBER) is

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

1154: l_max_vis NUMBER;
1155: rec4 c4%ROWTYPE;
1156: rec5 c5%ROWTYPE;
1157: rec6 c6%ROWTYPE;
1158: l_newline VARCHAR2(4) := fnd_global.newline;
1159:
1160: -- perf11510
1161: CURSOR max_vis_pos_csr (p_statement_id NUMBER,
1162: p_set_id NUMBER,

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

1350:
1351: l_data VARCHAR2(32000);
1352: l_amt BINARY_INTEGER;
1353:
1354: l_newline VARCHAR2(4) := fnd_global.newline;
1355:
1356: ROWS NATURAL := 30000;
1357: TYPE list_ids IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1358: l_ele_ids list_ids;