12:
13: PROCEDURE subinv_transfer(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_TRANSFER_PKG.SUBINV_TRANSFER';
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_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_update_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_update_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_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_update_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_master_organization_id NUMBER;
32: l_depreciable VARCHAR2(1);
33: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_update_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
32: l_depreciable VARCHAR2(1);
33: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_update_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
40: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_update_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
40: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_update_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
40: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
35: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_update_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
40: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
43: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_update_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
40: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
43: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
44: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
40: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
43: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
44: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
45: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
38: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
40: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
43: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
44: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
45: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
46: l_return_status VARCHAR2(1);
39: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
40: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
43: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
44: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
45: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
46: l_return_status VARCHAR2(1);
47: l_error_code VARCHAR2(50);
40: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
43: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
44: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
45: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
46: l_return_status VARCHAR2(1);
47: l_error_code VARCHAR2(50);
48: l_error_message VARCHAR2(4000);
41: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
43: l_api_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
44: l_api_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
45: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
46: l_return_status VARCHAR2(1);
47: l_error_code VARCHAR2(50);
48: l_error_message VARCHAR2(4000);
49: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
45: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
46: l_return_status VARCHAR2(1);
47: l_error_code VARCHAR2(50);
48: l_error_message VARCHAR2(4000);
49: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
50: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
51: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
53: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
46: l_return_status VARCHAR2(1);
47: l_error_code VARCHAR2(50);
48: l_error_message VARCHAR2(4000);
49: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
50: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
51: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
53: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
54: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
47: l_error_code VARCHAR2(50);
48: l_error_message VARCHAR2(4000);
49: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
50: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
51: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
53: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
54: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
55: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
48: l_error_message VARCHAR2(4000);
49: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
50: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
51: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
53: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
54: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
55: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
56: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
49: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
50: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
51: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
53: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
54: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
55: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
56: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
57: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
50: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
51: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
53: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
54: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
55: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
56: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
57: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
58: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
51: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
53: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
54: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
55: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
56: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
57: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
58: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
59: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
52: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
53: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
54: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
55: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
56: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
57: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
58: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
59: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
60: l_fnd_warning VARCHAR2(1) := 'W';
53: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
54: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
55: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
56: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
57: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
58: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
59: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
60: l_fnd_warning VARCHAR2(1) := 'W';
61: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
54: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
55: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
56: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
57: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
58: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
59: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
60: l_fnd_warning VARCHAR2(1) := 'W';
61: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
62: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;