eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.XDO_DGF_RPT_PKG

Source


1 PACKAGE xdo_dgf_rpt_pkg as
2 /* $Header: XDODGFRPS.pls 120.0 2008/01/19 00:13:50 bgkim noship $ */
3 
4 
5   -- Public type declarations
6   type RULE_RECORD_TYPE is record (
7     id                   integer,
8     rule_short_name      varchar2(20),
9     rule_type            varchar2(1),
10     rule_variable        varchar2(2000),
11     rule_operator        varchar2(4),
12     rule_values          varchar2(2000),
13     rule_values_datatype varchar2(1),
14     db_function          varchar2(80),
15     arg_number           number,
16     arg01                varchar2(2000),
17     arg02                varchar2(2000),
18     arg03                varchar2(2000),
19     arg04                varchar2(2000),
20     arg05                varchar2(2000),
21     arg06                varchar2(2000),
22     arg07                varchar2(2000),
23     arg08                varchar2(2000),
24     arg09                varchar2(2000),
25     arg10                varchar2(2000),
26     arg01_type           varchar2(1),
27     arg02_type           varchar2(1),
28     arg03_type           varchar2(1),
29     arg04_type           varchar2(1),
30     arg05_type           varchar2(1),
31     arg06_type           varchar2(1),
32     arg07_type           varchar2(1),
33     arg08_type           varchar2(1),
34     arg09_type           varchar2(1),
35     arg10_type           varchar2(1),
36     return_value         boolean
37   );
38 
39   type RULE_TABLE_TYPE is table of RULE_RECORD_TYPE
40   index by binary_integer;
41 
42   type TPL_RULE_ID_RECORD_TYPE is record (
43        template_code      varchar2(20),
44        rule_id            integer,
45        format_filter_type varchar2(3) default ''
46   );
47 
48   type TPL_RULE_ID_TABLE_TYPE is table of TPL_RULE_ID_RECORD_TYPE
49   index by binary_integer;
50 
51   type TPLT_RECORD_TYPE is record (
52        template_name                 varchar2(40),
53        template_code                 varchar2(40),
54        template_application          varchar2(15), -- added attribute 19.4.2006
55        template_lang_territory_codes varchar2(1000), -- added attribute 28.4.2006
56        template_lang_territory_desc  varchar2(2000), -- added attribute 28.4.2006
57        report_code                   varchar2(40),
58        pdf_format_allowed            varchar2(1) default 'Y',
59        rtf_format_allowed            varchar2(1) default 'Y',
60        htm_format_allowed            varchar2(1) default 'Y',
61        xls_format_allowed            varchar2(1) default 'Y',
62        txt_format_allowed            varchar2(1) default 'Y',
63        printer_allowed               varchar2(1) default 'N',
64        first_r_id                    integer default -1, -- first index to TPL_RULE_ID_TABLE_TYPE
65        last_r_id                     integer default -1  -- last index to TPL_RULE_ID_TABLE_TYPE
66   );
67 
68 
69   type TPLT_TABLE_TYPE is table of TPLT_RECORD_TYPE
70   index by binary_integer;
71 
72   type PARAM_RECORD_TYPE is record (
73        report_code                   varchar2(40),
74        report_application            varchar2(15), -- added attribute 19.4.2006
75        parameter_type                varchar2(1),
76        parameter_name                varchar2(100), -- added attribute 29.11.2006
77        parameter_value               varchar2(500)
78   );
79 
80   type PARAM_TABLE_TYPE is table of PARAM_RECORD_TYPE
81   index by binary_integer;
82 
83   type RPT_RECORD_TYPE is record (
84        report_name                  varchar2(40),
85        report_code                  varchar2(40),
86        report_application           varchar2(15), -- added attribute 19.4.2006
87        rpt_context_id               integer -- added attribute 12.04.2005
88   );
89   type RPT_TABLE_TYPE is  table of RPT_RECORD_TYPE
90   index by binary_integer;
91 
92 
93 
94   -- Public function and procedure declarations
95   procedure get_context_reports(
96                 p_form_code         IN  varchar2,
97                 p_block_code        IN  varchar2,
98                 p_report_table      OUT NOCOPY RPT_TABLE_TYPE,
99                 p_template_table    OUT NOCOPY TPLT_TABLE_TYPE,
100                 p_tpl_rule_id_table OUT NOCOPY TPL_RULE_ID_TABLE_TYPE,
101                 p_rule_table        OUT NOCOPY RULE_TABLE_TYPE);
102 
103   procedure get_report_parameters(
104                 p_rpt_contexts      IN  RPT_TABLE_TYPE,
105                 p_parameters        OUT NOCOPY PARAM_TABLE_TYPE
106                 );
107   procedure prepare_context_lists(p_form_code  IN varchar2,
108                                   p_block_code IN varchar2);
109 
110   procedure filter_templates(p_resolved_rule_list     IN RULE_TABLE_TYPE);
111   procedure filter_templates_o(p_resolved_rule_list_o IN XDO_DGF_RULE_TABLE_TYPE);
112 
113   procedure store_report_list(p_report_list           IN RPT_TABLE_TYPE);
114   procedure store_template_list(p_template_list       IN TPLT_TABLE_TYPE);
115   procedure store_parameter_list(p_parameter_list     IN PARAM_TABLE_TYPE);
116   function get_report_list      return RPT_TABLE_TYPE;
117   function get_template_list    return TPLT_TABLE_TYPE;
118   function get_parameter_list   return PARAM_TABLE_TYPE;
119   function get_rule_list        return RULE_TABLE_TYPE;
120 
121   function get_rule_list_o      return XDO_DGF_RULE_TABLE_TYPE;
122   function get_parameter_list_o return XDO_DGF_PARAM_TABLE_TYPE;
123   function get_template_list_o  return XDO_DGF_TPLT_TABLE_TYPE;
124   function get_report_list_o    return XDO_DGF_RPT_TABLE_TYPE;
125 
126   -- procedure test;
127 end XDO_DGF_RPT_PKG;