1 PACKAGE FA_CUA_ASSET_WB_APIS_PKG AS
2 /* $Header: FACHRAWMS.pls 120.1 2002/11/12 07:55:10 glchen ship $*/
3
4 -- Used as a global variable to show info in the Life Derivation Form
5 g_life_asset_id number;
6 g_transaction_id number;
7 g_book_type_code varchar2(30);
8
9 FUNCTION Is_CRLFA_Enabled RETURN Boolean;
10
11 Procedure put_book_type_code (v_book_type_code in VARCHAR2);
12
13 Procedure put_transaction_id (v_transaction_id in NUMBER);
14
15 Procedure put_asset_id (v_asset_id in NUMBER);
16
17 FUNCTION Get_transaction_id RETURN NUMBER;
18 pragma restrict_references (get_transaction_id,WNPS,WNDS);
19
20 Function check_batch_details_exists(x_batch_id in number)
21 return boolean;
22
23 FUNCTION Get_asset_id RETURN NUMBER;
24
25 FUNCTION Get_book_type_code RETURN VARCHAR2;
26
27 PROCEDURE create_node( x_asset_hierarchy_purpose_id in out nocopy number
28 , x_asset_hierarchy_id in out nocopy number
29 , x_name in varchar2
30 , x_hierarchy_rule_set_id in out nocopy number
31 , x_parent_hierarchy_id in out nocopy number
32 , x_asset_id in out nocopy number
33 ,x_err_code in out nocopy varchar2
34 ,x_err_stage in out nocopy varchar2
35 ,x_err_stack in out nocopy varchar2 );
36
37 Procedure get_asset_parent (x_asset_id in number,
38 x_parent_hierarchy_id in out nocopy number,
39 x_parent_hierarchy_name in out nocopy varchar2,
40 x_asset_purpose_id in out nocopy number,
41 x_asset_purpose_name in out nocopy varchar2,
42 x_purpose_book_type_code in out nocopy varchar2 ) ;
43
44 Function get_category_name (x_id in number) return varchar2;
45 pragma restrict_references (get_category_name,WNPS,WNDS);
46
47 Function get_lease_number (x_id in number) return varchar2;
48 pragma restrict_references (get_lease_number,WNPS,WNDS);
49
50 Function get_asset_key_name (x_id in number) return varchar2;
51 pragma restrict_references (get_asset_key_name,WNPS,WNDS);
52
53 Function get_location_name (x_id in number) return varchar2;
54 pragma restrict_references (get_location_name,WNPS,WNDS);
55
56 Function get_account_code_name (x_id in number) return varchar2;
57 pragma restrict_references (get_account_code_name,WNPS,WNDS);
58
59 Function get_employee_name (x_id in number) return varchar2;
60 pragma restrict_references (get_employee_name,WNPS,WNDS);
61
62 Function get_employee_number (x_id in number) return varchar2;
63 pragma restrict_references (get_employee_number,WNPS,WNDS);
64
65 Function derive_override_flag(x_rule_set_id in number,
66 x_attribute_name in varchar2,
67 x_book_type_code in varchar2) return varchar2 ;
68
69 Function get_lease_id (x_lease_number in varchar2) return number ;
70
71 Function get_category_id(x_concatenated_segments in varchar2) return number ;
72
73 Function get_node_name (x_id in number) return varchar2;
74 pragma restrict_references (get_node_name,WNPS,WNDS);
75
76 Function get_node_level(x_id in number) return varchar2;
77 pragma restrict_references (get_node_level,WNPS,WNDS);
78
79 Function get_rule_set_name (x_id in number) return varchar2;
80 pragma restrict_references (get_rule_set_name,WNPS,WNDS);
81
82 Function get_asset_number (x_id in number) return varchar2;
83 pragma restrict_references (get_asset_number,WNPS,WNDS);
84
85 FUNCTION GET_PERIOD_END_DATE(X_book_type_code VARCHAR2,
86 x_date DATE) return date ;
87 pragma restrict_references (GET_PERIOD_END_DATE,WNPS,WNDS);
88
89 Procedure get_prorate_date ( x_category_id in number,
90 x_book in varchar2,
91 x_deprn_start_date in date,
92 x_prorate_date out nocopy date
93 ,x_err_code in out nocopy varchar2
94 ,x_err_stage in out nocopy varchar2
95 ,x_err_stack in out nocopy varchar2 );
96
97 Procedure get_life_derivation_info(x_asset_id in number,
98 x_book_type_code varchar2,
99 x_transaction_id number,
100 x_derived_from_entity in out nocopy varchar2 ,
101 x_derived_from_entity_name in out nocopy varchar2,
102 x_level_number in out nocopy varchar2 ) ;
103
104 Function check_distribution_match(x_Asset_id in number,
105 x_book_type_code in varchar2,
106 x_mode in varchar2 default 'SHOWERR') return boolean ;
107
108 Procedure remove_adjustments (x_asset_id in number,
109 x_book_type_code in varchar2,
110 x_thid in number);
111
112 END FA_CUA_ASSET_WB_APIS_PKG;