1 PACKAGE XLA_FLEX_UTIL AS
2 /* $Header: xlauflex.pkh 120.1 2004/02/13 22:55:09 weshen noship $ */
3
4 -- Record type to store flexfield segment Number and segment order number
5 TYPE r_segmentInfo IS RECORD (segment_num NUMBER,
6 segment_ordernum NUMBER
7 );
8 TYPE t_segmentInfo IS TABLE OF r_segmentinfo INDEX BY BINARY_INTEGER ;
9
10 /*===========================================================================+
11 | FUNCTION |
12 | getsegmentInfo |
13 | |
14 | DESCRIPTION |
15 | Gets accounting flexfield segment number and segment order number |
16 | |
17 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
18 | |
19 | ARGUMENTS : IN: p_chartofAccountsID |
20 | OUT: p_segmentInfo |
21 | NOTES |
22 | |
23 | MODIFICATION HISTORY |
24 | 17-May-2000 Shishir Joshi Created |
25 | |
26 +===========================================================================*/
27 FUNCTION getsegmentInfo(p_chartofaccountsid IN NUMBER,
28 p_segmentinfo OUT NOCOPY t_segmentInfo
29 ) RETURN BOOLEAN;
30
31 /*===========================================================================+
32 | PROCEDURE |
33 | get_account_flex_info |
34 | |
35 | DESCRIPTION |
36 | Gets accounting flexfield information based on the chart of accounts id|
37 | |
38 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
39 | xla_debug.print |
40 | |
41 | ARGUMENTS : IN: p_application_id -- E.g 222 for Receivables |
42 | p_account_type -- Valid account type internal |
43 | NOTES |
44 | |
45 | MODIFICATION HISTORY |
46 | 30-Oct-98 Mahesh Sabapathy Created |
47 | |
48 +===========================================================================*/
49 PROCEDURE get_account_flex_info (
50 p_chart_of_accounts_id IN NUMBER,
51 x_segment_delimiter IN OUT NOCOPY VARCHAR2,
52 x_enabled_segment_count IN OUT NOCOPY NUMBER,
53 x_segment_order_by IN OUT NOCOPY VARCHAR2,
54 x_accseg_segment_num IN OUT NOCOPY NUMBER,
55 x_accseg_app_col_name IN OUT NOCOPY VARCHAR2,
56 x_accseg_left_prompt IN OUT NOCOPY VARCHAR2,
57 x_balseg_segment_num IN OUT NOCOPY NUMBER,
58 x_balseg_app_col_name IN OUT NOCOPY VARCHAR2,
59 x_balseg_left_prompt IN OUT NOCOPY VARCHAR2);
60
61 /*===========================================================================+
62 | FUNCTION |
63 | get_ordered_account |
64 | |
65 | DESCRIPTION |
66 | return the account ordered by balancing segment, natural account and |
67 | all other segments |
68 | |
69 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
70 | |
71 | ARGUMENTS : IN: p_charts_of_accounts_id |
72 | p_table_alias |
73 | |
74 | NOTES |
75 | |
76 | MODIFICATION HISTORY |
77 | 03-Nov-98 Dirk Stevens Created |
78 | |
79 +===========================================================================*/
80
81 FUNCTION get_ordered_account(
82 p_chart_of_accounts_id IN NUMBER
83 ,p_table_alias IN VARCHAR2 )
84 RETURN VARCHAR2;
85
86 /*===========================================================================+
87 | FUNCTION |
88 | is_segment_dependent |
89 | |
90 | DESCRIPTION |
91 | returns 'Y' if the segment is dependent |
92 | |
93 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
94 | |
95 | ARGUMENTS : IN: segment |
96 | |
97 | NOTES |
98 | |
99 | MODIFICATION HISTORY |
100 | 15-Apr-98 Dirk Stevens Created |
101 | |
102 +===========================================================================*/
103
104 FUNCTION is_segment_dependent(segment IN NUMBER
105 ,p_ChartOfAccountsID IN NUMBER
106 ,p_flex_code IN VARCHAR2
107 ,p_applicationID IN NUMBER)
108 RETURN VARCHAR2;
109
110 /*===========================================================================+
111 | PROCEDURE |
112 | get_parent_segment |
113 | |
114 | DESCRIPTION |
115 | Returns parent segment number and application column name for a |
116 | given child segment number and structure id. |
117 | |
118 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
119 | |
120 | |
121 | ARGUMENTS |
122 | p_application_id IN NUMBER, |
123 | p_flex_code IN VARCHAR2 |
124 | p_structure_id IN NUMBER |
125 | p_child_segment_num IN NUMBER |
126 | p_parent_segment_num OUT NOCOPY NUMBER |
127 | p_parent_col_name OUT NOCOPY VARCHAR |
128 | |
129 | |
130 | |
131 | NOTES |
132 | |
133 | MODIFICATION HISTORY |
134 | 03-Aug-99 Shishir Joshi Created |
135 | |
136 +===========================================================================*/
137
138
139 PROCEDURE get_parent_segment(p_application_id IN NUMBER
140 ,p_flex_code IN VARCHAR2
141 ,p_structure_id IN NUMBER
142 ,p_child_segment_num IN NUMBER
143 ,p_parent_segment_num OUT NOCOPY NUMBER
144 ,p_parent_col_name OUT NOCOPY VARCHAR2);
145
146 /*===========================================================================+
147 | FUNCTION |
148 | get_segment_number |
149 | |
150 | DESCRIPTION |
151 | Returns segment number for a given chart of accounts and qualifier. |
152 | This function was added because fnd_flex_apis does not have an api |
153 | to return the segment number for a qualifier. |
154 | |
155 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
156 | |
157 | |
158 | ARGUMENTS |
159 | p_application_id IN NUMBER, |
160 | p_flex_code IN VARCHAR2 |
161 | p_structure_id IN NUMBER |
162 | p_flex_qual_name IN VARCHAR2 |
163 | p_seg_num OUT NOCOPY NUMBER |
164 | |
165 | |
166 | |
167 | NOTES |
168 | |
169 | MODIFICATION HISTORY |
170 | 10-May-00 Dimple Shah Created |
171 | |
172 +===========================================================================*/
173
174
175 FUNCTION get_segment_number(p_application_id IN NUMBER,
176 p_flex_code IN VARCHAR2,
177 p_structure_id IN NUMBER,
178 p_flex_qual_name IN VARCHAR2,
179 p_seg_num OUT NOCOPY NUMBER)
180 RETURN BOOLEAN;
181
182 END XLA_FLEX_UTIL;
|
|
|