1196: l_fa_quantity number;
1197: l_fa_book_type_code varchar2(30);
1198:
1199: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1200: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1201: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1202: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1203: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1204:
1197: l_fa_book_type_code varchar2(30);
1198:
1199: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1200: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1201: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1202: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1203: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1204:
1205: g_ia_ind binary_integer := 0;
1198:
1199: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1200: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1201: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1202: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1203: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1204:
1205: g_ia_ind binary_integer := 0;
1206:
1199: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1200: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1201: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1202: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1203: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1204:
1205: g_ia_ind binary_integer := 0;
1206:
1207: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1319: x_error_message OUT nocopy varchar2)
1320: IS
1321:
1322: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1323: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1324: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1325: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1326: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1327: l_warning_flag varchar2(1) := 'N';
1320: IS
1321:
1322: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1323: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1324: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1325: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1326: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1327: l_warning_flag varchar2(1) := 'N';
1328:
1321:
1322: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1323: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1324: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1325: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1326: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1327: l_warning_flag varchar2(1) := 'N';
1328:
1329: l_return_status varchar2(2000) := fnd_api.g_ret_sts_success;
1322: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1323: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1324: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1325: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1326: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1327: l_warning_flag varchar2(1) := 'N';
1328:
1329: l_return_status varchar2(2000) := fnd_api.g_ret_sts_success;
1330: l_msg_count number;
1354: LOOP
1355:
1356: l_instance_asset_rec := p_instance_asset_tbl(l_ind);
1357:
1358: csi_asset_pvt.update_instance_asset (
1359: p_api_version => 1.0,
1360: p_commit => fnd_api.g_false,
1361: p_init_msg_list => fnd_api.g_true,
1362: p_validation_level => fnd_api.g_valid_level_full,
1410: IS
1411:
1412: l_fixed_asset_rec fixed_asset_rec;
1413: l_instance_rec csi_datastructures_pub.instance_rec;
1414: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1415: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1416: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1417: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1418:
1411:
1412: l_fixed_asset_rec fixed_asset_rec;
1413: l_instance_rec csi_datastructures_pub.instance_rec;
1414: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1415: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1416: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1417: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1418:
1419: l_asset_quantity number;
1412: l_fixed_asset_rec fixed_asset_rec;
1413: l_instance_rec csi_datastructures_pub.instance_rec;
1414: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1415: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1416: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1417: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1418:
1419: l_asset_quantity number;
1420: l_asset_location_id number;
1413: l_instance_rec csi_datastructures_pub.instance_rec;
1414: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1415: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1416: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1417: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1418:
1419: l_asset_quantity number;
1420: l_asset_location_id number;
1421:
1482: END IF;
1483:
1484: IF nvl(px_instance_asset_tbl(ia_ind).instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1485:
1486: csi_asset_pvt.create_instance_asset(
1487: p_api_version => 1.0,
1488: p_commit => fnd_api.g_false,
1489: p_init_msg_list => fnd_api.g_true,
1490: p_validation_level => fnd_api.g_valid_level_full,