eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_INV_HZ_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 9: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

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';

Line 26: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

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;

Line 27: l_update_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;

Line 28: l_update_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;

Line 29: l_update_source_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;

Line 30: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_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);

Line 31: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_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);
35: l_error_code VARCHAR2(50);

Line 32: l_new_src_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);
36: l_error_message VARCHAR2(4000);

Line 33: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_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);
37: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 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;

Line 38: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_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;
42: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 39: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

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;

Line 40: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_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;

Line 41: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_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;

Line 42: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_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;

Line 43: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_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;

Line 44: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_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;

Line 45: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_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;
49: l_fnd_warning VARCHAR2(1) := 'W';

Line 46: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_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';
50: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 47: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_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;
51: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 876: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

872:
873: PROCEDURE misc_receipt_hz_loc(p_transaction_id IN NUMBER,
874: p_message_id IN NUMBER,
875: x_return_status OUT NOCOPY VARCHAR2,
876: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
877: IS
878:
879: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
880: l_api_name VARCHAR2(100) := 'CSI_INV_HZ_PKG.MISC_RECEIPT_HZ_LOC';

Line 893: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

889: l_object_version_number NUMBER := 1;
890: l_sysdate DATE := SYSDATE;
891: l_master_organization_id NUMBER;
892: l_depreciable VARCHAR2(1);
893: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
894: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
895: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
896: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 894: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

890: l_sysdate DATE := SYSDATE;
891: l_master_organization_id NUMBER;
892: l_depreciable VARCHAR2(1);
893: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
894: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
895: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
896: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
898: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 895: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

891: l_master_organization_id NUMBER;
892: l_depreciable VARCHAR2(1);
893: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
894: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
895: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
896: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
898: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

Line 896: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

892: l_depreciable VARCHAR2(1);
893: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
894: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
895: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
896: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
898: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
900: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 897: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

893: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
894: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
895: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
896: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
898: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
900: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
901: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 898: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

894: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
895: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
896: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
898: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
900: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
901: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 899: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

895: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
896: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
898: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
900: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
901: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
903: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 900: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

896: l_instance_dest_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
897: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
898: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
900: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
901: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
903: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
904: l_return_status VARCHAR2(1);

Line 901: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

897: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
898: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
900: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
901: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
903: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
904: l_return_status VARCHAR2(1);
905: l_error_code VARCHAR2(50);

Line 902: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

898: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
899: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
900: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
901: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
903: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
904: l_return_status VARCHAR2(1);
905: l_error_code VARCHAR2(50);
906: l_error_message VARCHAR2(4000);

Line 903: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

899: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
900: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
901: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
902: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
903: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
904: l_return_status VARCHAR2(1);
905: l_error_code VARCHAR2(50);
906: l_error_message VARCHAR2(4000);
907: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

Line 907: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

903: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
904: l_return_status VARCHAR2(1);
905: l_error_code VARCHAR2(50);
906: l_error_message VARCHAR2(4000);
907: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
908: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
909: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
910: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 908: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

904: l_return_status VARCHAR2(1);
905: l_error_code VARCHAR2(50);
906: l_error_message VARCHAR2(4000);
907: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
908: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
909: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
910: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
912: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 909: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

905: l_error_code VARCHAR2(50);
906: l_error_message VARCHAR2(4000);
907: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
908: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
909: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
910: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
912: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
913: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 910: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

906: l_error_message VARCHAR2(4000);
907: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
908: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
909: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
910: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
912: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
913: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
914: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 911: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

907: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
908: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
909: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
910: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
912: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
913: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
914: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
915: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 912: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

908: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
909: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
910: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
912: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
913: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
914: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
915: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
916: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 913: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

909: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
910: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
912: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
913: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
914: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
915: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
916: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
917: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 914: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

910: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
911: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
912: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
913: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
914: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
915: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
916: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
917: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
918: l_fnd_warning VARCHAR2(1) := 'W';

Line 915: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

911: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
912: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
913: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
914: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
915: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
916: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
917: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
918: l_fnd_warning VARCHAR2(1) := 'W';
919: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 916: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

912: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
913: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
914: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
915: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
916: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
917: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
918: l_fnd_warning VARCHAR2(1) := 'W';
919: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
920: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2200: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

2196:
2197: PROCEDURE misc_issue_hz_loc(p_transaction_id IN NUMBER,
2198: p_message_id IN NUMBER,
2199: x_return_status OUT NOCOPY VARCHAR2,
2200: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2201: IS
2202:
2203: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2204: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_HZ_LOC';

Line 2217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

2213: l_object_version_number NUMBER := 1;
2214: l_sysdate DATE := SYSDATE;
2215: l_master_organization_id NUMBER;
2216: l_depreciable VARCHAR2(1);
2217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2218: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2219: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2220: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2221: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2218: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2214: l_sysdate DATE := SYSDATE;
2215: l_master_organization_id NUMBER;
2216: l_depreciable VARCHAR2(1);
2217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2218: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2219: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2220: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2221: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2222: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2219: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2215: l_master_organization_id NUMBER;
2216: l_depreciable VARCHAR2(1);
2217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2218: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2219: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2220: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2221: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2222: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2223: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2220: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2216: l_depreciable VARCHAR2(1);
2217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2218: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2219: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2220: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2221: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2222: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2223: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2224: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 2221: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2218: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2219: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2220: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2221: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2222: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2223: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2224: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2225: l_return_status VARCHAR2(1);

Line 2222: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2218: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2219: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2220: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2221: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2222: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2223: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2224: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2225: l_return_status VARCHAR2(1);
2226: l_error_code VARCHAR2(50);

Line 2223: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2219: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2220: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2221: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2222: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2223: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2224: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2225: l_return_status VARCHAR2(1);
2226: l_error_code VARCHAR2(50);
2227: l_error_message VARCHAR2(4000);

Line 2224: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

2220: l_update_source_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2221: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2222: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2223: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2224: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2225: l_return_status VARCHAR2(1);
2226: l_error_code VARCHAR2(50);
2227: l_error_message VARCHAR2(4000);
2228: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 2228: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

2224: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2225: l_return_status VARCHAR2(1);
2226: l_error_code VARCHAR2(50);
2227: l_error_message VARCHAR2(4000);
2228: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2229: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2230: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2231: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2232: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 2229: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

2225: l_return_status VARCHAR2(1);
2226: l_error_code VARCHAR2(50);
2227: l_error_message VARCHAR2(4000);
2228: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2229: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2230: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2231: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2232: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2233: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 2230: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

2226: l_error_code VARCHAR2(50);
2227: l_error_message VARCHAR2(4000);
2228: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2229: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2230: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2231: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2232: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2233: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2234: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 2231: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

2227: l_error_message VARCHAR2(4000);
2228: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2229: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2230: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2231: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2232: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2233: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2234: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2235: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 2232: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

2228: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2229: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2230: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2231: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2232: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2233: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2234: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2235: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2236: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 2233: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

2229: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2230: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2231: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2232: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2233: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2234: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2235: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2236: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2237: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 2234: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

2230: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2231: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2232: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2233: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2234: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2235: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2236: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2237: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2238: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 2235: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

2231: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2232: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2233: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2234: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2235: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2236: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2237: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2238: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2239: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2236: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

2232: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2233: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2234: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2235: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2236: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2237: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2238: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2239: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2240: l_fnd_warning VARCHAR2(1) := 'W';

Line 2237: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

2233: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2234: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2235: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2236: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2237: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2238: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2239: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2240: l_fnd_warning VARCHAR2(1) := 'W';
2241: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 2238: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

2234: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2235: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2236: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2237: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2238: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2239: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2240: l_fnd_warning VARCHAR2(1) := 'W';
2241: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2242: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;