APPS.XLA_CMP_STRING_PKG dependencies on DBMS_SQL

Line 92: p_array_string_1 IN DBMS_SQL.VARCHAR2S

88: --| |
89: --+==========================================================================+
90: --
91: FUNCTION ConcatTwoStrings (
92: p_array_string_1 IN DBMS_SQL.VARCHAR2S
93: ,p_array_string_2 IN DBMS_SQL.VARCHAR2S
94: )
95: RETURN DBMS_SQL.VARCHAR2S
96: IS

Line 93: ,p_array_string_2 IN DBMS_SQL.VARCHAR2S

89: --+==========================================================================+
90: --
91: FUNCTION ConcatTwoStrings (
92: p_array_string_1 IN DBMS_SQL.VARCHAR2S
93: ,p_array_string_2 IN DBMS_SQL.VARCHAR2S
94: )
95: RETURN DBMS_SQL.VARCHAR2S
96: IS
97: l_array_string DBMS_SQL.VARCHAR2S;

Line 95: RETURN DBMS_SQL.VARCHAR2S

91: FUNCTION ConcatTwoStrings (
92: p_array_string_1 IN DBMS_SQL.VARCHAR2S
93: ,p_array_string_2 IN DBMS_SQL.VARCHAR2S
94: )
95: RETURN DBMS_SQL.VARCHAR2S
96: IS
97: l_array_string DBMS_SQL.VARCHAR2S;
98: l_Index BINARY_INTEGER;
99: l_log_module VARCHAR2(240);

Line 97: l_array_string DBMS_SQL.VARCHAR2S;

93: ,p_array_string_2 IN DBMS_SQL.VARCHAR2S
94: )
95: RETURN DBMS_SQL.VARCHAR2S
96: IS
97: l_array_string DBMS_SQL.VARCHAR2S;
98: l_Index BINARY_INTEGER;
99: l_log_module VARCHAR2(240);
100: BEGIN
101: --

Line 188: ,p_array_string OUT NOCOPY DBMS_SQL.VARCHAR2S)

184: --+==========================================================================+
185: --
186: PROCEDURE CreateString
187: (p_package_text IN CLOB
188: ,p_array_string OUT NOCOPY DBMS_SQL.VARCHAR2S)
189: IS
190: --
191: l_Text VARCHAR2(32000);
192: l_SubText VARCHAR2(256);

Line 203: l_array_string DBMS_SQL.VARCHAR2S;

199: --
200: l_pos NUMBER ;
201: --
202: l_Idx BINARY_INTEGER;
203: l_array_string DBMS_SQL.VARCHAR2S;
204: l_log_module VARCHAR2(240);
205:
206: l_clob_string CLOB;
207: l_maxLength NUMBER := 8000;

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

309: --| |
310: --| |
311: --+==========================================================================+
312:
313: PROCEDURE AddNewLine(p_array_string IN OUT NOCOPY DBMS_SQL.VARCHAR2S)
314: IS
315: --
316: l_Idx BINARY_INTEGER;
317: l_array_string DBMS_SQL.VARCHAR2S;

Line 317: l_array_string DBMS_SQL.VARCHAR2S;

313: PROCEDURE AddNewLine(p_array_string IN OUT NOCOPY DBMS_SQL.VARCHAR2S)
314: IS
315: --
316: l_Idx BINARY_INTEGER;
317: l_array_string DBMS_SQL.VARCHAR2S;
318: l_log_module VARCHAR2(240);
319: --
320: BEGIN
321: --

Line 511: PROCEDURE DumpLines (p_array_output_string IN DBMS_SQL.VARCHAR2S)

507: --| PUBLIC Procedure |
508: --| |
509: --+==========================================================================+
510: --
511: PROCEDURE DumpLines (p_array_output_string IN DBMS_SQL.VARCHAR2S)
512: IS
513: l_array_string DBMS_SQL.VARCHAR2S;
514: l_log_module VARCHAR2(240);
515: BEGIN

Line 513: l_array_string DBMS_SQL.VARCHAR2S;

509: --+==========================================================================+
510: --
511: PROCEDURE DumpLines (p_array_output_string IN DBMS_SQL.VARCHAR2S)
512: IS
513: l_array_string DBMS_SQL.VARCHAR2S;
514: l_log_module VARCHAR2(240);
515: BEGIN
516: --
517: --