1 PACKAGE CSE_ASSET_CLIENT_EXT_STUB AUTHID CURRENT_USER AS
2 -- $Header: CSEFASTS.pls 120.5.12020000.2 2012/07/04 15:29:04 dsingire ship $
3
4 PROCEDURE get_asset_name(
5 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
6 x_asset_name OUT NOCOPY VARCHAR2,
7 x_hook_used OUT NOCOPY NUMBER,
8 x_error_msg OUT NOCOPY VARCHAR2);
9
10 PROCEDURE get_asset_description(
11 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
12 , x_description OUT NOCOPY VARCHAR2
13 , x_hook_used OUT NOCOPY NUMBER
14 , x_error_msg OUT NOCOPY VARCHAR2) ;
15
16 PROCEDURE skip_asset_creation(
17 p_inventory_item_id IN OUT NOCOPY NUMBER
18 , p_organization_id IN OUT NOCOPY NUMBER
19 , p_csi_transaction_id IN OUT NOCOPY NUMBER
20 , p_depreciable_item_flag IN OUT NOCOPY VARCHAR2
21 , x_skip_flag OUT NOCOPY VARCHAR2
22 , x_hook_used out nocopy NUMBER
23 , x_error_msg OUT NOCOPY VARCHAR2) ;
24
25 PROCEDURE get_asset_type_n_dpis (
26 p_instance_id IN NUMBER
27 , p_inventory_item_id IN NUMBER
28 , x_asset_type OUT NOCOPY VARCHAR2
29 , x_date_placed_inservice OUT NOCOPY DATE
30 , x_hook_used out nocopy NUMBER
31 , x_error_msg OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE populate_mass_addition_dff (
35 x_mass_add_rec IN OUT NOCOPY fa_mass_additions%rowtype
36 , x_hook_used out nocopy NUMBER
37 , x_error_msg OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE get_asset_category(
41 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
42 , x_hook_used OUT NOCOPY NUMBER
43 , x_error_msg OUT NOCOPY VARCHAR2) ;
44
45 PROCEDURE get_book_type(
46 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
47 , x_hook_used OUT NOCOPY NUMBER
48 , x_error_msg OUT NOCOPY VARCHAR2) ;
49
50 PROCEDURE get_date_place_in_service(
51 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
52 , x_in_service_date OUT NOCOPY DATE
53 , x_hook_used OUT NOCOPY NUMBER
54 , x_error_msg OUT NOCOPY VARCHAR2) ;
55
56 PROCEDURE get_asset_key(
57 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
58 , x_asset_key_ccid OUT NOCOPY NUMBER
59 , x_hook_used OUT NOCOPY NUMBER
60 , x_error_msg OUT NOCOPY VARCHAR2) ;
61
62 PROCEDURE get_asset_location(
63 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
64 , x_hook_used OUT NOCOPY NUMBER
65 , x_error_msg OUT NOCOPY VARCHAR2) ;
66
67 PROCEDURE get_deprn_expense_ccid(
68 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
69 , x_deprn_expense_ccid OUT NOCOPY NUMBER
70 , x_hook_used OUT NOCOPY NUMBER
71 , x_error_msg OUT NOCOPY VARCHAR2) ;
72
73 PROCEDURE get_search_method(
74 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
75 , x_search_method OUT NOCOPY VARCHAR2
76 , x_hook_used OUT NOCOPY NUMBER
77 , x_error_msg OUT NOCOPY VARCHAR2) ;
78
79 PROCEDURE get_tag_number(
80 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
81 , x_tag_number OUT NOCOPY VARCHAR2
82 , x_hook_used OUT NOCOPY NUMBER
83 , x_error_msg OUT NOCOPY VARCHAR2) ;
84
85 PROCEDURE get_model_number(
86 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
87 , x_model_number OUT NOCOPY VARCHAR2
88 , x_hook_used OUT NOCOPY NUMBER
89 , x_error_msg OUT NOCOPY VARCHAR2) ;
90
91 PROCEDURE get_manufacturer(
92 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
93 , x_manufacturer_name OUT NOCOPY VARCHAR2
94 , x_hook_used OUT NOCOPY NUMBER
95 , x_error_msg OUT NOCOPY VARCHAR2) ;
96
97 PROCEDURE get_employee(
98 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
99 , x_employee_id OUT NOCOPY NUMBER
100 , x_hook_used OUT NOCOPY NUMBER
101 , x_error_msg OUT NOCOPY VARCHAR2) ;
102
103 PROCEDURE get_payables_ccid(
104 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
105 , x_payables_ccid OUT NOCOPY NUMBER
106 , x_hook_used OUT NOCOPY NUMBER
107 , x_error_msg OUT NOCOPY VARCHAR2) ;
108
109 PROCEDURE get_txn_class_flag(
110 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
111 , p_txn_class IN VARCHAR2
112 , x_process_flag OUT NOCOPY VARCHAR2
113 , x_hook_used OUT NOCOPY NUMBER
114 , x_error_msg OUT NOCOPY VARCHAR2) ;
115
116 PRAGMA RESTRICT_REFERENCES(get_txn_class_flag, WNDS);
117
118 PROCEDURE get_catchup_flag(
119 p_asset_number IN VARCHAR2,
120 p_instance_asset_id IN NUMBER,
121 x_catchup_flag OUT NOCOPY VARCHAR2,
122 x_hook_used OUT NOCOPY NUMBER,
123 x_error_msg OUT NOCOPY VARCHAR2);
124
125 PROCEDURE get_inv_depr_acct(
126 p_mtl_transaction_id IN NUMBER
127 , x_dummy_acct_id OUT NOCOPY NUMBER
128 , x_hook_used OUT NOCOPY NUMBER
129 , x_error_msg OUT NOCOPY VARCHAR2) ;
130
131 PROCEDURE get_inventory_item(
132 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
133 , x_hook_used OUT NOCOPY NUMBER
134 , x_error_msg OUT NOCOPY VARCHAR2) ;
135
136 PROCEDURE get_non_mtl_retire_flag(
137 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
138 p_asset_id IN NUMBER
139 , x_retire_flag OUT NOCOPY VARCHAR2
140 , x_hook_used OUT NOCOPY NUMBER
141 , x_error_msg OUT NOCOPY VARCHAR2) ;
142 PRAGMA RESTRICT_REFERENCES(get_inventory_item, WNDS);
143
144 PROCEDURE get_product_code(
145 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
146 x_product_code OUT NOCOPY VARCHAR2
147 , x_hook_used OUT NOCOPY NUMBER
148 , x_error_msg OUT NOCOPY VARCHAR2) ;
149
150 --Added for bug 9644951
151 PROCEDURE get_redeploy_flag(
152 p_inventory_item_id IN NUMBER,
153 p_serial_number IN VARCHAR2,
154 p_transaction_date IN DATE,
155 x_redeploy_flag OUT NOCOPY VARCHAR2,
156 x_hook_used OUT NOCOPY NUMBER,
157 x_error_msg OUT NOCOPY VARCHAR2);
158
159 PROCEDURE derive_po_distribution_id (
160 p_invoice_distribution_id IN NUMBER,
161 p_line_type_lookup_code IN VARCHAR2,
162 x_derived_po_distribution_id OUT NOCOPY NUMBER,
163 x_hook_used OUT NOCOPY NUMBER,
164 x_error_msg OUT NOCOPY VARCHAR2);
165
166
167 END CSE_ASSET_CLIENT_EXT_STUB ;