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_ISO_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 9: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

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

Line 27: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

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;

Line 28: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_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;

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

Line 30: l_upd_src_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;

Line 31: l_update_dest_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;

Line 32: l_new_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;

Line 33: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_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;

Line 34: l_new_src_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;
38: l_return_status VARCHAR2(1);

Line 35: l_expire_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);
39: l_error_code VARCHAR2(50);

Line 36: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_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);
40: l_error_message VARCHAR2(4000);

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

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

Line 42: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_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;
46: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 43: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

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;

Line 44: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_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;

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

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

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

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

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

Line 50: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_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);
54: l_location_type VARCHAR2(20);

Line 51: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_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);
55: l_trx_action_type VARCHAR2(50);

Line 52: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_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);
56: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2008: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

2004:
2005: PROCEDURE iso_receipt(p_transaction_id IN NUMBER,
2006: p_message_id IN NUMBER,
2007: x_return_status OUT NOCOPY VARCHAR2,
2008: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2009: IS
2010:
2011: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2012: l_api_name VARCHAR2(100) := 'CSI_INV_ISO_PKG.ISO_RECEIPT';

Line 2025: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

2021: l_object_version_number NUMBER := 1;
2022: l_sysdate DATE := SYSDATE;
2023: l_master_organization_id NUMBER;
2024: l_depreciable VARCHAR2(1);
2025: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2026: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2027: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2028: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2029: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2026: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

2022: l_sysdate DATE := SYSDATE;
2023: l_master_organization_id NUMBER;
2024: l_depreciable VARCHAR2(1);
2025: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2026: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2027: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2028: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2029: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2030: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2027: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2023: l_master_organization_id NUMBER;
2024: l_depreciable VARCHAR2(1);
2025: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2026: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2027: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2028: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2029: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2030: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2031: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2028: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2024: l_depreciable VARCHAR2(1);
2025: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2026: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2027: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2028: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2029: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2030: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2031: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 2029: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2025: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2026: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2027: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2028: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2029: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2030: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2031: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 2030: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2026: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
2027: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2028: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2029: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2030: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2031: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2034: l_return_status VARCHAR2(1);

Line 2031: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2027: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2028: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2029: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2030: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2031: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2034: l_return_status VARCHAR2(1);
2035: l_error_code VARCHAR2(50);

Line 2032: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

2028: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2029: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2030: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2031: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2034: l_return_status VARCHAR2(1);
2035: l_error_code VARCHAR2(50);
2036: l_error_message VARCHAR2(4000);

Line 2033: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

2029: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2030: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2031: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2032: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
2033: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2034: l_return_status VARCHAR2(1);
2035: l_error_code VARCHAR2(50);
2036: l_error_message VARCHAR2(4000);
2037: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 2037: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

2033: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
2034: l_return_status VARCHAR2(1);
2035: l_error_code VARCHAR2(50);
2036: l_error_message VARCHAR2(4000);
2037: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2038: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2039: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2040: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2041: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 2038: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

2034: l_return_status VARCHAR2(1);
2035: l_error_code VARCHAR2(50);
2036: l_error_message VARCHAR2(4000);
2037: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2038: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2039: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2040: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2041: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2042: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 2039: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

2035: l_error_code VARCHAR2(50);
2036: l_error_message VARCHAR2(4000);
2037: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2038: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2039: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2040: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2041: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2042: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2043: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 2040: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

2036: l_error_message VARCHAR2(4000);
2037: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2038: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2039: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2040: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2041: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2042: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2043: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2044: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 2041: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

2037: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
2038: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2039: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2040: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2041: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2042: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2043: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2044: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2045: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 2042: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

2038: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
2039: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2040: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2041: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2042: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2043: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2044: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2045: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2046: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 2043: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

2039: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
2040: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2041: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2042: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2043: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2044: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2045: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2046: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2047: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 2044: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

2040: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2041: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2042: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2043: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2044: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2045: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2046: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2047: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2048: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 2045: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

2041: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2042: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2043: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2044: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2045: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2046: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2047: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2048: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2049: l_sub_inventory VARCHAR2(10);

Line 2046: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

2042: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
2043: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2044: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2045: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2046: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2047: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2048: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2049: l_sub_inventory VARCHAR2(10);
2050: l_location_type VARCHAR2(20);

Line 2047: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

2043: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2044: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2045: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2046: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2047: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2048: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2049: l_sub_inventory VARCHAR2(10);
2050: l_location_type VARCHAR2(20);
2051: l_trx_action_type VARCHAR2(50);

Line 2048: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

2044: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
2045: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
2046: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2047: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
2048: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
2049: l_sub_inventory VARCHAR2(10);
2050: l_location_type VARCHAR2(20);
2051: l_trx_action_type VARCHAR2(50);
2052: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2091: l_instance_header_rec csi_datastructures_pub.instance_header_rec;

2087: l_12_loop NUMBER := 0;
2088: l_redeploy_flag VARCHAR2(1);
2089: l_upd_error_instance_id NUMBER := NULL;
2090:
2091: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2092: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2093: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2094: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2095: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 2092: l_party_header_tbl csi_datastructures_pub.party_header_tbl;

2088: l_redeploy_flag VARCHAR2(1);
2089: l_upd_error_instance_id NUMBER := NULL;
2090:
2091: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2092: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2093: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2094: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2095: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2096: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 2093: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

2089: l_upd_error_instance_id NUMBER := NULL;
2090:
2091: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2092: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2093: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2094: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2095: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2096: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2097: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 2094: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;

2090:
2091: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2092: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2093: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2094: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2095: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2096: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2097: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2098: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 2095: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;

2091: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2092: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2093: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2094: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2095: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2096: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2097: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2098: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2099:

Line 2096: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;

2092: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
2093: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2094: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2095: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2096: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2097: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2098: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2099:
2100: cursor c_id is

Line 2097: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

2093: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
2094: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2095: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2096: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2097: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2098: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2099:
2100: cursor c_id is
2101: SELECT instance_status_id

Line 2098: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

2094: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
2095: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
2096: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2097: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
2098: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2099:
2100: cursor c_id is
2101: SELECT instance_status_id
2102: FROM csi_instance_statuses

Line 4022: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

4018:
4019: PROCEDURE iso_direct(p_transaction_id IN NUMBER,
4020: p_message_id IN NUMBER,
4021: x_return_status OUT NOCOPY VARCHAR2,
4022: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
4023: IS
4024:
4025: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
4026: l_api_name VARCHAR2(100) := 'CSI_INV_ISO_PKG.ISO_DIRECT';

Line 4039: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

4035: l_object_version_number NUMBER := 1;
4036: l_sysdate DATE := SYSDATE;
4037: l_master_organization_id NUMBER;
4038: l_depreciable VARCHAR2(1);
4039: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4040: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4041: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4042: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4043: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 4040: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

4036: l_sysdate DATE := SYSDATE;
4037: l_master_organization_id NUMBER;
4038: l_depreciable VARCHAR2(1);
4039: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4040: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4041: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4042: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4043: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4044: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 4041: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

4037: l_master_organization_id NUMBER;
4038: l_depreciable VARCHAR2(1);
4039: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4040: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4041: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4042: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4043: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4044: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4045: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 4042: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

4038: l_depreciable VARCHAR2(1);
4039: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4040: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4041: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4042: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4043: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4044: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4045: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4046: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 4043: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

4039: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4040: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4041: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4042: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4043: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4044: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4045: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4046: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4047: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 4044: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

4040: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
4041: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4042: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4043: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4044: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4045: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4046: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4047: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
4048: l_return_status VARCHAR2(1);

Line 4045: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

4041: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4042: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4043: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4044: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4045: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4046: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4047: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
4048: l_return_status VARCHAR2(1);
4049: l_error_code VARCHAR2(50);

Line 4046: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

4042: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4043: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4044: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4045: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4046: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4047: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
4048: l_return_status VARCHAR2(1);
4049: l_error_code VARCHAR2(50);
4050: l_error_message VARCHAR2(4000);

Line 4047: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

4043: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4044: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4045: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4046: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
4047: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
4048: l_return_status VARCHAR2(1);
4049: l_error_code VARCHAR2(50);
4050: l_error_message VARCHAR2(4000);
4051: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 4051: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

4047: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
4048: l_return_status VARCHAR2(1);
4049: l_error_code VARCHAR2(50);
4050: l_error_message VARCHAR2(4000);
4051: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
4052: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4053: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4054: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4055: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 4052: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

4048: l_return_status VARCHAR2(1);
4049: l_error_code VARCHAR2(50);
4050: l_error_message VARCHAR2(4000);
4051: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
4052: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4053: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4054: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4055: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4056: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 4053: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

4049: l_error_code VARCHAR2(50);
4050: l_error_message VARCHAR2(4000);
4051: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
4052: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4053: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4054: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4055: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4056: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4057: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 4054: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

4050: l_error_message VARCHAR2(4000);
4051: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
4052: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4053: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4054: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4055: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4056: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4057: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4058: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 4055: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

4051: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
4052: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4053: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4054: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4055: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4056: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4057: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4058: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4059: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 4056: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

4052: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
4053: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4054: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4055: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4056: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4057: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4058: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4059: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 4057: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

4053: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
4054: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4055: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4056: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4057: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4058: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4059: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4061: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 4058: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

4054: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4055: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4056: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4057: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4058: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4059: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4061: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
4062: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 4059: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

4055: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4056: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4057: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4058: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4059: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4061: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
4062: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
4063: l_sub_inventory VARCHAR2(10);

Line 4060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

4056: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
4057: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4058: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4059: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4061: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
4062: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
4063: l_sub_inventory VARCHAR2(10);
4064: l_location_type VARCHAR2(20);

Line 4061: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

4057: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
4058: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4059: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4061: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
4062: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
4063: l_sub_inventory VARCHAR2(10);
4064: l_location_type VARCHAR2(20);
4065: l_trx_action_type VARCHAR2(50);

Line 4062: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

4058: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
4059: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
4060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
4061: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
4062: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
4063: l_sub_inventory VARCHAR2(10);
4064: l_location_type VARCHAR2(20);
4065: l_trx_action_type VARCHAR2(50);
4066: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;