12:
13: PROCEDURE intransit_shipment(p_transaction_id IN NUMBER,
14: p_message_id IN NUMBER,
15: x_return_status OUT NOCOPY VARCHAR2,
16: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
17: IS
18:
19: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
20: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_SHIPMENT';
29: l_object_version_number NUMBER := 1;
30: l_sysdate DATE := SYSDATE;
31: l_master_organization_id NUMBER;
32: l_depreciable VARCHAR2(1);
33: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_sysdate DATE := SYSDATE;
31: l_master_organization_id NUMBER;
32: l_depreciable VARCHAR2(1);
33: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_master_organization_id NUMBER;
32: l_depreciable VARCHAR2(1);
33: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_depreciable VARCHAR2(1);
33: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
43: l_return_status VARCHAR2(1);
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
43: l_return_status VARCHAR2(1);
44: l_error_code VARCHAR2(50);
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
43: l_return_status VARCHAR2(1);
44: l_error_code VARCHAR2(50);
45: l_error_message VARCHAR2(4000);
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
43: l_return_status VARCHAR2(1);
44: l_error_code VARCHAR2(50);
45: l_error_message VARCHAR2(4000);
46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
43: l_return_status VARCHAR2(1);
44: l_error_code VARCHAR2(50);
45: l_error_message VARCHAR2(4000);
46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
43: l_return_status VARCHAR2(1);
44: l_error_code VARCHAR2(50);
45: l_error_message VARCHAR2(4000);
46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
44: l_error_code VARCHAR2(50);
45: l_error_message VARCHAR2(4000);
46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
45: l_error_message VARCHAR2(4000);
46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
58: l_sub_inventory VARCHAR2(10);
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
58: l_sub_inventory VARCHAR2(10);
59: l_location_type VARCHAR2(20);
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
58: l_sub_inventory VARCHAR2(10);
59: l_location_type VARCHAR2(20);
60: l_trx_action_type VARCHAR2(50);
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
58: l_sub_inventory VARCHAR2(10);
59: l_location_type VARCHAR2(20);
60: l_trx_action_type VARCHAR2(50);
61: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
126: debug('csiorgtb.pls 115.23');
127: debug('Transaction ID with is: '||p_transaction_id);
128:
129: -- Get the default in transit location id
130: l_def_in_transit_loc_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;
131:
132: debug('Default In Transit Loc IDs: '||l_def_in_transit_loc_id);
133:
134: -- This procedure queries all of the Inventory Transaction Records and
1189:
1190: PROCEDURE intransit_receipt(p_transaction_id IN NUMBER,
1191: p_message_id IN NUMBER,
1192: x_return_status OUT NOCOPY VARCHAR2,
1193: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
1194: IS
1195:
1196: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1197: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';
1206: l_object_version_number NUMBER := 1;
1207: l_sysdate DATE := SYSDATE;
1208: l_master_organization_id NUMBER;
1209: l_depreciable VARCHAR2(1);
1210: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
1211: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1212: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1213: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1214: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1207: l_sysdate DATE := SYSDATE;
1208: l_master_organization_id NUMBER;
1209: l_depreciable VARCHAR2(1);
1210: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
1211: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1212: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1213: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1214: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1215: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1208: l_master_organization_id NUMBER;
1209: l_depreciable VARCHAR2(1);
1210: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
1211: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1212: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1213: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1214: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1215: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1216: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1209: l_depreciable VARCHAR2(1);
1210: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
1211: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1212: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1213: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1214: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1215: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1216: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1217: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1210: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
1211: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1212: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1213: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1214: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1215: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1216: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1217: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1218: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1211: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1212: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1213: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1214: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1215: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1216: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1217: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1218: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1219: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1212: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1213: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1214: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1215: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1216: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1217: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1218: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1219: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1220: l_return_status VARCHAR2(1);
1213: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1214: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1215: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1216: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1217: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1218: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1219: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1220: l_return_status VARCHAR2(1);
1221: l_error_code VARCHAR2(50);
1214: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1215: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1216: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1217: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1218: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1219: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1220: l_return_status VARCHAR2(1);
1221: l_error_code VARCHAR2(50);
1222: l_error_message VARCHAR2(4000);
1215: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1216: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1217: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1218: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1219: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1220: l_return_status VARCHAR2(1);
1221: l_error_code VARCHAR2(50);
1222: l_error_message VARCHAR2(4000);
1223: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1219: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1220: l_return_status VARCHAR2(1);
1221: l_error_code VARCHAR2(50);
1222: l_error_message VARCHAR2(4000);
1223: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1224: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1225: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1226: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1227: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1220: l_return_status VARCHAR2(1);
1221: l_error_code VARCHAR2(50);
1222: l_error_message VARCHAR2(4000);
1223: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1224: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1225: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1226: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1227: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1228: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1221: l_error_code VARCHAR2(50);
1222: l_error_message VARCHAR2(4000);
1223: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1224: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1225: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1226: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1227: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1228: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1229: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1222: l_error_message VARCHAR2(4000);
1223: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1224: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1225: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1226: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1227: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1228: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1229: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1230: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1223: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1224: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1225: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1226: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1227: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1228: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1229: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1230: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1231: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1224: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1225: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1226: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1227: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1228: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1229: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1230: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1231: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1225: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1226: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1227: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1228: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1229: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1230: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1231: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1226: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1227: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1228: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1229: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1230: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1231: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1227: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1228: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1229: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1230: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1231: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1235: l_sub_inventory VARCHAR2(10);
1228: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1229: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1230: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1231: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1235: l_sub_inventory VARCHAR2(10);
1236: l_location_type VARCHAR2(20);
1229: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1230: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1231: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1235: l_sub_inventory VARCHAR2(10);
1236: l_location_type VARCHAR2(20);
1237: l_trx_action_type VARCHAR2(50);
1230: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1231: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1235: l_sub_inventory VARCHAR2(10);
1236: l_location_type VARCHAR2(20);
1237: l_trx_action_type VARCHAR2(50);
1238: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1276: l_ownership_party VARCHAR2(1);
1277: l_redeploy_flag VARCHAR2(1);
1278: l_upd_error_instance_id NUMBER := NULL;
1279:
1280: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1281: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1282: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1283: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1284: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1277: l_redeploy_flag VARCHAR2(1);
1278: l_upd_error_instance_id NUMBER := NULL;
1279:
1280: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1281: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1282: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1283: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1284: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1285: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1278: l_upd_error_instance_id NUMBER := NULL;
1279:
1280: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1281: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1282: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1283: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1284: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1285: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1286: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1279:
1280: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1281: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1282: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1283: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1284: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1285: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1286: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1287: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1280: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1281: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1282: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1283: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1284: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1285: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1286: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1287: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1288:
1281: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1282: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1283: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1284: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1285: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1286: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1287: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1288:
1289: cursor c_id is
1282: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1283: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1284: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1285: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1286: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1287: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1288:
1289: cursor c_id is
1290: SELECT instance_status_id
1283: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1284: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1285: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1286: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1287: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1288:
1289: cursor c_id is
1290: SELECT instance_status_id
1291: FROM csi_instance_statuses
1364:
1365: debug('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);
1366:
1367: -- Get Party ownership Flag
1368: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
1369:
1370: debug('Ownership Party FLag is: '||l_ownership_party)
1371: ;
1372:
2970:
2971: PROCEDURE direct_shipment(p_transaction_id IN NUMBER,
2972: p_message_id IN NUMBER,
2973: x_return_status OUT NOCOPY VARCHAR2,
2974: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2975: IS
2976:
2977: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2978: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';
2987: l_object_version_number NUMBER := 1;
2988: l_sysdate DATE := SYSDATE;
2989: l_master_organization_id NUMBER;
2990: l_depreciable VARCHAR2(1);
2991: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
2992: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2993: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2994: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2995: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2988: l_sysdate DATE := SYSDATE;
2989: l_master_organization_id NUMBER;
2990: l_depreciable VARCHAR2(1);
2991: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
2992: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2993: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2994: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2995: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2996: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2989: l_master_organization_id NUMBER;
2990: l_depreciable VARCHAR2(1);
2991: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
2992: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2993: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2994: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2995: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2996: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2997: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2990: l_depreciable VARCHAR2(1);
2991: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
2992: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2993: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2994: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2995: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2996: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2997: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2998: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2991: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
2992: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2993: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2994: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2995: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2996: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2997: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2998: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2999: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2992: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2993: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2994: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2995: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2996: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2997: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2998: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2999: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3000: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2993: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2994: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2995: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2996: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2997: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2998: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2999: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3000: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
3001: l_return_status VARCHAR2(1);
2994: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2995: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2996: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2997: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2998: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2999: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3000: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
3001: l_return_status VARCHAR2(1);
3002: l_error_code VARCHAR2(50);
2995: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2996: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2997: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2998: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2999: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3000: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
3001: l_return_status VARCHAR2(1);
3002: l_error_code VARCHAR2(50);
3003: l_error_message VARCHAR2(4000);
2996: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2997: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2998: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2999: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3000: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
3001: l_return_status VARCHAR2(1);
3002: l_error_code VARCHAR2(50);
3003: l_error_message VARCHAR2(4000);
3004: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
3000: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
3001: l_return_status VARCHAR2(1);
3002: l_error_code VARCHAR2(50);
3003: l_error_message VARCHAR2(4000);
3004: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
3005: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3006: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3007: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3008: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3001: l_return_status VARCHAR2(1);
3002: l_error_code VARCHAR2(50);
3003: l_error_message VARCHAR2(4000);
3004: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
3005: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3006: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3007: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3008: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3009: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3002: l_error_code VARCHAR2(50);
3003: l_error_message VARCHAR2(4000);
3004: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
3005: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3006: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3007: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3008: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3009: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3010: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3003: l_error_message VARCHAR2(4000);
3004: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
3005: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3006: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3007: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3008: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3009: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3010: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3011: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3004: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
3005: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3006: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3007: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3008: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3009: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3010: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3011: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3012: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3005: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3006: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3007: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3008: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3009: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3010: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3011: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3012: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3013: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3006: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3007: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3008: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3009: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3010: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3011: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3012: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3013: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3014: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
3007: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3008: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3009: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3010: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3011: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3012: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3013: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3014: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
3015: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
3008: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3009: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3010: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3011: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3012: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3013: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3014: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
3015: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
3016: l_sub_inventory VARCHAR2(10);
3009: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3010: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3011: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3012: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3013: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3014: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
3015: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
3016: l_sub_inventory VARCHAR2(10);
3017: l_location_type VARCHAR2(20);
3010: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3011: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3012: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3013: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3014: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
3015: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
3016: l_sub_inventory VARCHAR2(10);
3017: l_location_type VARCHAR2(20);
3018: l_trx_action_type VARCHAR2(50);
3011: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3012: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3013: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3014: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
3015: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
3016: l_sub_inventory VARCHAR2(10);
3017: l_location_type VARCHAR2(20);
3018: l_trx_action_type VARCHAR2(50);
3019: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;