5:
6: PROCEDURE issue_to_hz_loc(p_transaction_id IN NUMBER,
7: p_message_id IN NUMBER,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
10: IS
11:
12: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
13: l_api_name VARCHAR2(100) := 'CSI_INV_HZ_PKG.ISSUE_TO_HZ_LOC';
22: l_object_version_number NUMBER := 1;
23: l_sysdate DATE := SYSDATE;
24: l_master_organization_id NUMBER;
25: l_depreciable VARCHAR2(1);
26: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
27: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
28: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
29: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
23: l_sysdate DATE := SYSDATE;
24: l_master_organization_id NUMBER;
25: l_depreciable VARCHAR2(1);
26: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
27: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
28: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
29: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
24: l_master_organization_id NUMBER;
25: l_depreciable VARCHAR2(1);
26: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
27: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
28: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
29: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
25: l_depreciable VARCHAR2(1);
26: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
27: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
28: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
29: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
26: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
27: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
28: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
29: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
34: l_return_status VARCHAR2(1);
27: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
28: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
29: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
34: l_return_status VARCHAR2(1);
35: l_error_code VARCHAR2(50);
28: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
29: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
34: l_return_status VARCHAR2(1);
35: l_error_code VARCHAR2(50);
36: l_error_message VARCHAR2(4000);
29: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
34: l_return_status VARCHAR2(1);
35: l_error_code VARCHAR2(50);
36: l_error_message VARCHAR2(4000);
37: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
33: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
34: l_return_status VARCHAR2(1);
35: l_error_code VARCHAR2(50);
36: l_error_message VARCHAR2(4000);
37: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
38: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
39: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
40: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
41: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
34: l_return_status VARCHAR2(1);
35: l_error_code VARCHAR2(50);
36: l_error_message VARCHAR2(4000);
37: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
38: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
39: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
40: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
41: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
42: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
35: l_error_code VARCHAR2(50);
36: l_error_message VARCHAR2(4000);
37: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
38: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
39: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
40: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
41: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
42: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
43: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
36: l_error_message VARCHAR2(4000);
37: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
38: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
39: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
40: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
41: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
42: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
43: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
44: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
37: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
38: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
39: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
40: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
41: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
42: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
43: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
44: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
45: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
38: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
39: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
40: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
41: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
42: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
43: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
44: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
45: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
46: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
39: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
40: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
41: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
42: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
43: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
44: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
45: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
46: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
47: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
40: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
41: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
42: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
43: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
44: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
45: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
46: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
47: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
48: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
41: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
42: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
43: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
44: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
45: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
46: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
47: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
48: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: l_fnd_warning VARCHAR2(1) := 'W';
42: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
43: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
44: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
45: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
46: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
47: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
48: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: l_fnd_warning VARCHAR2(1) := 'W';
50: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
43: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
44: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
45: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
46: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
47: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
48: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: l_fnd_warning VARCHAR2(1) := 'W';
50: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
873:
874: PROCEDURE misc_receipt_hz_loc(p_transaction_id IN NUMBER,
875: p_message_id IN NUMBER,
876: x_return_status OUT NOCOPY VARCHAR2,
877: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
878: IS
879:
880: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
881: l_api_name VARCHAR2(100) := 'CSI_INV_HZ_PKG.MISC_RECEIPT_HZ_LOC';
890: l_object_version_number NUMBER := 1;
891: l_sysdate DATE := SYSDATE;
892: l_master_organization_id NUMBER;
893: l_depreciable VARCHAR2(1);
894: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
895: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
896: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
898: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
891: l_sysdate DATE := SYSDATE;
892: l_master_organization_id NUMBER;
893: l_depreciable VARCHAR2(1);
894: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
895: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
896: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
898: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
892: l_master_organization_id NUMBER;
893: l_depreciable VARCHAR2(1);
894: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
895: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
896: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
898: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
900: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
893: l_depreciable VARCHAR2(1);
894: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
895: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
896: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
898: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
900: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
901: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
894: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
895: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
896: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
898: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
900: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
901: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
895: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
896: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
898: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
900: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
901: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
903: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
896: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
898: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
900: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
901: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
903: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
904: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
897: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
898: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
900: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
901: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
903: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
904: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
905: l_return_status VARCHAR2(1);
898: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
900: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
901: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
903: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
904: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
905: l_return_status VARCHAR2(1);
906: l_error_code VARCHAR2(50);
899: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
900: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
901: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
903: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
904: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
905: l_return_status VARCHAR2(1);
906: l_error_code VARCHAR2(50);
907: l_error_message VARCHAR2(4000);
900: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
901: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
903: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
904: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
905: l_return_status VARCHAR2(1);
906: l_error_code VARCHAR2(50);
907: l_error_message VARCHAR2(4000);
908: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
904: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
905: l_return_status VARCHAR2(1);
906: l_error_code VARCHAR2(50);
907: l_error_message VARCHAR2(4000);
908: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
909: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
910: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
912: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
905: l_return_status VARCHAR2(1);
906: l_error_code VARCHAR2(50);
907: l_error_message VARCHAR2(4000);
908: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
909: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
910: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
912: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
913: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
906: l_error_code VARCHAR2(50);
907: l_error_message VARCHAR2(4000);
908: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
909: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
910: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
912: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
913: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
914: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
907: l_error_message VARCHAR2(4000);
908: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
909: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
910: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
912: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
913: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
914: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
915: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
908: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
909: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
910: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
912: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
913: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
914: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
915: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
916: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
909: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
910: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
912: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
913: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
914: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
915: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
916: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
917: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
910: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
912: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
913: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
914: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
915: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
916: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
917: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
918: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
911: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
912: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
913: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
914: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
915: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
916: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
917: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
918: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
919: l_fnd_warning VARCHAR2(1) := 'W';
912: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
913: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
914: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
915: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
916: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
917: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
918: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
919: l_fnd_warning VARCHAR2(1) := 'W';
920: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
913: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
914: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
915: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
916: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
917: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
918: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
919: l_fnd_warning VARCHAR2(1) := 'W';
920: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
921: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2271:
2272: PROCEDURE misc_issue_hz_loc(p_transaction_id IN NUMBER,
2273: p_message_id IN NUMBER,
2274: x_return_status OUT NOCOPY VARCHAR2,
2275: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2276: IS
2277:
2278: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2279: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_HZ_LOC';
2288: l_object_version_number NUMBER := 1;
2289: l_sysdate DATE := SYSDATE;
2290: l_master_organization_id NUMBER;
2291: l_depreciable VARCHAR2(1);
2292: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2293: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2294: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2295: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2296: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2289: l_sysdate DATE := SYSDATE;
2290: l_master_organization_id NUMBER;
2291: l_depreciable VARCHAR2(1);
2292: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2293: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2294: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2295: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2296: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2297: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2290: l_master_organization_id NUMBER;
2291: l_depreciable VARCHAR2(1);
2292: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2293: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2294: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2295: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2296: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2297: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2298: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2291: l_depreciable VARCHAR2(1);
2292: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2293: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2294: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2295: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2296: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2297: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2298: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2299: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2292: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2293: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2294: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2295: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2296: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2297: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2298: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2299: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2300: l_return_status VARCHAR2(1);
2293: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2294: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2295: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2296: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2297: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2298: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2299: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2300: l_return_status VARCHAR2(1);
2301: l_error_code VARCHAR2(50);
2294: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2295: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2296: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2297: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2298: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2299: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2300: l_return_status VARCHAR2(1);
2301: l_error_code VARCHAR2(50);
2302: l_error_message VARCHAR2(4000);
2295: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2296: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2297: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2298: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2299: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2300: l_return_status VARCHAR2(1);
2301: l_error_code VARCHAR2(50);
2302: l_error_message VARCHAR2(4000);
2303: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2299: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2300: l_return_status VARCHAR2(1);
2301: l_error_code VARCHAR2(50);
2302: l_error_message VARCHAR2(4000);
2303: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2304: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2305: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2306: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2307: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2300: l_return_status VARCHAR2(1);
2301: l_error_code VARCHAR2(50);
2302: l_error_message VARCHAR2(4000);
2303: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2304: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2305: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2306: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2307: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2308: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2301: l_error_code VARCHAR2(50);
2302: l_error_message VARCHAR2(4000);
2303: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2304: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2305: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2306: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2307: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2308: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2309: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2302: l_error_message VARCHAR2(4000);
2303: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2304: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2305: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2306: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2307: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2308: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2309: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2310: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2303: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2304: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2305: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2306: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2307: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2308: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2309: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2310: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2311: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2304: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2305: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2306: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2307: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2308: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2309: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2310: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2311: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2312: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2305: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2306: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2307: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2308: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2309: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2310: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2311: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2312: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2313: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2306: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2307: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2308: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2309: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2310: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2311: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2312: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2313: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2314: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2307: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2308: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2309: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2310: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2311: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2312: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2313: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2314: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2315: l_fnd_warning VARCHAR2(1) := 'W';
2308: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2309: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2310: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2311: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2312: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2313: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2314: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2315: l_fnd_warning VARCHAR2(1) := 'W';
2316: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2309: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2310: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2311: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2312: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2313: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2314: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2315: l_fnd_warning VARCHAR2(1) := 'W';
2316: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2317: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;