APPS.BEN_DM_GEN_DOWNLOAD dependencies on HR_DM_LIBRARY

Line 11: g_columns_tbl hr_dm_library.t_varchar2_tbl;

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.
14: --
15: plsql_value_error exception;

Line 35: l_spaces := hr_dm_library.indent(p_indent_spaces => p_indent_spaces,

31: l_proc varchar2(100);
32: begin
33: l_proc := g_package||'indent' ;
34:
35: l_spaces := hr_dm_library.indent(p_indent_spaces => p_indent_spaces,
36: p_newline => p_newline);
37: return l_spaces;
38: exception
39: when others then

Line 399: l_columns_tbl hr_dm_library.t_varchar2_tbl;

395: l_cursor_defination varchar2(2000);
396: l_cursor_select_cols varchar2(32767);
397: l_cursor_select_from varchar2(32767);
398: l_cursor_select_where varchar2(32767);
399: l_columns_tbl hr_dm_library.t_varchar2_tbl;
400: l_prefix_col varchar2(30);
401: l_proc varchar2(75) ;
402: begin
403: l_proc := g_package || 'prepare_download_cursor' ;

Line 500: l_columns_tbl hr_dm_library.t_varchar2_tbl;

496: -- indentation for the statements.it specifies number of blank spaces
497: -- after which the staement should start.
498:
499: l_indent number;
500: l_columns_tbl hr_dm_library.t_varchar2_tbl;
501:
502: l_proc_body_tbl t_varchar2_32k_tbl;
503: l_proc_index number := 1;
504:

Line 785: hr_dm_library.get_package_version ( p_package_name => 'BEN_DM_GEN_DOENLOAD',

781: ben_dm_data_util.get_generator_version(p_generator_version => l_generator_version,
782: p_format_output => 'Y');
783:
784: -- Get the package version of this TDS package body.
785: hr_dm_library.get_package_version ( p_package_name => 'BEN_DM_GEN_DOENLOAD',
786: p_package_version => l_package_version,
787: p_version_type => 'FULL');
788:
789:

Line 867: hr_dm_library.run_sql( l_header );

863: --
864: -- Compile the header and body.
865: --
866:
867: hr_dm_library.run_sql( l_header );
868: hr_dm_library.run_sql( g_package_body,
869: g_package_index);
870:
871:

Line 868: hr_dm_library.run_sql( g_package_body,

864: -- Compile the header and body.
865: --
866:
867: hr_dm_library.run_sql( l_header );
868: hr_dm_library.run_sql( g_package_body,
869: g_package_index);
870:
871:
872: -- check the status of the package

Line 876: hr_dm_library.check_compile (p_object_name => l_package_name,

872: -- check the status of the package
873: hr_utility.set_location('PACKAGE BODY :'||l_package_name, 5);
874: -- check the status of the package
875: begin
876: hr_dm_library.check_compile (p_object_name => l_package_name,
877: p_object_type => 'PACKAGE BODY' );
878: exception
879: when others then
880: ben_dm_utility.error(SQLCODE,'Error in compiling TDS for ' ||