DBA Data[Home] [Help]

APPS.BEN_DM_GEN_UPLOAD dependencies on BEN_DM_GEN_DOWNLOAD

Line 27: l_spaces := ben_dm_gen_download.indent(p_indent_spaces => p_indent_spaces,

23: ) return varchar2 is
24: l_spaces varchar2(100);
25: begin
26:
27: l_spaces := ben_dm_gen_download.indent(p_indent_spaces => p_indent_spaces,
28: p_newline => p_newline ) ;
29: return l_spaces;
30: end indent;
31:

Line 141: p_table_info in ben_dm_gen_download.t_ben_dm_table,

137: -- Generates the upload procedure of the upload
138: -- ------------------------------------------------------------------------
139: procedure generate_upload
140: (
141: p_table_info in ben_dm_gen_download.t_ben_dm_table,
142: p_header in out nocopy varchar2,
143: p_body in out nocopy varchar2
144: )
145: is

Line 226: l_locals := ben_dm_gen_download.format_comment('Declare cursors and local variables',2)

222: l_proc_index := l_proc_index + 1;
223:
224: -- local variables of the procedure
225:
226: l_locals := ben_dm_gen_download.format_comment('Declare cursors and local variables',2)
227: || indent ||
228: ' l_proc varchar2(72) := g_package '|| '|| ''upload'';' || indent ||
229: ' l_fk_map_id number ;' || indent ||
230: ' l_table_name varchar2(72) ;' || indent ||

Line 265: l_proc_comment := ben_dm_gen_download.format_comment('procedure to upload all columns of '

261:
262: end if ;
263:
264:
265: l_proc_comment := ben_dm_gen_download.format_comment('procedure to upload all columns of '
266: || upper(p_table_info.table_name) || ' from entity results .')||
267: indent;
268:
269: -- add the procedure comment defination to the package header and body

Line 297: p_table_info in ben_dm_gen_download.t_ben_dm_table

293: -- Generates the insert_dml procedure of the TUPS
294: -- ------------------------------------------------------------------------
295: procedure generate_insert_dml
296: (
297: p_table_info in ben_dm_gen_download.t_ben_dm_table
298: )
299: is
300: l_locals varchar2(32767) := null;
301: l_cursor varchar2(32767) := null;

Line 745: l_tbl_rec ben_dm_gen_download.t_ben_dm_table ;

741: ,LAST_UPDATE_DATE
742: from ben_dm_tables
743: where table_alias = p_table_alias
744: ;
745: l_tbl_rec ben_dm_gen_download.t_ben_dm_table ;
746:
747:
748:
749: