DBA Data[Home] [Help]

APPS.CSI_FA_INSTANCE_GRP dependencies on CSI_ASSET_PVT

Line 1225: l_lookup_tbl csi_asset_pvt.lookup_tbl;

1221: l_fa_quantity number;
1222: l_fa_book_type_code varchar2(30);
1223:
1224: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1225: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1226: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1227: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1228: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1229:

Line 1226: l_asset_count_rec csi_asset_pvt.asset_count_rec;

1222: l_fa_book_type_code varchar2(30);
1223:
1224: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1225: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1226: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1227: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1228: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1229:
1230: g_ia_ind binary_integer := 0;

Line 1227: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

1223:
1224: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1225: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1226: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1227: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1228: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1229:
1230: g_ia_ind binary_integer := 0;
1231:

Line 1228: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

1224: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1225: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1226: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1227: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1228: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1229:
1230: g_ia_ind binary_integer := 0;
1231:
1232: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1348: l_lookup_tbl csi_asset_pvt.lookup_tbl;

1344: x_error_message OUT nocopy varchar2)
1345: IS
1346:
1347: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1348: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1349: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1350: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1351: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1352: l_warning_flag varchar2(1) := 'N';

Line 1349: l_asset_count_rec csi_asset_pvt.asset_count_rec;

1345: IS
1346:
1347: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1348: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1349: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1350: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1351: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1352: l_warning_flag varchar2(1) := 'N';
1353:

Line 1350: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

1346:
1347: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1348: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1349: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1350: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1351: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1352: l_warning_flag varchar2(1) := 'N';
1353:
1354: l_return_status varchar2(2000) := fnd_api.g_ret_sts_success;

Line 1351: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

1347: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1348: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1349: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1350: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1351: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1352: l_warning_flag varchar2(1) := 'N';
1353:
1354: l_return_status varchar2(2000) := fnd_api.g_ret_sts_success;
1355: l_msg_count number;

Line 1383: csi_asset_pvt.update_instance_asset (

1379: LOOP
1380:
1381: l_instance_asset_rec := p_instance_asset_tbl(l_ind);
1382:
1383: csi_asset_pvt.update_instance_asset (
1384: p_api_version => 1.0,
1385: p_commit => fnd_api.g_false,
1386: p_init_msg_list => fnd_api.g_true,
1387: p_validation_level => fnd_api.g_valid_level_full,

Line 1439: l_lookup_tbl csi_asset_pvt.lookup_tbl;

1435: IS
1436:
1437: l_fixed_asset_rec fixed_asset_rec;
1438: l_instance_rec csi_datastructures_pub.instance_rec;
1439: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1440: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1441: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1442: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1443:

Line 1440: l_asset_count_rec csi_asset_pvt.asset_count_rec;

1436:
1437: l_fixed_asset_rec fixed_asset_rec;
1438: l_instance_rec csi_datastructures_pub.instance_rec;
1439: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1440: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1441: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1442: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1443:
1444: l_asset_quantity number;

Line 1441: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

1437: l_fixed_asset_rec fixed_asset_rec;
1438: l_instance_rec csi_datastructures_pub.instance_rec;
1439: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1440: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1441: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1442: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1443:
1444: l_asset_quantity number;
1445: l_asset_location_id number;

Line 1442: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

1438: l_instance_rec csi_datastructures_pub.instance_rec;
1439: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1440: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1441: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1442: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1443:
1444: l_asset_quantity number;
1445: l_asset_location_id number;
1446:

Line 1511: csi_asset_pvt.create_instance_asset(

1507: END IF;
1508:
1509: IF nvl(px_instance_asset_tbl(ia_ind).instance_asset_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1510:
1511: csi_asset_pvt.create_instance_asset(
1512: p_api_version => 1.0,
1513: p_commit => fnd_api.g_false,
1514: p_init_msg_list => fnd_api.g_true,
1515: p_validation_level => fnd_api.g_valid_level_full,