[Home] [Help]
18:
19: RETURN ( g_book_type_code );
20: END Get_book_type_code;
21:
22: Procedure put_book_type_code (v_book_type_code in VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
23: IS
24: BEGIN
25:
26: g_book_type_code := v_book_type_code;
25:
26: g_book_type_code := v_book_type_code;
27: END put_book_type_code;
28:
29: Procedure put_asset_id (v_asset_id in NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
30: IS
31: BEGIN
32:
33: g_life_asset_id := v_asset_id;
40:
41: RETURN ( g_life_asset_id );
42: END Get_asset_id;
43:
44: Procedure put_transaction_id (v_transaction_id in NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
45: IS
46: BEGIN
47:
48: g_transaction_id := v_transaction_id;
63: , x_parent_hierarchy_id in out nocopy number
64: , x_asset_id in out nocopy number
65: , x_err_code in out nocopy varchar2
66: , x_err_stage in out nocopy varchar2
67: , x_err_stack in out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)IS
68:
69:
70: BEGIN
71: fa_cua_hierarchy_pkg.create_node(x_asset_hierarchy_purpose_id=>x_asset_hierarchy_purpose_id,
85: x_parent_hierarchy_id in out nocopy number,
86: x_parent_hierarchy_name in out nocopy varchar2,
87: x_asset_purpose_id in out nocopy number,
88: x_asset_purpose_name in out nocopy varchar2,
89: x_purpose_book_type_code in out nocopy varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
90:
91:
92: v_corp_book varchar2(30);
93:
139:
140:
141: End get_asset_parent;
142:
143: Function get_category_id (x_concatenated_segments in varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return number is
144: cursor c is
145: select category_id
146: from fa_categories_b_kfv
147: where concatenated_segments = x_concatenated_segments;
153: close c;
154: return v_category_id;
155: end get_category_id;
156:
157: Function get_category_name (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2 is
158: cursor c is
159: select concatenated_segments
160: from fa_categories_b_kfv
161: where category_id = x_id;
168: return v_concatenated_segments;
169: end get_category_name;
170:
171:
172: Function get_asset_key_name (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2 is
173: cursor c is
174: select concatenated_segments
175: from fa_asset_keywords_kfv
176: where code_combination_id = x_id;
182: close c;
183: return v_concatenated_segments;
184: end get_asset_key_name;
185:
186: Function get_location_name (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2 is
187: cursor c is
188: select concatenated_segments
189: from fa_locations_kfv
190: where location_id = x_id;
196: close c;
197: return v_concatenated_segments;
198: end get_location_name;
199:
200: Function get_account_code_name (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2 is
201: cursor c is
202: select concatenated_segments
203: from gl_code_combinations_kfv
204: where code_combination_id = x_id;
211: return v_concatenated_segments;
212: end get_account_code_name;
213:
214:
215: Function get_employee_name (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2 is
216: cursor c is
217: select name
218: from fa_employees
219: where employee_id = x_id;
226: close c;
227: return v_name;
228: end get_employee_name;
229:
230: Function get_employee_number (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2 is
231: cursor c is
232: select employee_number
233: from fa_employees
234: where employee_id = x_id;
241: close c;
242: return v_employee_number;
243: end get_employee_number;
244:
245: Function get_lease_number (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2 is
246:
247: v_lease_number fa_leases.lease_number%type;
248: cursor c is
249: select lease_number
256:
257: return v_lease_number;
258: End get_lease_number;
259:
260: Function get_lease_id (x_lease_number in varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return number is
261:
262: v_lease_id number ;
263: cursor c is
264: select lease_id
273: End get_lease_id;
274:
275: Function derive_override_flag(x_rule_set_id in number,
276: x_attribute_name in varchar2,
277: x_book_type_code in varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2 is
278: cursor c is
279: SELECT override_allowed_flag
280: FROM FA_HIERARCHY_RULE_DETAILS
281: WHERE hierarchy_rule_set_id = x_rule_set_id
290: End derive_override_flag;
291:
292: Function check_distribution_match(x_Asset_id in number,
293: x_book_type_code in varchar2,
294: x_mode in varchar2 default 'SHOWERR', p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean is
295:
296:
297: h_dist_count number;
298: h_dist_count2 number;
367: return true;
368: end if;
369: end check_distribution_match;
370:
371: Function get_node_name (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2
372: is
373: v_node_name fa_asset_hierarchy.name%type;
374: cursor c is
375: select name
382:
383: return v_node_name;
384: End get_node_name;
385:
386: Function get_node_level (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2
387: is
388: v_node_level fa_asset_hierarchy.level_number%type;
389: cursor c is
390: select level_number
397:
398: return to_char(v_node_level);
399: End get_node_level;
400:
401: Function get_rule_set_name (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2
402: is
403: v_rule_set_name fa_hierarchy_rule_set.name%type;
404: cursor c is
405: select name
412:
413: return v_rule_set_name;
414: End get_rule_set_name;
415:
416: Function get_asset_number (x_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return varchar2
417: is
418: v_asset_number fa_additions.asset_number%TYPE;
419: cursor C is
420: select asset_number
427:
428: return v_asset_number;
429: End get_asset_number;
430:
431: Function check_batch_details_exists(x_batch_id in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
432: return boolean
433: is
434: dummy number;
435: Begin
442: when no_data_found then
443: return FALSE;
444: End check_batch_details_exists;
445:
446: Function check_deprn_method(x_cat_id in varchar2, x_book_type_code in varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean
447: is
448: v_dummy varchar2(20);
449: cursor c is
450: select rate_source_rule
465: end if;
466: End check_deprn_method;
467:
468: FUNCTION GET_PERIOD_END_DATE(X_book_type_code VARCHAR2,
469: x_date DATE, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return date IS
470: CURSOR C IS
471: select (cp.end_date)
472: from fa_calendar_periods cp,
473: fa_calendar_types ct,
492: x_deprn_start_date in date,
493: x_prorate_date out nocopy date
494: ,x_err_code in out nocopy varchar2
495: ,x_err_stage in out nocopy varchar2
496: ,x_err_stack in out nocopy varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
497: is
498: CURSOR C is
499: select prorate_convention_code
500: from fa_category_book_defaults
534: x_book_type_code varchar2,
535: x_transaction_id number,
536: x_derived_from_entity in out nocopy varchar2 ,
537: x_derived_from_entity_name in out nocopy varchar2,
538: x_level_number in out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
539: x_derived_from_entity_id number;
540: cursor c is
541: Select fl.meaning, decode(derived_from_entity,
542: 'NODE', FA_CUA_ASSET_WB_APIS_PKG.get_node_name(derived_from_entity_id),
573: End get_life_derivation_info;
574:
575: Procedure remove_adjustments (x_asset_id in number,
576: x_book_type_code in varchar2,
577: x_thid in number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
578: BEGIN
579:
580: /* To be called when processing an asset reclassification (category change):
581: For group member assets, the source and destination assets reserve