3:
4: --
5: TYPE LOOKUP_REC IS RECORD
6: (
7: lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
8: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
9: );
10:
11: TYPE LOOKUP_TBL IS TABLE OF LOOKUP_REC INDEX BY BINARY_INTEGER;
4: --
5: TYPE LOOKUP_REC IS RECORD
6: (
7: lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
8: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
9: );
10:
11: TYPE LOOKUP_TBL IS TABLE OF LOOKUP_REC INDEX BY BINARY_INTEGER;
12: --
11: TYPE LOOKUP_TBL IS TABLE OF LOOKUP_REC INDEX BY BINARY_INTEGER;
12: --
13: TYPE ASSET_COUNT_REC IS RECORD
14: (
15: asset_count NUMBER := FND_API.G_MISS_NUM
16: ,lookup_count NUMBER := FND_API.G_MISS_NUM
17: ,loc_count NUMBER := FND_API.G_MISS_NUM
18: );
19: --
12: --
13: TYPE ASSET_COUNT_REC IS RECORD
14: (
15: asset_count NUMBER := FND_API.G_MISS_NUM
16: ,lookup_count NUMBER := FND_API.G_MISS_NUM
17: ,loc_count NUMBER := FND_API.G_MISS_NUM
18: );
19: --
20: TYPE ASSET_ID_REC IS RECORD
13: TYPE ASSET_COUNT_REC IS RECORD
14: (
15: asset_count NUMBER := FND_API.G_MISS_NUM
16: ,lookup_count NUMBER := FND_API.G_MISS_NUM
17: ,loc_count NUMBER := FND_API.G_MISS_NUM
18: );
19: --
20: TYPE ASSET_ID_REC IS RECORD
21: (
18: );
19: --
20: TYPE ASSET_ID_REC IS RECORD
21: (
22: asset_id NUMBER := FND_API.G_MISS_NUM
23: ,asset_book_type VARCHAR2(15) := FND_API.G_MISS_CHAR
24: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
25: );
26:
19: --
20: TYPE ASSET_ID_REC IS RECORD
21: (
22: asset_id NUMBER := FND_API.G_MISS_NUM
23: ,asset_book_type VARCHAR2(15) := FND_API.G_MISS_CHAR
24: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
25: );
26:
27: TYPE ASSET_ID_TBL IS TABLE OF ASSET_ID_REC INDEX BY BINARY_INTEGER;
20: TYPE ASSET_ID_REC IS RECORD
21: (
22: asset_id NUMBER := FND_API.G_MISS_NUM
23: ,asset_book_type VARCHAR2(15) := FND_API.G_MISS_CHAR
24: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
25: );
26:
27: TYPE ASSET_ID_TBL IS TABLE OF ASSET_ID_REC INDEX BY BINARY_INTEGER;
28: --
27: TYPE ASSET_ID_TBL IS TABLE OF ASSET_ID_REC INDEX BY BINARY_INTEGER;
28: --
29: TYPE ASSET_LOC_REC IS RECORD
30: (
31: asset_loc_id NUMBER := FND_API.G_MISS_NUM
32: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
33: );
34:
35: TYPE ASSET_LOC_TBL IS TABLE OF ASSET_LOC_REC INDEX BY BINARY_INTEGER;
28: --
29: TYPE ASSET_LOC_REC IS RECORD
30: (
31: asset_loc_id NUMBER := FND_API.G_MISS_NUM
32: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
33: );
34:
35: TYPE ASSET_LOC_TBL IS TABLE OF ASSET_LOC_REC INDEX BY BINARY_INTEGER;
36: --
37:
38: /*-- These datastructures are added to implement asset sync --*/
39: TYPE instance_asset_sync_rec IS RECORD
40: (
41: instance_id NUMBER := FND_API.G_MISS_NUM,
42: inst_interface_id NUMBER := FND_API.G_MISS_NUM,
43: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
44: fa_location_id NUMBER := FND_API.G_MISS_NUM,
45: inst_asset_quantity NUMBER := FND_API.G_MISS_NUM
38: /*-- These datastructures are added to implement asset sync --*/
39: TYPE instance_asset_sync_rec IS RECORD
40: (
41: instance_id NUMBER := FND_API.G_MISS_NUM,
42: inst_interface_id NUMBER := FND_API.G_MISS_NUM,
43: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
44: fa_location_id NUMBER := FND_API.G_MISS_NUM,
45: inst_asset_quantity NUMBER := FND_API.G_MISS_NUM
46: );
39: TYPE instance_asset_sync_rec IS RECORD
40: (
41: instance_id NUMBER := FND_API.G_MISS_NUM,
42: inst_interface_id NUMBER := FND_API.G_MISS_NUM,
43: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
44: fa_location_id NUMBER := FND_API.G_MISS_NUM,
45: inst_asset_quantity NUMBER := FND_API.G_MISS_NUM
46: );
47: TYPE instance_asset_sync_tbl IS TABLE OF instance_asset_sync_rec INDEX BY BINARY_INTEGER;
40: (
41: instance_id NUMBER := FND_API.G_MISS_NUM,
42: inst_interface_id NUMBER := FND_API.G_MISS_NUM,
43: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
44: fa_location_id NUMBER := FND_API.G_MISS_NUM,
45: inst_asset_quantity NUMBER := FND_API.G_MISS_NUM
46: );
47: TYPE instance_asset_sync_tbl IS TABLE OF instance_asset_sync_rec INDEX BY BINARY_INTEGER;
48:
41: instance_id NUMBER := FND_API.G_MISS_NUM,
42: inst_interface_id NUMBER := FND_API.G_MISS_NUM,
43: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
44: fa_location_id NUMBER := FND_API.G_MISS_NUM,
45: inst_asset_quantity NUMBER := FND_API.G_MISS_NUM
46: );
47: TYPE instance_asset_sync_tbl IS TABLE OF instance_asset_sync_rec INDEX BY BINARY_INTEGER;
48:
49: TYPE fa_asset_sync_rec IS RECORD
47: TYPE instance_asset_sync_tbl IS TABLE OF instance_asset_sync_rec INDEX BY BINARY_INTEGER;
48:
49: TYPE fa_asset_sync_rec IS RECORD
50: (
51: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
52: fa_location_id NUMBER := FND_API.G_MISS_NUM,
53: fa_asset_quantity NUMBER := FND_API.G_MISS_NUM,
54: sync_up_quantity NUMBER := FND_API.G_MISS_NUM
55: );
48:
49: TYPE fa_asset_sync_rec IS RECORD
50: (
51: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
52: fa_location_id NUMBER := FND_API.G_MISS_NUM,
53: fa_asset_quantity NUMBER := FND_API.G_MISS_NUM,
54: sync_up_quantity NUMBER := FND_API.G_MISS_NUM
55: );
56: TYPE fa_asset_sync_tbl IS TABLE OF fa_asset_sync_rec INDEX BY BINARY_INTEGER;
49: TYPE fa_asset_sync_rec IS RECORD
50: (
51: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
52: fa_location_id NUMBER := FND_API.G_MISS_NUM,
53: fa_asset_quantity NUMBER := FND_API.G_MISS_NUM,
54: sync_up_quantity NUMBER := FND_API.G_MISS_NUM
55: );
56: TYPE fa_asset_sync_tbl IS TABLE OF fa_asset_sync_rec INDEX BY BINARY_INTEGER;
57:
50: (
51: fa_asset_id NUMBER := FND_API.G_MISS_NUM,
52: fa_location_id NUMBER := FND_API.G_MISS_NUM,
53: fa_asset_quantity NUMBER := FND_API.G_MISS_NUM,
54: sync_up_quantity NUMBER := FND_API.G_MISS_NUM
55: );
56: TYPE fa_asset_sync_tbl IS TABLE OF fa_asset_sync_rec INDEX BY BINARY_INTEGER;
57:
58: TYPE instance_sync_rec IS RECORD
56: TYPE fa_asset_sync_tbl IS TABLE OF fa_asset_sync_rec INDEX BY BINARY_INTEGER;
57:
58: TYPE instance_sync_rec IS RECORD
59: (
60: instance_id NUMBER := FND_API.G_MISS_NUM,
61: inst_interface_id NUMBER := FND_API.G_MISS_NUM,
62: instance_quantity NUMBER := FND_API.G_MISS_NUM,
63: sync_up_quantity NUMBER := FND_API.G_MISS_NUM,
64: vld_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
57:
58: TYPE instance_sync_rec IS RECORD
59: (
60: instance_id NUMBER := FND_API.G_MISS_NUM,
61: inst_interface_id NUMBER := FND_API.G_MISS_NUM,
62: instance_quantity NUMBER := FND_API.G_MISS_NUM,
63: sync_up_quantity NUMBER := FND_API.G_MISS_NUM,
64: vld_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: hop NUMBER := FND_API.G_MISS_NUM,
58: TYPE instance_sync_rec IS RECORD
59: (
60: instance_id NUMBER := FND_API.G_MISS_NUM,
61: inst_interface_id NUMBER := FND_API.G_MISS_NUM,
62: instance_quantity NUMBER := FND_API.G_MISS_NUM,
63: sync_up_quantity NUMBER := FND_API.G_MISS_NUM,
64: vld_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: hop NUMBER := FND_API.G_MISS_NUM,
66: location_id NUMBER := FND_API.G_MISS_NUM,
59: (
60: instance_id NUMBER := FND_API.G_MISS_NUM,
61: inst_interface_id NUMBER := FND_API.G_MISS_NUM,
62: instance_quantity NUMBER := FND_API.G_MISS_NUM,
63: sync_up_quantity NUMBER := FND_API.G_MISS_NUM,
64: vld_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: hop NUMBER := FND_API.G_MISS_NUM,
66: location_id NUMBER := FND_API.G_MISS_NUM,
67: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
60: instance_id NUMBER := FND_API.G_MISS_NUM,
61: inst_interface_id NUMBER := FND_API.G_MISS_NUM,
62: instance_quantity NUMBER := FND_API.G_MISS_NUM,
63: sync_up_quantity NUMBER := FND_API.G_MISS_NUM,
64: vld_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: hop NUMBER := FND_API.G_MISS_NUM,
66: location_id NUMBER := FND_API.G_MISS_NUM,
67: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: );
61: inst_interface_id NUMBER := FND_API.G_MISS_NUM,
62: instance_quantity NUMBER := FND_API.G_MISS_NUM,
63: sync_up_quantity NUMBER := FND_API.G_MISS_NUM,
64: vld_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: hop NUMBER := FND_API.G_MISS_NUM,
66: location_id NUMBER := FND_API.G_MISS_NUM,
67: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: );
69: TYPE instance_sync_tbl IS TABLE OF instance_sync_rec INDEX BY BINARY_INTEGER;
62: instance_quantity NUMBER := FND_API.G_MISS_NUM,
63: sync_up_quantity NUMBER := FND_API.G_MISS_NUM,
64: vld_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: hop NUMBER := FND_API.G_MISS_NUM,
66: location_id NUMBER := FND_API.G_MISS_NUM,
67: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: );
69: TYPE instance_sync_tbl IS TABLE OF instance_sync_rec INDEX BY BINARY_INTEGER;
70:
63: sync_up_quantity NUMBER := FND_API.G_MISS_NUM,
64: vld_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: hop NUMBER := FND_API.G_MISS_NUM,
66: location_id NUMBER := FND_API.G_MISS_NUM,
67: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68: );
69: TYPE instance_sync_tbl IS TABLE OF instance_sync_rec INDEX BY BINARY_INTEGER;
70:
71: /*--End These datastructures are added for implement asset sync --*/
154:
155: PROCEDURE get_instance_assets
156: (
157: p_api_version IN NUMBER
158: ,p_commit IN VARCHAR2 := fnd_api.g_false
159: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
160: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
161: ,p_instance_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
162: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
155: PROCEDURE get_instance_assets
156: (
157: p_api_version IN NUMBER
158: ,p_commit IN VARCHAR2 := fnd_api.g_false
159: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
160: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
161: ,p_instance_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
162: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
163: ,p_time_stamp IN DATE
156: (
157: p_api_version IN NUMBER
158: ,p_commit IN VARCHAR2 := fnd_api.g_false
159: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
160: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
161: ,p_instance_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
162: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
163: ,p_time_stamp IN DATE
164: ,x_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
158: ,p_commit IN VARCHAR2 := fnd_api.g_false
159: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
160: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
161: ,p_instance_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
162: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
163: ,p_time_stamp IN DATE
164: ,x_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
165: ,x_return_status OUT NOCOPY VARCHAR2
166: ,x_msg_count OUT NOCOPY NUMBER
175:
176: PROCEDURE create_instance_asset
177: (
178: p_api_version IN NUMBER
179: ,p_commit IN VARCHAR2 := fnd_api.g_false
180: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
181: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
182: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec
183: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
176: PROCEDURE create_instance_asset
177: (
178: p_api_version IN NUMBER
179: ,p_commit IN VARCHAR2 := fnd_api.g_false
180: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
181: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
182: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec
183: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
184: ,x_return_status OUT NOCOPY VARCHAR2
177: (
178: p_api_version IN NUMBER
179: ,p_commit IN VARCHAR2 := fnd_api.g_false
180: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
181: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
182: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec
183: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
184: ,x_return_status OUT NOCOPY VARCHAR2
185: ,x_msg_count OUT NOCOPY NUMBER
187: ,p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl
188: ,p_asset_count_rec IN OUT NOCOPY csi_asset_pvt.asset_count_rec
189: ,p_asset_id_tbl IN OUT NOCOPY csi_asset_pvt.asset_id_tbl
190: ,p_asset_loc_tbl IN OUT NOCOPY csi_asset_pvt.asset_loc_tbl
191: ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
192: );
193:
194: /*-------------------------------------------------------*/
195: /* procedure name: Update_instance_asset */
199:
200: PROCEDURE update_instance_asset
201: (
202: p_api_version IN NUMBER
203: ,p_commit IN VARCHAR2 := fnd_api.g_false
204: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
205: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
206: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec
207: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
200: PROCEDURE update_instance_asset
201: (
202: p_api_version IN NUMBER
203: ,p_commit IN VARCHAR2 := fnd_api.g_false
204: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
205: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
206: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec
207: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
208: ,x_return_status OUT NOCOPY VARCHAR2
201: (
202: p_api_version IN NUMBER
203: ,p_commit IN VARCHAR2 := fnd_api.g_false
204: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
205: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
206: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec
207: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
208: ,x_return_status OUT NOCOPY VARCHAR2
209: ,x_msg_count OUT NOCOPY NUMBER
222:
223:
224: PROCEDURE get_instance_asset_hist
225: ( p_api_version IN NUMBER
226: ,p_commit IN VARCHAR2 := fnd_api.g_false
227: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
228: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
229: ,p_transaction_id IN NUMBER
230: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
223:
224: PROCEDURE get_instance_asset_hist
225: ( p_api_version IN NUMBER
226: ,p_commit IN VARCHAR2 := fnd_api.g_false
227: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
228: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
229: ,p_transaction_id IN NUMBER
230: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
231: ,x_return_status OUT NOCOPY VARCHAR2
224: PROCEDURE get_instance_asset_hist
225: ( p_api_version IN NUMBER
226: ,p_commit IN VARCHAR2 := fnd_api.g_false
227: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
228: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
229: ,p_transaction_id IN NUMBER
230: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
231: ,x_return_status OUT NOCOPY VARCHAR2
232: ,x_msg_count OUT NOCOPY NUMBER
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_source_system_name IN VARCHAR2 DEFAULT NULL,
255: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
256: );
257:
258: PROCEDURE get_attached_asset_links
259:
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_source_system_name IN VARCHAR2 DEFAULT NULL,
268: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
269: );
270:
271: PROCEDURE get_fa_asset_details
272: ( p_api_version IN NUMBER,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_source_system_name IN VARCHAR2 DEFAULT NULL,
280: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
281: );
282:
283: PROCEDURE Get_syncup_tree
284: ( px_instance_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.instance_sync_tbl,
286: x_fa_asset_sync_tbl IN OUT NOCOPY CSI_ASSET_PVT.fa_asset_sync_tbl,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_error_msg OUT NOCOPY VARCHAR2,
289: p_source_system_name IN VARCHAR2 DEFAULT NULL,
290: p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
291: );
292: /*-- End These procedures are added to implement asset sync --*/
293:
294: PROCEDURE create_instance_assets (