1 PACKAGE CSE_ASSET_CLIENT_EXT_STUB AS
2 -- $Header: CSEFASTS.pls 120.2.12010000.1 2008/07/30 05:17:35 appldev 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 get_asset_category(
17 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
18 , x_hook_used OUT NOCOPY NUMBER
19 , x_error_msg OUT NOCOPY VARCHAR2) ;
20
21 PROCEDURE get_book_type(
22 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
23 , x_hook_used OUT NOCOPY NUMBER
24 , x_error_msg OUT NOCOPY VARCHAR2) ;
25
26 PROCEDURE get_date_place_in_service(
27 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
28 , x_in_service_date OUT NOCOPY DATE
29 , x_hook_used OUT NOCOPY NUMBER
30 , x_error_msg OUT NOCOPY VARCHAR2) ;
31
32 PROCEDURE get_asset_key(
33 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
34 , x_asset_key_ccid OUT NOCOPY NUMBER
35 , x_hook_used OUT NOCOPY NUMBER
36 , x_error_msg OUT NOCOPY VARCHAR2) ;
37
38 PROCEDURE get_asset_location(
39 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
40 , x_hook_used OUT NOCOPY NUMBER
41 , x_error_msg OUT NOCOPY VARCHAR2) ;
42
43 PROCEDURE get_deprn_expense_ccid(
44 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
45 , x_deprn_expense_ccid OUT NOCOPY NUMBER
46 , x_hook_used OUT NOCOPY NUMBER
47 , x_error_msg OUT NOCOPY VARCHAR2) ;
48
49 PROCEDURE get_search_method(
50 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
51 , x_search_method OUT NOCOPY VARCHAR2
52 , x_hook_used OUT NOCOPY NUMBER
53 , x_error_msg OUT NOCOPY VARCHAR2) ;
54
55 PROCEDURE get_tag_number(
56 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
57 , x_tag_number OUT NOCOPY VARCHAR2
58 , x_hook_used OUT NOCOPY NUMBER
59 , x_error_msg OUT NOCOPY VARCHAR2) ;
60
61 PROCEDURE get_model_number(
62 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
63 , x_model_number OUT NOCOPY VARCHAR2
64 , x_hook_used OUT NOCOPY NUMBER
65 , x_error_msg OUT NOCOPY VARCHAR2) ;
66
67 PROCEDURE get_manufacturer(
68 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
69 , x_manufacturer_name OUT NOCOPY VARCHAR2
70 , x_hook_used OUT NOCOPY NUMBER
71 , x_error_msg OUT NOCOPY VARCHAR2) ;
72
73 PROCEDURE get_employee(
74 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
75 , x_employee_id OUT NOCOPY NUMBER
76 , x_hook_used OUT NOCOPY NUMBER
77 , x_error_msg OUT NOCOPY VARCHAR2) ;
78
79 PROCEDURE get_payables_ccid(
80 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
81 , x_payables_ccid OUT NOCOPY NUMBER
82 , x_hook_used OUT NOCOPY NUMBER
83 , x_error_msg OUT NOCOPY VARCHAR2) ;
84
85 PROCEDURE get_txn_class_flag(
86 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
87 , p_txn_class IN VARCHAR2
88 , x_process_flag OUT NOCOPY VARCHAR2
89 , x_hook_used OUT NOCOPY NUMBER
90 , x_error_msg OUT NOCOPY VARCHAR2) ;
91
92 PRAGMA RESTRICT_REFERENCES(get_txn_class_flag, WNDS);
93
94 PROCEDURE get_catchup_flag(
95 p_asset_number IN VARCHAR2,
96 p_instance_asset_id IN NUMBER,
97 x_catchup_flag OUT NOCOPY VARCHAR2,
98 x_hook_used OUT NOCOPY NUMBER,
99 x_error_msg OUT NOCOPY VARCHAR2);
100
101 PROCEDURE get_inv_depr_acct(
102 p_mtl_transaction_id IN NUMBER
103 , x_dummy_acct_id OUT NOCOPY NUMBER
104 , x_hook_used OUT NOCOPY NUMBER
105 , x_error_msg OUT NOCOPY VARCHAR2) ;
106
107 PROCEDURE get_inventory_item(
108 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
109 , x_hook_used OUT NOCOPY NUMBER
110 , x_error_msg OUT NOCOPY VARCHAR2) ;
111
112 PROCEDURE get_non_mtl_retire_flag(
113 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
114 p_asset_id IN NUMBER
115 , x_retire_flag OUT NOCOPY VARCHAR2
116 , x_hook_used OUT NOCOPY NUMBER
117 , x_error_msg OUT NOCOPY VARCHAR2) ;
118 PRAGMA RESTRICT_REFERENCES(get_inventory_item, WNDS);
119
120 PROCEDURE get_product_code(
121 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
122 x_product_code OUT NOCOPY VARCHAR2
123 , x_hook_used OUT NOCOPY NUMBER
124 , x_error_msg OUT NOCOPY VARCHAR2) ;
125
126 END CSE_ASSET_CLIENT_EXT_STUB ;