1 PACKAGE JG_GL_ACCT_HIER_PKG AS
2 /* $Header: jgglachs.pls 120.1.12010000.1 2008/07/28 07:54:49 appldev ship $ */
3
4 --
5 -- PUBLIC FUNCTIONS
6 --
7
8 --
9 -- Procedure
10 -- populate_acct_hier_table
11 -- Purpose
12 -- Populate the account hierarchy temporary table.
13 -- Parameter
14 -- p_value_set_id Account Segment Value Set ID
15 -- p_top_parent_acct The Top Level Parent Account Value
16 -- Note
17 -- Must be called before attempting to retrieve level account value/desc.
18 --
19 PROCEDURE populate_acct_hier_table(p_value_set_id IN NUMBER,
20 p_top_parent_acct IN VARCHAR2);
21
22 --
23 -- Function
24 -- get_level_acct_value
25 -- Purpose
26 -- Get the specified level's account value.
27 -- Parameter
28 -- p_value_set_id Account Segment Value Set ID
29 -- p_report_acct_level Account Level for the Report
30 -- p_detail_acct The Detail Account Value
31 -- p_detail_acct_desc The Detail Account Value Description
32 -- p_acct_delimiter Account Delimiter
33 -- p_level Level of the Requested Value
34 -- Note
35 --
36 FUNCTION get_level_acct_value(p_value_set_id IN NUMBER,
37 p_report_acct_level IN NUMBER,
38 p_detail_acct IN VARCHAR2,
39 p_detail_acct_desc IN VARCHAR2,
40 p_acct_delimiter IN VARCHAR2,
41 p_level IN NUMBER)
42 RETURN VARCHAR2;
43
44 --
45 -- Function
46 -- get_level_acct_desc
47 -- Purpose
48 -- Get the specified level's account value description.
49 -- Parameter
50 -- p_value_set_id Account Segment Value Set ID
51 -- p_report_acct_level Account Level for the Report
52 -- p_detail_acct The Detail Account Value
53 -- p_detail_acct_desc The Detail Account Value Description
54 -- p_acct_delimiter Account Delimiter
55 -- p_level Level of the Requested Value Description
56 -- Note
57 --
58 FUNCTION get_level_acct_desc(p_value_set_id IN NUMBER,
59 p_report_acct_level IN NUMBER,
60 p_detail_acct IN VARCHAR2,
61 p_detail_acct_desc IN VARCHAR2,
62 p_acct_delimiter IN VARCHAR2,
63 p_level IN NUMBER)
64 RETURN VARCHAR2;
65
66 --
67 -- Function
68 -- get_delimited_detail_acct
69 -- Purpose
70 -- Get the detail account value with delimiters.
71 -- Parameter
72 -- p_value_set_id Account Segment Value Set ID
73 -- p_report_acct_level Account Level for the Report
74 -- p_detail_acct The Detail Account Value
75 -- p_detail_acct_desc The Detail Account Value Description
76 -- p_acct_delimiter Account Delimiter
77 -- Note
78 --
79 FUNCTION get_delimited_detail_acct(p_value_set_id IN NUMBER,
80 p_report_acct_level IN NUMBER,
81 p_detail_acct IN VARCHAR2,
82 p_detail_acct_desc IN VARCHAR2,
83 p_acct_delimiter IN VARCHAR2)
84 RETURN VARCHAR2;
85
86 END JG_GL_ACCT_HIER_PKG;