1 PACKAGE ENI_DBI_UTIL_PKG AS
2 /*$Header: ENIUTILS.pls 120.0 2005/05/26 19:37:11 appldev noship $*/
3
4 FUNCTION GetXTDLabel( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
5 RETURN VARCHAR2;
6
7 FUNCTION Rolling_Lab(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
8 RETURN VARCHAR2; -- Returns the Rolling Period Labels
9
10 PROCEDURE get_time_clauses
11 (
12 p_measure_type IN VARCHAR2,
13 p_summary_alias in VARCHAR2,
14 p_period_type IN VARCHAR2,
15 p_period_bitand IN NUMBER,
16 p_as_of_date IN DATE,
17 p_prev_as_of_date IN DATE,
18 p_report_start IN DATE,
19 p_cur_period IN NUMBER,
20 p_days_into_period IN NUMBER,
21 p_comp_type IN VARCHAR2,
22 p_id_column IN VARCHAR2,
23 p_from_clause OUT NOCOPY VARCHAR2,
24 p_where_clause OUT NOCOPY VARCHAR2,
25 p_group_by_clause OUT NOCOPY VARCHAR2,
26 -- Added this default parameter for Rolling periods implementation.
27 p_rolling VARCHAR2 DEFAULT 'ENTERPRISE'
28 );
29
30 PROCEDURE get_parameters
31 (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
32 p_period_type OUT NOCOPY VARCHAR2,
33 p_period_bitand OUT NOCOPY NUMBER,
34 p_view_by OUT NOCOPY VARCHAR2,
35 p_as_of_date OUT NOCOPY DATE,
36 p_prev_as_of_date OUT NOCOPY DATE,
37 p_report_start OUT NOCOPY DATE,
38 p_cur_period OUT NOCOPY NUMBER,
39 p_days_into_period OUT NOCOPY NUMBER,
40 p_comp_type OUT NOCOPY VARCHAR2,
41 p_category OUT NOCOPY VARCHAR2,
42 p_item OUT NOCOPY VARCHAR2,
43 p_org OUT NOCOPY VARCHAR2,
44 p_id_column OUT NOCOPY VARCHAR2,
45 p_order_by OUT NOCOPY VARCHAR2,
46 p_drill OUT NOCOPY VARCHAR2,
47 p_status OUT NOCOPY VARCHAR2,
48 p_priority OUT NOCOPY VARCHAR2,
49 p_reason OUT NOCOPY VARCHAR2,
50 p_lifecycle_phase OUT NOCOPY VARCHAR2,
51 p_currency OUT NOCOPY VARCHAR2,
52 p_bom_type OUT NOCOPY VARCHAR2,
53 p_type OUT NOCOPY VARCHAR2,
54 p_manager OUT NOCOPY VARCHAR2,
55 p_lob OUT NOCOPY VARCHAR2
56 );
57
58 -- This procedure provides a level of indirection between
59 -- the standard DBI logging procedure and the ENI collection
60 -- packages.
61 PROCEDURE log(p_message VARCHAR2,
62 p_indenting NUMBER DEFAULT 0);
63
64 -- This procedure provides a level of indirection between
65 -- the standard DBI logging procedure and the ENI collection
66 -- packages.
67 PROCEDURE debug(p_message VARCHAR2,
68 p_indenting NUMBER DEFAULT 0);
69
70 -- This procedure initializes the debug logging for our
71 -- PL/SQL report packages.
72 --
73 -- Parameters
74 -- p_rpt_name: The FND function name of the report
75 -- which is to be debugged
76 PROCEDURE init_rpt(p_rpt_func_name VARCHAR2);
77
78 -- This procedure writes a debug message to the
79 -- file previously opened by the init procedure
80 --
81 -- Parameters
82 -- p_message: The string which is to be written into
83 -- the log
84 PROCEDURE debug_rpt(p_message VARCHAR2);
85
86 -- This wrapper function supplies the mandatory time dimension parameters
87 -- in addition to those returned by the bil_bi_util_pkg.get_dbi_params.
88 -- Form function for the page has been modified to call
89 -- this function instead of bil_bi_util_pkg.get_dbi_params
90 -- Created to fix bug - bug# 3771850
91 FUNCTION get_all_dbi_params(p_region_code varchar2) return varchar2;
92
93 -- Returns the primary currency identifier
94 FUNCTION get_curr_prim RETURN VARCHAR2;
95
96 -- Returns the secondary currency identifier
97 FUNCTION get_curr_sec RETURN VARCHAR2;
98
99 END;