1 PACKAGE GL_FORMSINFO2 AS
2 /* $Header: gligcf2s.pls 120.4 2005/05/05 01:08:02 kvora ship $ */
3
4 -- NAME
5 -- get_coa_info
6 -- DESCRIPTION
7 -- Gets various chart of accounts attributes based on
8 -- the coa id provided.
9 -- PARAMETERS
10 PROCEDURE get_coa_info (x_chart_of_accounts_id IN NUMBER,
11 x_segment_delimiter IN OUT NOCOPY VARCHAR2,
12 x_enabled_segment_count IN OUT NOCOPY NUMBER,
13 x_segment_order_by IN OUT NOCOPY VARCHAR2,
14 x_accseg_segment_num IN OUT NOCOPY NUMBER,
15 x_accseg_app_col_name IN OUT NOCOPY VARCHAR2,
16 x_accseg_left_prompt IN OUT NOCOPY VARCHAR2,
17 x_balseg_segment_num IN OUT NOCOPY NUMBER,
18 x_balseg_app_col_name IN OUT NOCOPY VARCHAR2,
19 x_balseg_left_prompt IN OUT NOCOPY VARCHAR2,
20 x_ieaseg_segment_num IN OUT NOCOPY NUMBER,
21 x_ieaseg_app_col_name IN OUT NOCOPY VARCHAR2,
22 x_ieaseg_left_prompt IN OUT NOCOPY VARCHAR2);
23
24 -- NAME
25 -- get_sob_info
26 -- DESCRIPTION
27 -- Gets various set of books attributes based on
28 -- the set of books id provided.
29 -- PARAMETERS
30 PROCEDURE get_sob_info ( X_set_of_books_id IN NUMBER,
31 X_chart_of_accounts_id IN OUT NOCOPY NUMBER,
32 X_name IN OUT NOCOPY VARCHAR2,
33 X_short_name IN OUT NOCOPY VARCHAR2,
34 X_currency_code IN OUT NOCOPY VARCHAR2,
35 X_period_set_name IN OUT NOCOPY VARCHAR2,
36 X_accounted_period_type IN OUT NOCOPY VARCHAR2,
37 X_suspense_allowed_flag IN OUT NOCOPY VARCHAR2,
38 X_allow_intercompany_post_flag IN OUT NOCOPY VARCHAR2,
39 X_require_budget_journals_flag IN OUT NOCOPY VARCHAR2,
40 X_enable_bc_flag IN OUT NOCOPY VARCHAR2,
41 X_latest_opened_period_name IN OUT NOCOPY VARCHAR2,
42 X_latest_encumbrance_year IN OUT NOCOPY NUMBER,
43 X_future_enterable_periods IN OUT NOCOPY NUMBER,
44 X_cum_trans_ccid IN OUT NOCOPY NUMBER,
45 X_ret_earn_ccid IN OUT NOCOPY NUMBER,
46 X_res_encumb_ccid IN OUT NOCOPY NUMBER,
47 X_enable_average_balances_flag IN OUT NOCOPY VARCHAR2,
48 X_transaction_calendar_id IN OUT NOCOPY NUMBER,
49 X_net_income_ccid IN OUT NOCOPY NUMBER,
50 X_consolidation_sob_flag IN OUT NOCOPY VARCHAR2,
51 X_daily_translation_rate_type IN OUT NOCOPY VARCHAR2,
52 X_enable_automatic_tax_flag IN OUT NOCOPY VARCHAR2,
53 X_mrc_sob_type_code IN OUT NOCOPY VARCHAR2,
54 X_enable_je_approval_flag IN OUT NOCOPY VARCHAR2 );
55
56 -- NAME
57 -- multi_org
58 -- DESCRIPTION
59 -- Returns TRUE if this is a multi-org environment and false otherwise
60 -- PARAMETERS
61 FUNCTION multi_org RETURN BOOLEAN;
62
63 -- NAME
64 -- install_info
65 -- DESCRIPTION
66 -- Just calls fnd_installation.get to workaround a forms bug
67 -- PARAMETERS
68 FUNCTION install_info(appl_id IN NUMBER,
69 dep_appl_id IN NUMBER,
70 status OUT NOCOPY VARCHAR2,
71 industry OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
72
73 --
74 -- Procedure
75 -- get_iea_info
76 -- Purpose
77 -- Used to select all of the information about a subsidiary
78 -- History
79 -- 01-16-97 D. J. Ogg Created
80 -- 11-12-98 S Kung Added parameters for data model changes.
81 -- Arguments
82 -- x_subsidiary_id ID of subsidiary to get information
83 -- about
84 -- x_name Name of subsidiary
85 -- x_chart_of_accounts_id ID of chart of accounts used by
86 -- subsidiary
87 -- x_set_of_books_id ID of set of books used by subsidiary
88 -- x_enabled_flag Enabled flag of subsidiary
89 -- x_subsidiary_type_code P - parent, S - subsidiary
90 -- x_company_value Company value of subsidiary
91 -- x_currency_code Functional currency of subsidiary
92 -- x_autoapprove_flag Y - subsidiary has autoapproval.
93 -- N - subsidiary does not.
94 -- x_view_partner_lines_flag Y - subsidiary can access
95 -- partner lines.
96 -- N - subsidiary cannot.
97 -- x_conversion_type_code D - Daily Rates.
98 -- P - Period Rates.
99 -- x_conversion_type Conversion type for transactions
100 -- x_remote_instance_flag Y - Transfer Set of Books is on
101 -- a remote instance.
102 -- N - Transfer Set of Books is on
103 -- local instance.
104 -- x_transfer_set_of_books_id Transfer Set of Books ID.
105 -- x_transfer_currency_code Transfer currency code.
106 -- x_contact Workflow role to send
107 -- notification when threshold is
108 -- reached.
109 -- x_notification_threshold Notification Threshold level
110 -- in transfer currency.
111 -- Example
112 -- gl_formsinfo2.get_iea_info(100, :name, :coa_id, :sob_id,
113 -- :enabled_flag, :sub_type_code,
114 -- :company_code, :currency_code,
115 -- :autoapprove_flag);
116 -- Notes
117 --
118 PROCEDURE get_iea_info(x_subsidiary_id NUMBER,
119 x_name IN OUT NOCOPY VARCHAR2,
120 x_chart_of_accounts_id IN OUT NOCOPY NUMBER,
121 x_set_of_books_id IN OUT NOCOPY NUMBER,
122 x_enabled_flag IN OUT NOCOPY VARCHAR2,
123 x_subsidiary_type_code IN OUT NOCOPY VARCHAR2,
124 x_company_value IN OUT NOCOPY VARCHAR2,
125 x_currency_code IN OUT NOCOPY VARCHAR2,
126 x_autoapprove_flag IN OUT NOCOPY VARCHAR2,
127 x_view_partner_lines_flag IN OUT NOCOPY VARCHAR2,
128 x_conversion_type_code IN OUT NOCOPY VARCHAR2,
129 x_conversion_type IN OUT NOCOPY VARCHAR2,
130 x_remote_instance_flag IN OUT NOCOPY VARCHAR2,
131 x_transfer_set_of_books_id IN OUT NOCOPY NUMBER,
132 x_transfer_currency_code IN OUT NOCOPY VARCHAR2,
133 x_contact IN OUT NOCOPY VARCHAR2,
134 x_notification_threshold IN OUT NOCOPY NUMBER);
135 --
136 -- Procedure
137 -- get_usage_info
138 -- Purpose
139 -- Gets the values of some columns from gl_system_usages
140 -- History
141 -- 16-JAN-96 D J Ogg Created.
142 -- Arguments
143 -- x_average_balances_flag Indicates whether average balances
144 -- is used in any set of books
145 -- x_consolidation_ledger_flag For indicating if consolidation
146 -- ledger is available in the sob
147 PROCEDURE get_usage_info(
148 x_average_balances_flag IN OUT NOCOPY VARCHAR2,
149 x_consolidation_ledger_flag IN OUT NOCOPY VARCHAR2);
150
151 --
152 -- Procedure
153 -- get_business_days_pattern
154 -- Purpose
155 -- Uses transaction_calendar_id and start and end dates
156 -- to obtain which days are business in the form of a
157 -- binary VARCHAR pattern.
158 -- History
159 -- 16-JAN-96 D J Ogg Created.
160 -- Arguments
161 -- X_transaction_cal_id
162 -- X_start_date
163 -- X_end_date
164 -- X_bus_days_pattern
165 --
166 PROCEDURE get_business_days_pattern(X_transaction_cal_id IN NUMBER,
167 X_start_date IN DATE,
168 X_end_date IN DATE,
169 X_bus_days_pattern IN OUT NOCOPY VARCHAR2);
170
171 --
172 -- Procedure
173 -- iea_disabled_subsidiary
174 -- Purpose
175 -- Check if a GIS subsidiary is disabled.
176 -- Return true if subsidiary is diabled or does not exist.
177 -- History
178 -- 20-MAY-99 Charmaine Wang Created.
179 -- Arguments
180 -- X_Subsidiary_Id
181 --
182 FUNCTION iea_disabled_subsidiary(X_Subsidiary_Id IN NUMBER) RETURN BOOLEAN;
183
184
185 --
186 -- Procedure
187 -- get_industry_message
188 -- Purpose
189 -- Library cover for gl_public_sector.get_message_name
190 -- Given a message name, returns the appropriate message name
191 -- for the industry
192 -- History
193 -- 17-DEC-01 D J Ogg Created
194 -- Arguments
195 -- Message_Name -- Message Name to check
196 -- Application_Shortname -- Application Shortname
197 --
198 FUNCTION get_industry_message(Message_Name IN VARCHAR2,
199 Application_Shortname IN VARCHAR2)
200 RETURN VARCHAR2;
201
202
203
204
205 END GL_FORMSINFO2;