1 PACKAGE FA_CUA_DERIVE_ASSET_ATTR_PKG AS
2 /* $Header: FACDAAMS.pls 120.1 2002/11/12 07:53:46 glchen ship $ */
3
4 -- Enter package declarations as shown below
5 TYPE asset_attr_rec IS RECORD (
6 parent_hierarchy_id NUMBER
7 , parent_hierarchy_id_old NUMBER
8 , asset_id NUMBER
9 , rule_set_id NUMBER
10 , depr_start_date DATE
11 , asset_category_id NUMBER
12 , lease_id NUMBER
13 , dist_set_id NUMBER
14 , asset_key_ccid NUMBER
15 , serial_number VARCHAR2(35)
16 , life_in_months NUMBER );
17
18 TYPE asset_tabtype IS TABLE OF asset_attr_rec
19 INDEX BY BINARY_INTEGER ;
20
21 -- -----------------------------------------------------------
22 -- event_name:
23 -- CHNG_PARENT_NODE - change parent on a node
24 -- CHNG_NODE_ATTR_VAL - change node attribute value
25 -- CHNG_RULE_SET - change rule set
26 -- CHNG_PARNT_OF_ASSET - change parent of an asset
27 -- CHNG_LEASE - change lease
28 -- CHNG_ASSET_CTGRY_LIFE - change life on asset category
29 -- CHNG_ASSET_CTGRY_END_DTE - change end date on asset category
30 -- -------------------------------------------------------------
31 PROCEDURE select_assets( x_event_code IN VARCHAR2
32 , x_book_type_code IN VARCHAR2
33 , x_book_class IN VARCHAR2
34 , x_src_entity_value IN VARCHAR2
35 , x_parent_id_new IN NUMBER
36 , x_asset_array OUT NOCOPY asset_tabtype
37 , x_err_code IN OUT NOCOPY VARCHAR2
38 , x_err_stage IN OUT NOCOPY VARCHAR2
39 , x_err_stack IN OUT NOCOPY VARCHAR2 );
40
41 -- -------------------------------------------------------
42
43
44 -- -------------------------------------------------------
45 PROCEDURE insert_mass_update_batch_hdrs(
46 x_event_code IN VARCHAR2
47 , x_book_type_code IN VARCHAR2
48 , x_status_code IN VARCHAR2 DEFAULT NULL
49 , x_source_entity_name IN VARCHAR2
50 , x_source_entity_key_value IN VARCHAR2
51 , x_source_attribute_name IN VARCHAR2
52 , x_source_attribute_old_id IN VARCHAR2
53 , x_source_attribute_new_id IN VARCHAR2
54 , x_description IN VARCHAR2 DEFAULT NULL
55 , x_amortize_flag IN VARCHAR2
56 , x_amortization_date IN DATE
57 , x_rejection_reason_code IN VARCHAR2 DEFAULT NULL
58 , x_concurrent_request_id IN NUMBER DEFAULT NULL
59 , x_created_by IN NUMBER DEFAULT NULL
60 , x_creation_date IN DATE DEFAULT NULL
61 , x_last_updated_by IN NUMBER DEFAULT NULL
62 , x_last_update_date IN DATE DEFAULT NULL
63 , x_last_update_login IN NUMBER DEFAULT NULL
64 , x_batch_number IN OUT NOCOPY VARCHAR2
65 , x_batch_id IN OUT NOCOPY NUMBER
66 , x_transaction_name IN VARCHAR2 DEFAULT NULL
67 , x_attribute_category IN VARCHAR2 DEFAULT NULL
68 , x_attribute1 IN VARCHAR2 DEFAULT NULL
69 , x_attribute2 IN VARCHAR2 DEFAULT NULL
70 , x_attribute3 IN VARCHAR2 DEFAULT NULL
71 , x_attribute4 IN VARCHAR2 DEFAULT NULL
72 , x_attribute5 IN VARCHAR2 DEFAULT NULL
73 , x_attribute6 IN VARCHAR2 DEFAULT NULL
74 , x_attribute7 IN VARCHAR2 DEFAULT NULL
75 , x_attribute8 IN VARCHAR2 DEFAULT NULL
76 , x_attribute9 IN VARCHAR2 DEFAULT NULL
77 , x_attribute10 IN VARCHAR2 DEFAULT NULL
78 , x_attribute11 IN VARCHAR2 DEFAULT NULL
79 , x_attribute12 IN VARCHAR2 DEFAULT NULL
80 , x_attribute13 IN VARCHAR2 DEFAULT NULL
81 , x_attribute14 IN VARCHAR2 DEFAULT NULL
82 , x_attribute15 IN VARCHAR2 DEFAULT NULL
83 , x_err_code IN OUT NOCOPY VARCHAR2
84 , x_err_stage IN OUT NOCOPY VARCHAR2
85 , x_err_stack IN OUT NOCOPY VARCHAR2 );
86
87
88 -- ---------------------------------------------------------
89
90 -- ---------------------------------------------------------
91 PROCEDURE insert_mass_update_batch_dtls (
92 x_batch_id IN NUMBER
93 , x_book_type_code IN VARCHAR2
94 , x_attribute_name IN VARCHAR2
95 , x_asset_id IN NUMBER
96 , x_attribute_old_value IN VARCHAR2
97 , x_attribute_new_value IN VARCHAR2
98 , x_derived_from_entity IN VARCHAR2
99 , x_derived_from_entity_id IN NUMBER
100 , x_parent_hierarchy_id IN NUMBER
101 , x_status_code IN VARCHAR2
102 , x_rejection_reason IN VARCHAR2
103 , x_apply_flag IN VARCHAR2
104 , x_effective_date IN DATE
105 , x_fa_period_name IN VARCHAR2
106 , x_concurrent_request_id IN NUMBER
107 , x_created_by IN NUMBER
108 , x_creation_date IN DATE
109 , x_last_updated_by IN NUMBER
110 , x_last_update_date IN DATE
111 , x_last_update_login IN NUMBER
112 , x_err_code IN OUT NOCOPY VARCHAR2
113 , x_err_stage IN OUT NOCOPY VARCHAR2
114 , x_err_stack IN OUT NOCOPY VARCHAR2 );
115
116 END FA_CUA_DERIVE_ASSET_ATTR_PKG;