1 PACKAGE xla_report_utility_pkg AUTHID CURRENT_USER AS
2 -- $Header: xlarputl.pkh 120.3.12010000.4 2009/04/17 09:08:59 svellani ship $
3 /*===========================================================================+
4 | Copyright (c) 2003 Oracle Corporation BelmFont, California, USA |
5 | ALL rights reserved. |
6 +============================================================================+
7 | FILENAME |
8 | xlarputl.pkh |
9 | |
10 | PACKAGE NAME |
11 | xla_report_utility_pkg |
12 | |
13 | DESCRIPTION |
14 | Package specification. This provides routines that support reports |
15 | |
16 | HISTORY |
17 | 04/15/2005 V. Kumar Created |
18 | 12/23/2005 V. Kumar Added function get_transaction_id |
19 | 06/23/2006 V. Kumar Added function get_conc_segments |
20 | 02/16/2009 N. K. Surana Overloading function get_transaction_id |
21 | to support more than 50 event classes per |
22 | application id required for FSAH |
23 +===========================================================================*/
24
25 PROCEDURE get_acct_qualifier_segs
26 (p_coa_id IN NUMBER
27 ,p_balance_segment OUT NOCOPY VARCHAR2
28 ,p_account_segment OUT NOCOPY VARCHAR2
29 ,p_cost_center_segment OUT NOCOPY VARCHAR2
30 ,p_management_segment OUT NOCOPY VARCHAR2
31 ,p_intercompany_segment OUT NOCOPY VARCHAR2);
32
33 FUNCTION get_ccid_desc
34 (p_coa_id IN NUMBER
35 ,p_ccid IN NUMBER)
36 RETURN VARCHAR2;
37
38 PROCEDURE get_transaction_id
39 (p_application_id IN INTEGER
40 ,p_entity_code IN VARCHAR2
41 ,p_event_class_code IN VARCHAR2
42 ,p_reporting_view_name IN VARCHAR2
43 ,p_select_str OUT NOCOPY VARCHAR2
44 ,p_from_str OUT NOCOPY VARCHAR2
45 ,p_where_str OUT NOCOPY VARCHAR2);
46
47
48 PROCEDURE get_segment_info
49 (p_coa_id IN NUMBER
50 ,p_balancing_segment IN VARCHAR2
51 ,p_account_segment IN VARCHAR2
52 ,p_costcenter_segment IN VARCHAR2
53 ,p_management_segment IN VARCHAR2
54 ,p_intercompany_segment IN VARCHAR2
55 ,p_alias_balancing_segment IN VARCHAR2
56 ,p_alias_account_segment IN VARCHAR2
57 ,p_alias_costcenter_segment IN VARCHAR2
58 ,p_alias_management_segment IN VARCHAR2
59 ,p_alias_intercompany_segment IN VARCHAR2
60 ,p_seg_desc_column OUT NOCOPY VARCHAR2
61 ,p_seg_desc_from OUT NOCOPY VARCHAR2
62 ,p_seg_desc_join OUT NOCOPY VARCHAR2
63 ,p_hint OUT NOCOPY VARCHAR2);
64
65 PROCEDURE clob_to_file
66 (p_xml_clob IN CLOB);
67
68 FUNCTION get_anc_filter
69 (p_anc_level IN VARCHAR2
70 ,p_table_alias IN VARCHAR2
71 ,p_anc_detail_code IN VARCHAR2
72 ,p_anc_detail_value IN VARCHAR2)
73 RETURN VARCHAR2;
74
75 FUNCTION get_ledger_id
76 (p_ledger_id IN NUMBER)
77 RETURN NUMBER;
78
79 FUNCTION get_ledger_object_type
80 (p_ledger_id IN NUMBER)
81 RETURN VARCHAR2;
82
83 FUNCTION is_primary_ledger (p_ledger_id IN NUMBER)
84 RETURN NUMBER;
85
86 FUNCTION get_transaction_id( p_resp_application_id IN NUMBER
87 ,p_ledger_id IN NUMBER )
88 RETURN VARCHAR2;
89
90 --Added for Bug 7580995
91 PROCEDURE get_transaction_id(p_resp_application_id IN NUMBER
92 ,p_ledger_id IN NUMBER
93 ,p_trx_identifiers_1 OUT NOCOPY VARCHAR2
94 ,p_trx_identifiers_2 OUT NOCOPY VARCHAR2
95 ,p_trx_identifiers_3 OUT NOCOPY VARCHAR2
96 ,p_trx_identifiers_4 OUT NOCOPY VARCHAR2
97 ,p_trx_identifiers_5 OUT NOCOPY VARCHAR2);
98
99 --
100 -- Function to return Concatenated segment string for COA
101 --
102 FUNCTION get_conc_segments(p_coa_id NUMBER
103 ,p_table_alias VARCHAR2)
104 RETURN VARCHAR2;
105
106 END xla_report_utility_pkg;