5:
6: PROCEDURE iso_shipment(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_TRXS_PKG.ISO_SHIPMENT';
23: l_object_version_number NUMBER := 1;
24: l_sysdate DATE := SYSDATE;
25: l_master_organization_id NUMBER;
26: l_depreciable VARCHAR2(1);
27: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
28: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
29: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
24: l_sysdate DATE := SYSDATE;
25: l_master_organization_id NUMBER;
26: l_depreciable VARCHAR2(1);
27: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
28: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
29: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
25: l_master_organization_id NUMBER;
26: l_depreciable VARCHAR2(1);
27: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
28: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
29: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
26: l_depreciable VARCHAR2(1);
27: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
28: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
29: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
34: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
27: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
28: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
29: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
34: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
35: l_expire_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
28: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
29: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
34: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
35: l_expire_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
29: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
30: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
34: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
35: l_expire_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
37: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
30: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
31: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
34: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
35: l_expire_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
37: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
38: l_return_status VARCHAR2(1);
31: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
32: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
34: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
35: l_expire_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
37: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
38: l_return_status VARCHAR2(1);
39: l_error_code VARCHAR2(50);
32: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
33: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
34: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
35: l_expire_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
37: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
38: l_return_status VARCHAR2(1);
39: l_error_code VARCHAR2(50);
40: l_error_message VARCHAR2(4000);
33: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
34: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
35: l_expire_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
36: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
37: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
38: l_return_status VARCHAR2(1);
39: l_error_code VARCHAR2(50);
40: l_error_message VARCHAR2(4000);
41: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
37: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
38: l_return_status VARCHAR2(1);
39: l_error_code VARCHAR2(50);
40: l_error_message VARCHAR2(4000);
41: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
42: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
43: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
44: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
38: l_return_status VARCHAR2(1);
39: l_error_code VARCHAR2(50);
40: l_error_message VARCHAR2(4000);
41: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
42: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
43: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
44: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
39: l_error_code VARCHAR2(50);
40: l_error_message VARCHAR2(4000);
41: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
42: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
43: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
44: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
47: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
40: l_error_message VARCHAR2(4000);
41: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
42: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
43: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
44: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
47: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
48: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
41: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
42: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
43: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
44: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
47: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
48: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
49: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
42: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
43: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
44: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
47: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
48: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
49: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
50: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
43: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
44: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
47: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
48: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
49: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
50: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
51: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
44: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
47: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
48: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
49: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
50: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
51: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
52: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
45: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
46: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
47: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
48: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
49: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
50: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
51: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
52: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
53: l_sub_inventory VARCHAR2(10);
46: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
47: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
48: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
49: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
50: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
51: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
52: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
53: l_sub_inventory VARCHAR2(10);
54: l_location_type VARCHAR2(20);
47: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
48: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
49: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
50: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
51: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
52: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
53: l_sub_inventory VARCHAR2(10);
54: l_location_type VARCHAR2(20);
55: l_trx_action_type VARCHAR2(50);
48: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
49: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
50: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
51: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
52: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
53: l_sub_inventory VARCHAR2(10);
54: l_location_type VARCHAR2(20);
55: l_trx_action_type VARCHAR2(50);
56: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2008:
2009: PROCEDURE iso_receipt(p_transaction_id IN NUMBER,
2010: p_message_id IN NUMBER,
2011: x_return_status OUT NOCOPY VARCHAR2,
2012: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2013: IS
2014:
2015: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2016: l_api_name VARCHAR2(100) := 'CSI_INV_ISO_PKG.ISO_RECEIPT';
2025: l_object_version_number NUMBER := 1;
2026: l_sysdate DATE := SYSDATE;
2027: l_master_organization_id NUMBER;
2028: l_depreciable VARCHAR2(1);
2029: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2030: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2031: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2026: l_sysdate DATE := SYSDATE;
2027: l_master_organization_id NUMBER;
2028: l_depreciable VARCHAR2(1);
2029: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2030: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2031: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2034: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2027: l_master_organization_id NUMBER;
2028: l_depreciable VARCHAR2(1);
2029: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2030: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2031: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2034: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2035: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2028: l_depreciable VARCHAR2(1);
2029: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2030: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2031: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2034: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2035: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2036: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2029: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2030: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2031: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2034: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2035: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2036: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2037: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2030: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2031: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2034: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2035: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2036: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2037: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2038: l_return_status VARCHAR2(1);
2031: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2034: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2035: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2036: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2037: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2038: l_return_status VARCHAR2(1);
2039: l_error_code VARCHAR2(50);
2032: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2034: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2035: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2036: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2037: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2038: l_return_status VARCHAR2(1);
2039: l_error_code VARCHAR2(50);
2040: l_error_message VARCHAR2(4000);
2033: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2034: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2035: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2036: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2037: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2038: l_return_status VARCHAR2(1);
2039: l_error_code VARCHAR2(50);
2040: l_error_message VARCHAR2(4000);
2041: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2037: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2038: l_return_status VARCHAR2(1);
2039: l_error_code VARCHAR2(50);
2040: l_error_message VARCHAR2(4000);
2041: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2042: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2043: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2044: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2045: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2038: l_return_status VARCHAR2(1);
2039: l_error_code VARCHAR2(50);
2040: l_error_message VARCHAR2(4000);
2041: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2042: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2043: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2044: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2045: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2046: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2039: l_error_code VARCHAR2(50);
2040: l_error_message VARCHAR2(4000);
2041: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2042: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2043: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2044: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2045: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2046: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2047: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2040: l_error_message VARCHAR2(4000);
2041: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2042: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2043: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2044: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2045: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2046: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2047: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2048: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2041: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2042: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2043: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2044: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2045: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2046: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2047: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2048: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2049: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2042: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2043: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2044: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2045: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2046: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2047: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2048: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2049: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2050: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2043: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2044: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2045: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2046: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2047: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2048: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2049: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2050: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2051: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2044: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2045: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2046: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2047: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2048: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2049: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2050: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2051: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2052: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2045: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2046: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2047: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2048: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2049: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2050: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2051: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2052: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2053: l_sub_inventory VARCHAR2(10);
2046: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2047: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2048: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2049: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2050: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2051: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2052: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2053: l_sub_inventory VARCHAR2(10);
2054: l_location_type VARCHAR2(20);
2047: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2048: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2049: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2050: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2051: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2052: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2053: l_sub_inventory VARCHAR2(10);
2054: l_location_type VARCHAR2(20);
2055: l_trx_action_type VARCHAR2(50);
2048: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2049: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2050: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2051: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2052: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2053: l_sub_inventory VARCHAR2(10);
2054: l_location_type VARCHAR2(20);
2055: l_trx_action_type VARCHAR2(50);
2056: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2091: l_12_loop NUMBER := 0;
2092: l_redeploy_flag VARCHAR2(1);
2093: l_upd_error_instance_id NUMBER := NULL;
2094:
2095: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2096: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2097: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2098: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2099: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2092: l_redeploy_flag VARCHAR2(1);
2093: l_upd_error_instance_id NUMBER := NULL;
2094:
2095: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2096: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2097: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2098: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2099: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2100: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2093: l_upd_error_instance_id NUMBER := NULL;
2094:
2095: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2096: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2097: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2098: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2099: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2100: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2101: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2094:
2095: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2096: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2097: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2098: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2099: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2100: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2101: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2102: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2095: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2096: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2097: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2098: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2099: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2100: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2101: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2102: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2103:
2096: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2097: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2098: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2099: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2100: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2101: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2102: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2103:
2104: cursor c_id is
2097: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2098: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2099: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2100: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2101: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2102: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2103:
2104: cursor c_id is
2105: SELECT instance_status_id
2098: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2099: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2100: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2101: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2102: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2103:
2104: cursor c_id is
2105: SELECT instance_status_id
2106: FROM csi_instance_statuses
4038:
4039: PROCEDURE iso_direct(p_transaction_id IN NUMBER,
4040: p_message_id IN NUMBER,
4041: x_return_status OUT NOCOPY VARCHAR2,
4042: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
4043: IS
4044:
4045: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
4046: l_api_name VARCHAR2(100) := 'CSI_INV_ISO_PKG.ISO_DIRECT';
4055: l_object_version_number NUMBER := 1;
4056: l_sysdate DATE := SYSDATE;
4057: l_master_organization_id NUMBER;
4058: l_depreciable VARCHAR2(1);
4059: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4060: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4061: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4062: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4063: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4056: l_sysdate DATE := SYSDATE;
4057: l_master_organization_id NUMBER;
4058: l_depreciable VARCHAR2(1);
4059: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4060: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4061: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4062: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4063: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4064: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4057: l_master_organization_id NUMBER;
4058: l_depreciable VARCHAR2(1);
4059: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4060: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4061: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4062: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4063: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4064: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4065: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4058: l_depreciable VARCHAR2(1);
4059: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4060: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4061: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4062: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4063: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4064: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4065: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4066: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4059: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4060: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4061: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4062: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4063: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4064: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4065: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4066: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4067: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
4060: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4061: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4062: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4063: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4064: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4065: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4066: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4067: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
4068: l_return_status VARCHAR2(1);
4061: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4062: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4063: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4064: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4065: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4066: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4067: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
4068: l_return_status VARCHAR2(1);
4069: l_error_code VARCHAR2(50);
4062: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4063: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4064: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4065: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4066: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4067: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
4068: l_return_status VARCHAR2(1);
4069: l_error_code VARCHAR2(50);
4070: l_error_message VARCHAR2(4000);
4063: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4064: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4065: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4066: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4067: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
4068: l_return_status VARCHAR2(1);
4069: l_error_code VARCHAR2(50);
4070: l_error_message VARCHAR2(4000);
4071: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
4067: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
4068: l_return_status VARCHAR2(1);
4069: l_error_code VARCHAR2(50);
4070: l_error_message VARCHAR2(4000);
4071: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
4072: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4073: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4074: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4075: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4068: l_return_status VARCHAR2(1);
4069: l_error_code VARCHAR2(50);
4070: l_error_message VARCHAR2(4000);
4071: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
4072: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4073: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4074: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4075: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4076: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4069: l_error_code VARCHAR2(50);
4070: l_error_message VARCHAR2(4000);
4071: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
4072: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4073: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4074: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4075: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4076: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4077: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4070: l_error_message VARCHAR2(4000);
4071: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
4072: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4073: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4074: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4075: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4076: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4077: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4078: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4071: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
4072: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4073: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4074: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4075: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4076: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4077: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4078: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4079: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4072: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4073: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4074: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4075: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4076: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4077: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4078: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4079: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4080: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4073: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4074: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4075: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4076: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4077: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4078: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4079: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4080: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4081: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
4074: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4075: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4076: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4077: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4078: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4079: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4080: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4081: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
4082: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
4075: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4076: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4077: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4078: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4079: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4080: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4081: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
4082: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
4083: l_sub_inventory VARCHAR2(10);
4076: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4077: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4078: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4079: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4080: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4081: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
4082: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
4083: l_sub_inventory VARCHAR2(10);
4084: l_location_type VARCHAR2(20);
4077: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4078: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4079: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4080: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4081: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
4082: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
4083: l_sub_inventory VARCHAR2(10);
4084: l_location_type VARCHAR2(20);
4085: l_trx_action_type VARCHAR2(50);
4078: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4079: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4080: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4081: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
4082: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
4083: l_sub_inventory VARCHAR2(10);
4084: l_location_type VARCHAR2(20);
4085: l_trx_action_type VARCHAR2(50);
4086: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;