1 PACKAGE PER_GENERIC_REPORT_PKG AUTHID CURRENT_USER AS
2 /* $Header: pergenrp.pkh 115.0 99/07/18 14:47:23 porting ship $ */
3 /*===========================================================================+
4 | Copyright (C) 1995 Oracle Corporation |
5 | All rights reserved |
6 | |
7 +===========================================================================*/
8 --
9 /*
10 Name
11 PER_GENERIC_REPORT_PKG
12 Purpose
13 Contains all the procedures to support the generation of customisable
14 candidate list reports.
15
16 Notes:
17
18 History
19 18-Sep-1995 fshojaas 70.0 Date Created.
20 gperry
21 24-Jul-1997 teyres 70.1 Changed as to is on create or replace line
22 25-Jun-97 teyres 110.1/70.2 110.1 and 70.2 are the same
23
24
25 ============================================================================*/
26 --
27 -- This procedure is an example of a one parameter customisable report. The
28 -- procedure includes some example custom formatting.
29 --
30 procedure example1(p_param_1 varchar2
31 );
32 --
33 -- This procedure is an example of a two parameter customisable report. The
34 -- procedure includes some example custom formatting.
35 --
36 procedure example2(p_param_1 varchar2,
37 p_param_2 varchar2
38 );
39 --
40 -- This procedure is an example of a three parameter customisable report.
41 -- The procedure includes some example custom formatting.
42 --
43 procedure example3(p_param_1 varchar2,
44 p_param_2 varchar2,
45 p_param_3 varchar2
46 );
47 --
48 -- This procedure is used to define report header, footer and title
49 -- requirements. This also calls the appropriate procedure (example1,
50 -- example2,example3) based on the report name being processed.
51 --
52 procedure generate_report(p_report_name varchar2,
53 p_param_1 varchar2,
54 p_param_2 varchar2,
55 p_param_3 varchar2,
56 p_param_4 varchar2,
57 p_param_5 varchar2,
58 p_param_6 varchar2,
59 p_param_7 varchar2,
60 p_param_8 varchar2,
61 p_param_9 varchar2,
62 p_param_10 varchar2,
63 p_param_11 varchar2,
64 p_param_12 varchar2
65 );
66 --
67 -- This function is used as an initial validation check before submitting
68 -- the report to the concurrent request manager.
69 --
70 function launch_report(p_report_name varchar2,
71 p_param_1 varchar2,
72 p_param_2 varchar2,
73 p_param_3 varchar2,
74 p_param_4 varchar2,
75 p_param_5 varchar2,
76 p_param_6 varchar2,
77 p_param_7 varchar2,
78 p_param_8 varchar2,
79 p_param_9 varchar2,
80 p_param_10 varchar2,
81 p_param_11 varchar2,
82 p_param_12 varchar2
83 ) return boolean;
84 --
85 END PER_GENERIC_REPORT_PKG;