DBA Data[Home] [Help]

APPS.CSI_FA_INSTANCE_GRP dependencies on CSI_ASSET_PVT

Line 1200: l_lookup_tbl csi_asset_pvt.lookup_tbl;

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:

Line 1201: l_asset_count_rec csi_asset_pvt.asset_count_rec;

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;

Line 1202: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

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:

Line 1203: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

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;

Line 1323: l_lookup_tbl csi_asset_pvt.lookup_tbl;

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

Line 1324: l_asset_count_rec csi_asset_pvt.asset_count_rec;

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:

Line 1325: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

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;

Line 1326: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

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;

Line 1358: csi_asset_pvt.update_instance_asset (

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,

Line 1414: l_lookup_tbl csi_asset_pvt.lookup_tbl;

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:

Line 1415: l_asset_count_rec csi_asset_pvt.asset_count_rec;

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;

Line 1416: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

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;

Line 1417: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

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:

Line 1486: csi_asset_pvt.create_instance_asset(

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,