5:
6: PROCEDURE issue_to_project(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_PROJECT_PKG.ISSUE_TO_PROJECT';
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;
847:
848: PROCEDURE misc_receipt_projtask(p_transaction_id IN NUMBER,
849: p_message_id IN NUMBER,
850: x_return_status OUT NOCOPY VARCHAR2,
851: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
852: IS
853:
854: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
855: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_RECEIPT_PROJTASK';
864: l_object_version_number NUMBER := 1;
865: l_sysdate DATE := SYSDATE;
866: l_master_organization_id NUMBER;
867: l_depreciable VARCHAR2(1);
868: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
869: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
870: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
871: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
872: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
865: l_sysdate DATE := SYSDATE;
866: l_master_organization_id NUMBER;
867: l_depreciable VARCHAR2(1);
868: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
869: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
870: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
871: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
872: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
873: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
866: l_master_organization_id NUMBER;
867: l_depreciable VARCHAR2(1);
868: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
869: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
870: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
871: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
872: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
873: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
874: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
867: l_depreciable VARCHAR2(1);
868: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
869: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
870: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
871: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
872: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
873: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
874: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
875: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
868: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
869: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
870: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
871: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
872: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
873: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
874: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
875: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
876: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
869: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
870: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
871: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
872: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
873: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
874: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
875: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
876: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
877: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
870: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
871: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
872: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
873: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
874: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
875: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
876: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
877: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
878: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
871: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
872: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
873: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
874: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
875: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
876: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
877: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
878: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
879: l_return_status VARCHAR2(1);
872: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
873: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
874: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
875: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
876: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
877: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
878: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
879: l_return_status VARCHAR2(1);
880: l_error_code VARCHAR2(50);
873: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
874: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
875: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
876: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
877: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
878: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
879: l_return_status VARCHAR2(1);
880: l_error_code VARCHAR2(50);
881: l_error_message VARCHAR2(4000);
874: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
875: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
876: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
877: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
878: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
879: l_return_status VARCHAR2(1);
880: l_error_code VARCHAR2(50);
881: l_error_message VARCHAR2(4000);
882: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
878: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
879: l_return_status VARCHAR2(1);
880: l_error_code VARCHAR2(50);
881: l_error_message VARCHAR2(4000);
882: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
883: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
884: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
885: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
886: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
879: l_return_status VARCHAR2(1);
880: l_error_code VARCHAR2(50);
881: l_error_message VARCHAR2(4000);
882: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
883: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
884: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
885: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
886: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
887: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
880: l_error_code VARCHAR2(50);
881: l_error_message VARCHAR2(4000);
882: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
883: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
884: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
885: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
886: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
887: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
888: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
881: l_error_message VARCHAR2(4000);
882: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
883: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
884: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
885: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
886: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
887: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
888: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
889: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
882: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
883: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
884: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
885: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
886: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
887: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
888: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
889: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
890: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
883: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
884: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
885: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
886: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
887: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
888: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
889: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
890: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
891: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
884: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
885: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
886: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
887: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
888: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
889: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
890: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
891: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
892: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
885: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
886: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
887: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
888: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
889: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
890: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
891: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
892: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
893: l_fnd_warning VARCHAR2(1) := 'W';
886: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
887: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
888: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
889: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
890: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
891: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
892: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
893: l_fnd_warning VARCHAR2(1) := 'W';
894: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
887: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
888: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
889: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
890: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
891: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
892: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
893: l_fnd_warning VARCHAR2(1) := 'W';
894: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
895: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1931:
1932: PROCEDURE misc_issue_projtask(p_transaction_id IN NUMBER,
1933: p_message_id IN NUMBER,
1934: x_return_status OUT NOCOPY VARCHAR2,
1935: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
1936: IS
1937:
1938: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1939: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_PROJTASK';
1948: l_object_version_number NUMBER := 1;
1949: l_sysdate DATE := SYSDATE;
1950: l_master_organization_id NUMBER;
1951: l_depreciable VARCHAR2(1);
1952: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1953: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1954: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1955: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1956: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1949: l_sysdate DATE := SYSDATE;
1950: l_master_organization_id NUMBER;
1951: l_depreciable VARCHAR2(1);
1952: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1953: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1954: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1955: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1956: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1957: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1950: l_master_organization_id NUMBER;
1951: l_depreciable VARCHAR2(1);
1952: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1953: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1954: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1955: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1956: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1957: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1958: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1951: l_depreciable VARCHAR2(1);
1952: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1953: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1954: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1955: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1956: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1957: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1958: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1959: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1952: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1953: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1954: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1955: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1956: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1957: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1958: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1959: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1960: l_return_status VARCHAR2(1);
1953: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1954: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1955: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1956: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1957: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1958: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1959: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1960: l_return_status VARCHAR2(1);
1961: l_error_code VARCHAR2(50);
1954: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1955: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1956: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1957: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1958: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1959: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1960: l_return_status VARCHAR2(1);
1961: l_error_code VARCHAR2(50);
1962: l_error_message VARCHAR2(4000);
1955: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1956: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1957: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1958: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1959: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1960: l_return_status VARCHAR2(1);
1961: l_error_code VARCHAR2(50);
1962: l_error_message VARCHAR2(4000);
1963: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1959: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1960: l_return_status VARCHAR2(1);
1961: l_error_code VARCHAR2(50);
1962: l_error_message VARCHAR2(4000);
1963: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1964: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1965: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1966: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1967: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1960: l_return_status VARCHAR2(1);
1961: l_error_code VARCHAR2(50);
1962: l_error_message VARCHAR2(4000);
1963: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1964: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1965: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1966: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1967: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1968: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1961: l_error_code VARCHAR2(50);
1962: l_error_message VARCHAR2(4000);
1963: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1964: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1965: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1966: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1967: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1968: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1969: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1962: l_error_message VARCHAR2(4000);
1963: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1964: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1965: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1966: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1967: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1968: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1969: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1970: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1963: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1964: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1965: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1966: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1967: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1968: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1969: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1970: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1971: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1964: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1965: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1966: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1967: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1968: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1969: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1970: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1971: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1972: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1965: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1966: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1967: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1968: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1969: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1970: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1971: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1972: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1973: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1966: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1967: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1968: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1969: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1970: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1971: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1972: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1973: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1974: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1967: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1968: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1969: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1970: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1971: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1972: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1973: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1974: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1975: l_fnd_warning VARCHAR2(1) := 'W';
1968: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1969: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1970: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1971: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1972: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1973: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1974: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1975: l_fnd_warning VARCHAR2(1) := 'W';
1976: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1969: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1970: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1971: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1972: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1973: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1974: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1975: l_fnd_warning VARCHAR2(1) := 'W';
1976: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1977: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;