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

Line 16: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

12:
13: PROCEDURE intransit_shipment(p_transaction_id IN NUMBER,
14: p_message_id IN NUMBER,
15: x_return_status OUT NOCOPY VARCHAR2,
16: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
17: IS
18:
19: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
20: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_SHIPMENT';

Line 33: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

29: l_object_version_number NUMBER := 1;
30: l_sysdate DATE := SYSDATE;
31: l_master_organization_id NUMBER;
32: l_depreciable VARCHAR2(1);
33: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

30: l_sysdate DATE := SYSDATE;
31: l_master_organization_id NUMBER;
32: l_depreciable VARCHAR2(1);
33: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

31: l_master_organization_id NUMBER;
32: l_depreciable VARCHAR2(1);
33: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

32: l_depreciable VARCHAR2(1);
33: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

33: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

34: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

35: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
43: l_return_status VARCHAR2(1);

Line 40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

36: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
43: l_return_status VARCHAR2(1);
44: l_error_code VARCHAR2(50);

Line 41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

37: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
43: l_return_status VARCHAR2(1);
44: l_error_code VARCHAR2(50);
45: l_error_message VARCHAR2(4000);

Line 42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

38: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
39: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
40: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
41: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
43: l_return_status VARCHAR2(1);
44: l_error_code VARCHAR2(50);
45: l_error_message VARCHAR2(4000);
46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

42: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
43: l_return_status VARCHAR2(1);
44: l_error_code VARCHAR2(50);
45: l_error_message VARCHAR2(4000);
46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

43: l_return_status VARCHAR2(1);
44: l_error_code VARCHAR2(50);
45: l_error_message VARCHAR2(4000);
46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

44: l_error_code VARCHAR2(50);
45: l_error_message VARCHAR2(4000);
46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

45: l_error_message VARCHAR2(4000);
46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

46: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

47: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

48: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

49: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

50: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
58: l_sub_inventory VARCHAR2(10);

Line 55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

51: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
58: l_sub_inventory VARCHAR2(10);
59: l_location_type VARCHAR2(20);

Line 56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

52: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
58: l_sub_inventory VARCHAR2(10);
59: l_location_type VARCHAR2(20);
60: l_trx_action_type VARCHAR2(50);

Line 57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

53: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
54: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
55: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
56: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
57: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
58: l_sub_inventory VARCHAR2(10);
59: l_location_type VARCHAR2(20);
60: l_trx_action_type VARCHAR2(50);
61: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 132: l_def_in_transit_loc_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;

128: debug('csiorgtb.pls 115.23');
129: debug('Transaction ID with is: '||p_transaction_id);
130:
131: -- Get the default in transit location id
132: l_def_in_transit_loc_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;
133:
134: debug('Default In Transit Loc IDs: '||l_def_in_transit_loc_id);
135:
136: -- This procedure queries all of the Inventory Transaction Records and

Line 1199: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

1195:
1196: PROCEDURE intransit_receipt(p_transaction_id IN NUMBER,
1197: p_message_id IN NUMBER,
1198: x_return_status OUT NOCOPY VARCHAR2,
1199: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
1200: IS
1201:
1202: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1203: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';

Line 1216: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

1212: l_object_version_number NUMBER := 1;
1213: l_sysdate DATE := SYSDATE;
1214: l_master_organization_id NUMBER;
1215: l_depreciable VARCHAR2(1);
1216: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
1217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1218: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1219: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1220: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 1217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

1213: l_sysdate DATE := SYSDATE;
1214: l_master_organization_id NUMBER;
1215: l_depreciable VARCHAR2(1);
1216: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
1217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1218: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1219: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1220: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1221: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 1218: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

1214: l_master_organization_id NUMBER;
1215: l_depreciable VARCHAR2(1);
1216: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
1217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1218: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1219: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1220: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1221: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1222: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 1219: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1215: l_depreciable VARCHAR2(1);
1216: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
1217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1218: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1219: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1220: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1221: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1222: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1223: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 1220: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1216: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
1217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1218: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1219: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1220: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1221: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1222: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1223: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1224: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 1221: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1217: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1218: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1219: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1220: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1221: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1222: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1223: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1224: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1225: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 1222: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1218: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
1219: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1220: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1221: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1222: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1223: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1224: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1225: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1226: l_return_status VARCHAR2(1);

Line 1223: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1219: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1220: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1221: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1222: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1223: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1224: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1225: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1226: l_return_status VARCHAR2(1);
1227: l_error_code VARCHAR2(50);

Line 1224: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

1220: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1221: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1222: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1223: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1224: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1225: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1226: l_return_status VARCHAR2(1);
1227: l_error_code VARCHAR2(50);
1228: l_error_message VARCHAR2(4000);

Line 1225: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

1221: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1222: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1223: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1224: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
1225: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1226: l_return_status VARCHAR2(1);
1227: l_error_code VARCHAR2(50);
1228: l_error_message VARCHAR2(4000);
1229: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 1229: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

1225: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
1226: l_return_status VARCHAR2(1);
1227: l_error_code VARCHAR2(50);
1228: l_error_message VARCHAR2(4000);
1229: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1230: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1231: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1232: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1233: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 1230: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

1226: l_return_status VARCHAR2(1);
1227: l_error_code VARCHAR2(50);
1228: l_error_message VARCHAR2(4000);
1229: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1230: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1231: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1232: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1233: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1234: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 1231: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

1227: l_error_code VARCHAR2(50);
1228: l_error_message VARCHAR2(4000);
1229: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1230: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1231: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1232: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1233: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1234: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1235: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 1232: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

1228: l_error_message VARCHAR2(4000);
1229: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1230: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1231: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1232: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1233: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1234: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1235: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1236: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 1233: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

1229: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
1230: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1231: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1232: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1233: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1234: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1235: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1236: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1237: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 1234: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

1230: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
1231: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1232: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1233: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1234: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1235: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1236: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1237: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1238: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 1235: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

1231: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
1232: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1233: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1234: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1235: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1236: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1237: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1238: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1239: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 1236: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

1232: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1233: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1234: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1235: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1236: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1237: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1238: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1239: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1240: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 1237: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

1233: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1234: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1235: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1236: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1237: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1238: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1239: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1240: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1241: l_sub_inventory VARCHAR2(10);

Line 1238: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

1234: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
1235: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1236: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1237: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1238: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1239: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1240: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1241: l_sub_inventory VARCHAR2(10);
1242: l_location_type VARCHAR2(20);

Line 1239: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

1235: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1236: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1237: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1238: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1239: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1240: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1241: l_sub_inventory VARCHAR2(10);
1242: l_location_type VARCHAR2(20);
1243: l_trx_action_type VARCHAR2(50);

Line 1240: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

1236: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
1237: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
1238: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1239: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
1240: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
1241: l_sub_inventory VARCHAR2(10);
1242: l_location_type VARCHAR2(20);
1243: l_trx_action_type VARCHAR2(50);
1244: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1286: l_instance_header_rec csi_datastructures_pub.instance_header_rec;

1282: l_ownership_party VARCHAR2(1);
1283: l_redeploy_flag VARCHAR2(1);
1284: l_upd_error_instance_id NUMBER := NULL;
1285:
1286: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1287: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1288: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1289: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1290: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1287: l_party_header_tbl csi_datastructures_pub.party_header_tbl;

1283: l_redeploy_flag VARCHAR2(1);
1284: l_upd_error_instance_id NUMBER := NULL;
1285:
1286: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1287: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1288: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1289: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1290: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1291: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1288: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

1284: l_upd_error_instance_id NUMBER := NULL;
1285:
1286: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1287: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1288: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1289: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1290: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1291: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1292: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 1289: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;

1285:
1286: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1287: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1288: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1289: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1290: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1291: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1292: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1293: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 1290: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;

1286: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1287: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1288: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1289: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1290: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1291: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1292: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1293: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1294:

Line 1291: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1287: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
1288: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1289: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1290: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1291: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1292: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1293: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1294:
1295: cursor c_id is

Line 1292: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

1288: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
1289: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1290: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1291: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1292: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1293: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1294:
1295: cursor c_id is
1296: SELECT instance_status_id

Line 1293: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

1289: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
1290: l_pricing_header_tbl csi_datastructures_pub.pricing_attribs_tbl;
1291: l_ext_attrib_header_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1292: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
1293: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1294:
1295: cursor c_id is
1296: SELECT instance_status_id
1297: FROM csi_instance_statuses

Line 1377: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;

1373:
1374: debug('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);
1375:
1376: -- Get Party ownership Flag
1377: l_ownership_party := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
1378:
1379: debug('Ownership Party FLag is: '||l_ownership_party)
1380: ;
1381:

Line 3030: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

3026:
3027: PROCEDURE direct_shipment(p_transaction_id IN NUMBER,
3028: p_message_id IN NUMBER,
3029: x_return_status OUT NOCOPY VARCHAR2,
3030: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
3031: IS
3032:
3033: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
3034: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';

Line 3047: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

3043: l_object_version_number NUMBER := 1;
3044: l_sysdate DATE := SYSDATE;
3045: l_master_organization_id NUMBER;
3046: l_depreciable VARCHAR2(1);
3047: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
3048: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3049: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3050: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3051: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 3048: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

3044: l_sysdate DATE := SYSDATE;
3045: l_master_organization_id NUMBER;
3046: l_depreciable VARCHAR2(1);
3047: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
3048: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3049: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3050: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3051: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3052: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 3049: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;

3045: l_master_organization_id NUMBER;
3046: l_depreciable VARCHAR2(1);
3047: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
3048: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3049: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3050: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3051: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3052: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3053: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 3050: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

3046: l_depreciable VARCHAR2(1);
3047: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
3048: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3049: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3050: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3051: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3052: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3053: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3054: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 3051: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

3047: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
3048: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3049: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3050: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3051: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3052: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3053: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3054: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3055: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

Line 3052: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

3048: l_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3049: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3050: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3051: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3052: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3053: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3054: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3055: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3056: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 3053: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

3049: l_dest_instance_query_rec CSI_DATASTRUCTURES_PUB.INSTANCE_QUERY_REC;
3050: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3051: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3052: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3053: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3054: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3055: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3056: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
3057: l_return_status VARCHAR2(1);

Line 3054: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

3050: l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3051: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3052: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3053: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3054: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3055: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3056: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
3057: l_return_status VARCHAR2(1);
3058: l_error_code VARCHAR2(50);

Line 3055: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

3051: l_upd_src_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3052: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3053: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3054: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3055: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3056: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
3057: l_return_status VARCHAR2(1);
3058: l_error_code VARCHAR2(50);
3059: l_error_message VARCHAR2(4000);

Line 3056: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

3052: l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3053: l_new_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3054: l_new_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3055: l_new_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
3056: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
3057: l_return_status VARCHAR2(1);
3058: l_error_code VARCHAR2(50);
3059: l_error_message VARCHAR2(4000);
3060: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

Line 3060: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;

3056: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
3057: l_return_status VARCHAR2(1);
3058: l_error_code VARCHAR2(50);
3059: l_error_message VARCHAR2(4000);
3060: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
3061: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3062: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3063: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3064: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 3061: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;

3057: l_return_status VARCHAR2(1);
3058: l_error_code VARCHAR2(50);
3059: l_error_message VARCHAR2(4000);
3060: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
3061: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3062: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3063: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3064: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3065: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

Line 3062: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;

3058: l_error_code VARCHAR2(50);
3059: l_error_message VARCHAR2(4000);
3060: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
3061: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3062: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3063: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3064: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3065: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3066: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 3063: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

3059: l_error_message VARCHAR2(4000);
3060: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
3061: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3062: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3063: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3064: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3065: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3066: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3067: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

Line 3064: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

3060: l_instance_id_lst CSI_DATASTRUCTURES_PUB.ID_TBL;
3061: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3062: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3063: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3064: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3065: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3066: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3067: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3068: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

Line 3065: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;

3061: l_party_query_rec CSI_DATASTRUCTURES_PUB.PARTY_QUERY_REC;
3062: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3063: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3064: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3065: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3066: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3067: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3068: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3069: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 3066: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

3062: l_account_query_rec CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_QUERY_REC;
3063: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3064: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3065: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3066: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3067: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3068: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3069: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3070: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 3067: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

3063: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3064: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3065: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3066: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3067: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3068: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3069: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3070: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
3071: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 3068: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

3064: l_src_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3065: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3066: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3067: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3068: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3069: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3070: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
3071: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
3072: l_sub_inventory VARCHAR2(10);

Line 3069: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

3065: l_dest_instance_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_TBL;
3066: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3067: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3068: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3069: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3070: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
3071: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
3072: l_sub_inventory VARCHAR2(10);
3073: l_location_type VARCHAR2(20);

Line 3070: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

3066: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3067: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3068: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3069: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3070: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
3071: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
3072: l_sub_inventory VARCHAR2(10);
3073: l_location_type VARCHAR2(20);
3074: l_trx_action_type VARCHAR2(50);

Line 3071: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

3067: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
3068: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
3069: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
3070: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
3071: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
3072: l_sub_inventory VARCHAR2(10);
3073: l_location_type VARCHAR2(20);
3074: l_trx_action_type VARCHAR2(50);
3075: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;