[Home] [Help]
110: -- Insert values into body of table with some example formatting.
111: -- In this case we insert the full_name and the sex which we
112: -- align using an lpad statement.
113: --
114: insert into per_generic_report_output
115: (line_type,line_number,line_content)
116: values ('B',l_recs_inserted,l_full_name||
117: lpad(l_sex,50-length(l_full_name),' '));
118: l_recs_inserted := l_recs_inserted + 1;
189: --
190: -- Insert values into body of table with some example formatting.
191: -- In this case we insert some spaces and full_name in upper case.
192: --
193: insert into per_generic_report_output
194: (line_type,line_number,line_content)
195: values ('B',l_recs_inserted,' '||upper(l_full_name));
196: l_recs_inserted := l_recs_inserted + 1;
197: hr_utility.set_location(l_proc,25);
277: -- Insert values into body of table with some example formatting.
278: -- In this case we insert the sex and then some spaces followed
279: -- by the full_name in initcaps.
280: --
281: insert into per_generic_report_output
282: (line_type,line_number,line_content)
283: values ('B',l_recs_inserted,l_sex||' '||initcap(l_full_name));
284: l_recs_inserted := l_recs_inserted + 1;
285: hr_utility.set_location(l_proc,30);
328: -- (This is the value of the twelvth parameter on the
329: -- screen).
330: -- Values Returned : none
331: -- Description : This procedure calls procedures which populate
332: -- the per_generic_report_output table with the
333: -- formatting required by the customer.
334: --
335: -- *************************************************************************
336: procedure generate_report(p_report_name varchar2,
354: l_proc varchar(72) := g_package || 'generate_report';
355: begin
356: hr_utility.set_location('Entering: ' ||l_proc,5);
357: --
358: -- Delete existing data from per_generic_report_output
359: --
360: delete from per_generic_report_output;
361: --
362: -- Table per_generic_report_output has the following fields
356: hr_utility.set_location('Entering: ' ||l_proc,5);
357: --
358: -- Delete existing data from per_generic_report_output
359: --
360: delete from per_generic_report_output;
361: --
362: -- Table per_generic_report_output has the following fields
363: -- Line Type T = Title, H = Header, B = Body, F = Footer
364: -- field type = varchar2(1)
358: -- Delete existing data from per_generic_report_output
359: --
360: delete from per_generic_report_output;
361: --
362: -- Table per_generic_report_output has the following fields
363: -- Line Type T = Title, H = Header, B = Body, F = Footer
364: -- field type = varchar2(1)
365: -- Line Number field type = number(9)
366: -- Line Text field type = long
370: --
371: -- NOTE: The user may insert their own header into the next line instead of
372: -- the 'Example Title - Oracle Corporation UK Ltd'
373: --
374: insert into per_generic_report_output
375: (line_type,line_number,line_content)
376: values ('H',1,'Example Title - Oracle Corporation UK Ltd');
377: --
378: -- Insert footer information into table
380: --
381: -- NOTE: The user may insert their own footer into the next line instead
382: -- of the 'Example Footer - Oracle Corporation UK Ltd'.
383: --
384: insert into per_generic_report_output
385: (line_type,line_number,line_content)
386: values ('F',1,'Example Footer - Oracle Corporation UK Ltd');
387: --
388: -- Insert title information into table, in this case p_report_name
387: --
388: -- Insert title information into table, in this case p_report_name
389: -- This will be displayed as the title for the report
390: --
391: insert into per_generic_report_output
392: (line_type,line_number,line_content)
393: values ('T',1,p_report_name);
394: --
395: -- Depending on the report name run different procedures