[Home] [Help]
PACKAGE: APPS.XLA_REPORT_UTILITY_PKG
Source
1 PACKAGE xla_report_utility_pkg AS
2 -- $Header: xlarputl.pkh 120.3 2006/06/23 16:53:12 vinaykum noship $
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 | |
21 +===========================================================================*/
22
23 PROCEDURE get_acct_qualifier_segs
24 (p_coa_id IN NUMBER
25 ,p_balance_segment OUT NOCOPY VARCHAR2
26 ,p_account_segment OUT NOCOPY VARCHAR2
27 ,p_cost_center_segment OUT NOCOPY VARCHAR2
28 ,p_management_segment OUT NOCOPY VARCHAR2
29 ,p_intercompany_segment OUT NOCOPY VARCHAR2);
30
31 FUNCTION get_ccid_desc
32 (p_coa_id IN NUMBER
33 ,p_ccid IN NUMBER)
34 RETURN VARCHAR2;
35
36 PROCEDURE get_transaction_id
37 (p_application_id IN INTEGER
38 ,p_entity_code IN VARCHAR2
39 ,p_event_class_code IN VARCHAR2
40 ,p_reporting_view_name IN VARCHAR2
41 ,p_select_str OUT NOCOPY VARCHAR2
42 ,p_from_str OUT NOCOPY VARCHAR2
43 ,p_where_str OUT NOCOPY VARCHAR2);
44
45 PROCEDURE clob_to_file
46 (p_xml_clob IN CLOB);
47
48 FUNCTION get_anc_filter
49 (p_anc_level IN VARCHAR2
50 ,p_table_alias IN VARCHAR2
51 ,p_anc_detail_code IN VARCHAR2
52 ,p_anc_detail_value IN VARCHAR2)
53 RETURN VARCHAR2;
54
55 FUNCTION get_ledger_id
56 (p_ledger_id IN NUMBER)
57 RETURN NUMBER;
58
59 FUNCTION get_ledger_object_type
60 (p_ledger_id IN NUMBER)
61 RETURN VARCHAR2;
62
63 FUNCTION is_primary_ledger (p_ledger_id IN NUMBER)
64 RETURN NUMBER;
65
66 FUNCTION get_transaction_id( p_resp_application_id IN NUMBER
67 ,p_ledger_id IN NUMBER )
68 RETURN VARCHAR2;
69
70 --
71 -- Function to return Concatenated segment string for COA
72 --
73 FUNCTION get_conc_segments(p_coa_id NUMBER
74 ,p_table_alias VARCHAR2)
75 RETURN VARCHAR2;
76
77 END xla_report_utility_pkg;