APPS.BEN_DM_GEN_DOWNLOAD dependencies on DBMS_SQL

Line 9: g_package_body dbms_sql.varchar2s;

5: type t_varchar2_32k_tbl is table of varchar2(32767) index by binary_integer;
6:
7: -- to store the package body in to array so as to overcome the limit of 32767
8: -- character the global variable is defined.
9: g_package_body dbms_sql.varchar2s;
10: g_package_index number := 0;
11: g_columns_tbl hr_dm_library.t_varchar2_tbl;
12: --
13: -- Exception for generated text exceeding the maximum allowable buffer size.

Line 184: -- of more than 32 K size can be parsed using dbms_sql procedure.

180: -- Each procedure will be stored in the array of varchar2(32767).
181: -- The input to this procedure is pl/sql table i.e array of string.
182: -- Now the task of this procedure is to split the above array elements into
183: -- array elements of size 256. This is required so as to the package body
184: -- of more than 32 K size can be parsed using dbms_sql procedure.
185: --
186: -- ------------------------------------------------------------------------
187:
188: procedure add_to_package_body