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:
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:
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(
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(
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:
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:
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(
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:
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:
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:
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:
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:
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:
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:
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) ;
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(
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) ;
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: