[Home] [Help]
PACKAGE: APPS.GLR03300_PKG
Source
1 PACKAGE GLR03300_PKG AS
2 /* $Header: gl03300s.pls 120.7 2005/05/05 02:01:14 kvora ship $ */
3 --
4 -- Package
5 -- GLR03300_pkg
6 -- Purpose
7 -- To contain database functions needed in Account Inquiry form
8 -- History
9 -- 09-01-94 Kai Pigg Created
10
11 --
12 -- PUBLIC VARIABLES
13 --
14 code_combination_id NUMBER;
15 budget_version_id NUMBER;
16 encumbrance_type_id NUMBER;
17 template_id NUMBER;
18 factor NUMBER;
19 currency_code VARCHAR2(30);
20 translated_flag VARCHAR2(1);
21 balance_type VARCHAR2(1);
22 currency_type VARCHAR2(1);
23 actual_flag VARCHAR2(1);
24 sec_actual_flag VARCHAR2(1);
25 sec_budget_version_id NUMBER;
26 sec_encumbrance_type_id NUMBER;
27 ledger_id NUMBER;
28 period_name VARCHAR2(15);
29 ar_code_combination_id NUMBER;
30 ledger_currency VARCHAR2(30);
31
32 --
33 -- PUBLIC PROCEDURES
34 --
35
36 --
37 -- Procedure
38 -- set_criteria
39 -- PURPOSE sets ALL (non-secondary) the package (global) variables
40 -- History: 09-02-94 Kai Pigg Created
41 -- Arguments: All the global values of this package
42 -- Notes:
43 PROCEDURE set_criteria (X_code_combination_id NUMBER,
44 X_budget_version_id NUMBER,
45 X_encumbrance_type_id NUMBER,
46 X_template_id NUMBER,
47 X_factor NUMBER,
48 X_currency_code VARCHAR2,
49 X_translated_flag VARCHAR2,
50 X_balance_type VARCHAR2,
51 X_currency_type VARCHAR2,
52 X_actual_flag VARCHAR2,
53 X_ledger_id NUMBER,
54 X_period_name VARCHAR2,
55 X_ledger_currency VARCHAR2);
56 --
57 -- Procedure
58 -- set_sec_criteria
59 -- PURPOSE sets ALL the package (global) variables
60 -- History: 09-05-94 Kai Pigg Created
61 -- Arguments: All the global values of this package
62 -- Notes:
63 PROCEDURE set_sec_criteria (X_code_combination_id NUMBER,
64 X_budget_version_id NUMBER,
65 X_encumbrance_type_id NUMBER,
66 X_template_id NUMBER,
67 X_factor NUMBER,
68 X_currency_code VARCHAR2,
69 X_translated_flag VARCHAR2,
70 X_balance_type VARCHAR2,
71 X_currency_type VARCHAR2,
72 X_actual_flag VARCHAR2,
73 X_sec_actual_flag VARCHAR2,
74 X_sec_budget_version_id NUMBER,
75 X_sec_encumbrance_type_id NUMBER,
76 X_ledger_id NUMBER,
77 X_period_name VARCHAR2,
78 X_ledger_currency VARCHAR2);
79 --
80 -- Procedure
81 -- set_ledger_id
82 -- PURPOSE sets the ledger_id
83 -- History: 09-12-94 Kai Pigg Created
84 -- 05-feb-03 vchikkar renamed
85 -- Arguments: ledger_id
86 -- Notes:
87 PROCEDURE set_ledger_id (X_ledger_id NUMBER);
88
89 --
90 -- Procedure
91 -- set_ar_cc
92 -- PURPOSE sets the code_combination_id for ar drill down
93 -- History: 01-20-9 Kai Pigg Created
94 -- Arguments: code_combination_id
95 -- Notes:
96 PROCEDURE set_ar_cc (X_ar_code_combination_id NUMBER);
97
98
99
100 -- Procedure
101 -- populate_fields
102 -- PURPOSE Populates the USER_JE_SOURCE_NAME,USER_JE_CATEGORY ,ENCUMBRANCE_TYPE ,
103 -- BUDGET_NAME ,SHOW_BATCH_STATUS , SHOW_BC_STATUS
104 -- History: 16-sep-2002 KAKRISHN Created
105 -- Arguments: X_header_id IN ,
106 -- X_user_je_source_name OUT NOCOPY VARCHAR2,
107 -- X_user_je_category_name OUT NOCOPY VARCHAR2 ,
108 -- X_encumbrance_type OUT NOCOPY VARCHAR2 ,
109 -- X_budget_name OUT NOCOPY VARCHAR2
110 -- X_show_batch_status OUT NOCOPY VARCHAR2 ,
111 -- X_show_bc_status OUT NOCOPY VARCHAR2
112
113 -- Notes:
114 -- This procedure is called in post query trigger of JOURNALS block at GLXIQACC.fmb
115
116 PROCEDURE populate_fields (X_header_id IN NUMBER ,
117 X_user_je_source_name OUT NOCOPY VARCHAR2,
118 X_user_je_category_name OUT NOCOPY VARCHAR2 ,
119 X_encumbrance_type OUT NOCOPY VARCHAR2 ,
120 X_budget_name OUT NOCOPY VARCHAR2 ,
121 X_show_batch_status OUT NOCOPY VARCHAR2 ,
122 X_show_bc_status OUT NOCOPY VARCHAR2 );
123
124 --
125 -- Procedure
126 -- get_ar_cc
127 -- PURPOSE gets the package (global) variable, USED in base view's where part
128 -- History: 01-20-95 Kai Pigg Created
129 -- Notes
130 --
131 FUNCTION get_ar_cc RETURN NUMBER;
132 PRAGMA RESTRICT_REFERENCES(get_ar_cc,WNDS,WNPS);
133
134 --
135 -- PUBLIC FUNCTIONS
136 --
137 --
138 -- Procedure
139 -- get_code_combination_id
140 -- PURPOSE gets the package (global) variable, USED in base view's where part
141 -- History: 09-01-94 Kai Pigg Created
142 -- Notes
143 --
144 FUNCTION get_code_combination_id RETURN NUMBER;
145 PRAGMA RESTRICT_REFERENCES(get_code_combination_id,WNDS,WNPS);
146
147 --
148 -- Procedure
149 -- get_budget_version_id
150 -- PURPOSE gets the package (global) variable, USED in base view's where part
151 -- History: 09-01-94 Kai Pigg Created
152 -- Notes
153 --
154 FUNCTION get_budget_version_id RETURN NUMBER;
155 PRAGMA RESTRICT_REFERENCES(get_budget_version_id,WNDS,WNPS);
156 --
157 -- Procedure
158 -- get_encumbrance_type_id
159 -- PURPOSE gets the package (global) variable, USED in base view's where part
160 -- History: 09-01-94 Kai Pigg Created
161 -- Notes
162 --
163 FUNCTION get_encumbrance_type_id RETURN NUMBER;
164 PRAGMA RESTRICT_REFERENCES(get_encumbrance_type_id,WNDS,WNPS);
165 --
166 -- Procedure
167 -- get_template_id
168 -- PURPOSE gets the package (global) variable, USED in base view's where part
169 -- History: 09-01-94 Kai Pigg Created
170 -- Notes
171 --
172 FUNCTION get_template_id RETURN NUMBER;
173 PRAGMA RESTRICT_REFERENCES(get_template_id,WNDS,WNPS);
174 --
175 -- Procedure
176 -- get_entered_currency_code
177 -- PURPOSE gets the package (global) variable, USED in base view's where part
178 -- History: 09-01-94 Kai Pigg Created
179 -- Notes
180 --
181 FUNCTION get_entered_currency_code RETURN VARCHAR2;
182 PRAGMA RESTRICT_REFERENCES(get_entered_currency_code,WNDS,WNPS);
183 --
184 -- Procedure
185 -- get_translated_flag
186 -- PURPOSE gets the package (global) variable, USED in base view's where part
187 -- History: 09-01-94 Kai Pigg Created
188 -- Notes
189 --
190 FUNCTION get_translated_flag RETURN VARCHAR2;
191 PRAGMA RESTRICT_REFERENCES(get_translated_flag,WNDS,WNPS);
192 --
193 -- Procedure
194 -- get_balance_type
195 -- PURPOSE gets the package (global) variable, USED in base view's where part
196 -- History: 09-01-94 Kai Pigg Created
197 -- Notes
198 --
199 FUNCTION get_balance_type RETURN VARCHAR2;
200 PRAGMA RESTRICT_REFERENCES(get_balance_type,WNDS,WNPS);
201 --
202 -- Procedure
203 -- get_factor
204 -- PURPOSE gets the package (global) variable, USED in base view's where part
205 -- History: 09-01-94 Kai Pigg Created
206 -- Notes
207 --
208 FUNCTION get_factor RETURN NUMBER;
209 PRAGMA RESTRICT_REFERENCES(get_factor,WNDS,WNPS);
210
211 --
212 -- Procedure
213 -- get_currency_type
214 -- PURPOSE gets the package (global) variable, USED in base view's where part
215 -- History: 09-02-94 Kai Pigg Created
216 -- Notes
217 --
218 FUNCTION get_currency_type RETURN VARCHAR2;
219 PRAGMA RESTRICT_REFERENCES(get_currency_type,WNDS,WNPS);
220 --
221 -- Procedure
222 -- get_actual_flag
223 -- PURPOSE gets the package (global) variable, USED in base view's where part
224 -- History: 09-02-94 Kai Pigg Created
225 -- Notes
226 --
227 FUNCTION get_actual_flag RETURN VARCHAR2;
228 PRAGMA RESTRICT_REFERENCES(get_actual_flag,WNDS,WNPS);
229
230 --
231 -- Procedure
232 -- get_sec_actual_flag
233 -- PURPOSE gets the package (global) variable, USED in base view's where part
234 -- History: 09-05-94 Kai Pigg Created
235 -- Notes
236 --
237 FUNCTION get_sec_actual_flag RETURN VARCHAR2;
238 PRAGMA RESTRICT_REFERENCES(get_sec_actual_flag,WNDS,WNPS);
239 --
240 -- Procedure
241 -- get_sec_budget_version_id
242 -- PURPOSE gets the package (global) variable, USED in base view's where part
243 -- History: 09-05-94 Kai Pigg Created
244 -- Notes
245 --
246 FUNCTION get_sec_budget_version_id RETURN NUMBER;
247 PRAGMA RESTRICT_REFERENCES(get_sec_budget_version_id,WNDS,WNPS);
248 --
249 -- Procedure
250 -- get_sec_encumbrance_type_id
251 -- PURPOSE gets the package (global) variable, USED in base view's where part
252 -- History: 09-05-94 Kai Pigg Created
253 -- Notes
254 --
255 FUNCTION get_sec_encumbrance_type_id RETURN NUMBER;
256 PRAGMA RESTRICT_REFERENCES(get_sec_encumbrance_type_id,WNDS,WNPS);
257
258 --
259 -- Procedure
260 -- get_functional_currency_code
261 -- PURPOSE gets the package (global) variable, USED in base view's where part
262 -- History: 09-07-94 Kai Pigg Created
263 -- Notes
264 --
265 -- FUNCTION get_functional_currency_code RETURN VARCHAR2;
266 -- PRAGMA RESTRICT_REFERENCES(get_functional_currency_code,WNDS,WNPS);
267
268 --
269 -- Procedure
270 -- get_ledger_id
271 -- PURPOSE gets the package (global) variable, USED in base view's where part
272 -- History: 09-07-94 Kai Pigg Created
273 -- 28-jan-03 vchikkar renamed
274 -- Notes
275 --
276 FUNCTION get_ledger_id RETURN NUMBER;
277 PRAGMA RESTRICT_REFERENCES(get_ledger_id,WNDS,WNPS);
278
279 --
280 -- Procedure
281 -- get_period_name
282 -- PURPOSE gets the package (global) variable, USED in base view's where part
283 -- History: 09-07-94 Kai Pigg Created
284 -- Notes
285 --
286 FUNCTION get_period_name RETURN VARCHAR2;
287 PRAGMA RESTRICT_REFERENCES(get_period_name,WNDS,WNPS);
288
289 --
290 -- Procedure
291 -- get_ledger_currency
292 -- PURPOSE gets the package (global) variable, USED in base view's where part
293 -- History: 09-07-94 Kai Pigg Created
294 -- Notes
295 --
296 FUNCTION get_ledger_currency RETURN VARCHAR2;
297 PRAGMA RESTRICT_REFERENCES(get_ledger_currency,WNDS,WNPS);
298
299
300 END GLR03300_PKG;