APPS.FA_CMP_STRING_PKG dependencies on DBMS_SQL

Line 52: p_array_string_1 IN DBMS_SQL.VARCHAR2S

48: --| |
49: --+==========================================================================+
50:
51: FUNCTION ConcatTwoStrings (
52: p_array_string_1 IN DBMS_SQL.VARCHAR2S
53: ,p_array_string_2 IN DBMS_SQL.VARCHAR2S
54: ) RETURN DBMS_SQL.VARCHAR2S IS
55:
56: l_array_string DBMS_SQL.VARCHAR2S;

Line 53: ,p_array_string_2 IN DBMS_SQL.VARCHAR2S

49: --+==========================================================================+
50:
51: FUNCTION ConcatTwoStrings (
52: p_array_string_1 IN DBMS_SQL.VARCHAR2S
53: ,p_array_string_2 IN DBMS_SQL.VARCHAR2S
54: ) RETURN DBMS_SQL.VARCHAR2S IS
55:
56: l_array_string DBMS_SQL.VARCHAR2S;
57: l_Index BINARY_INTEGER;

Line 54: ) RETURN DBMS_SQL.VARCHAR2S IS

50:
51: FUNCTION ConcatTwoStrings (
52: p_array_string_1 IN DBMS_SQL.VARCHAR2S
53: ,p_array_string_2 IN DBMS_SQL.VARCHAR2S
54: ) RETURN DBMS_SQL.VARCHAR2S IS
55:
56: l_array_string DBMS_SQL.VARCHAR2S;
57: l_Index BINARY_INTEGER;
58: l_procedure_name varchar2(80) := 'ConcatTwoStrings';

Line 56: l_array_string DBMS_SQL.VARCHAR2S;

52: p_array_string_1 IN DBMS_SQL.VARCHAR2S
53: ,p_array_string_2 IN DBMS_SQL.VARCHAR2S
54: ) RETURN DBMS_SQL.VARCHAR2S IS
55:
56: l_array_string DBMS_SQL.VARCHAR2S;
57: l_Index BINARY_INTEGER;
58: l_procedure_name varchar2(80) := 'ConcatTwoStrings';
59:
60: BEGIN

Line 134: ,p_array_string OUT NOCOPY DBMS_SQL.VARCHAR2S) IS

130: --+==========================================================================+
131:
132: PROCEDURE CreateString
133: (p_package_text IN CLOB
134: ,p_array_string OUT NOCOPY DBMS_SQL.VARCHAR2S) IS
135:
136: l_Text VARCHAR2(32000);
137: l_SubText VARCHAR2(256);
138:

Line 148: l_array_string DBMS_SQL.VARCHAR2S;

144:
145: l_pos NUMBER ;
146:
147: l_Idx BINARY_INTEGER;
148: l_array_string DBMS_SQL.VARCHAR2S;
149: l_procedure_name varchar2(80) := 'CreateString';
150:
151: l_clob_string CLOB;
152: l_maxLength NUMBER := 8000;

Line 252: PROCEDURE AddNewLine(p_array_string IN OUT NOCOPY DBMS_SQL.VARCHAR2S) IS

248: --| |
249: --| |
250: --+==========================================================================+
251:
252: PROCEDURE AddNewLine(p_array_string IN OUT NOCOPY DBMS_SQL.VARCHAR2S) IS
253:
254: l_Idx BINARY_INTEGER;
255: l_array_string DBMS_SQL.VARCHAR2S;
256: l_procedure_name varchar2(80) := 'AddNewLine';

Line 255: l_array_string DBMS_SQL.VARCHAR2S;

251:
252: PROCEDURE AddNewLine(p_array_string IN OUT NOCOPY DBMS_SQL.VARCHAR2S) IS
253:
254: l_Idx BINARY_INTEGER;
255: l_array_string DBMS_SQL.VARCHAR2S;
256: l_procedure_name varchar2(80) := 'AddNewLine';
257:
258: BEGIN
259:

Line 439: PROCEDURE DumpLines (p_array_output_string IN DBMS_SQL.VARCHAR2S) IS

435: --| PUBLIC Procedure |
436: --| |
437: --+==========================================================================+
438:
439: PROCEDURE DumpLines (p_array_output_string IN DBMS_SQL.VARCHAR2S) IS
440:
441: l_array_string DBMS_SQL.VARCHAR2S;
442: l_procedure_name varchar2(80) := 'DumpLines';
443:

Line 441: l_array_string DBMS_SQL.VARCHAR2S;

437: --+==========================================================================+
438:
439: PROCEDURE DumpLines (p_array_output_string IN DBMS_SQL.VARCHAR2S) IS
440:
441: l_array_string DBMS_SQL.VARCHAR2S;
442: l_procedure_name varchar2(80) := 'DumpLines';
443:
444: BEGIN
445:

Line 558: ,p_varchar2s OUT NOCOPY DBMS_SQL.VARCHAR2S

554:
555: PROCEDURE clob_to_varchar2s
556: (
557: p_clob IN CLOB
558: ,p_varchar2s OUT NOCOPY DBMS_SQL.VARCHAR2S
559: )
560: IS
561: l_current_table_index PLS_INTEGER;
562: l_current_pos_in_clob PLS_INTEGER;

Line 565: l_subarray DBMS_SQL.VARCHAR2S;

561: l_current_table_index PLS_INTEGER;
562: l_current_pos_in_clob PLS_INTEGER;
563: l_next_newline_pos PLS_INTEGER;
564: l_clob_length PLS_INTEGER;
565: l_subarray DBMS_SQL.VARCHAR2S;
566: l_procedure_name varchar2(80) := 'replace_token';
567:
568: BEGIN
569: