[Home] [Help]
53: l_location_tbl csi_item_instance_pvt.location_tbl;
54: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
55: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
56: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
57: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
58: l_asset_count_rec csi_asset_pvt.asset_count_rec;
59: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
60: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
61: l_party NUMBER;
54: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
55: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
56: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
57: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
58: l_asset_count_rec csi_asset_pvt.asset_count_rec;
59: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
60: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
61: l_party NUMBER;
62: l_contact NUMBER;
55: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
56: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
57: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
58: l_asset_count_rec csi_asset_pvt.asset_count_rec;
59: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
60: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
61: l_party NUMBER;
62: l_contact NUMBER;
63: l_account NUMBER;
56: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
57: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
58: l_asset_count_rec csi_asset_pvt.asset_count_rec;
59: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
60: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
61: l_party NUMBER;
62: l_contact NUMBER;
63: l_account NUMBER;
64: l_party_tbl csi_datastructures_pub.party_tbl;
629: FOR tab_row IN p_asset_assignment_tbl.FIRST .. p_asset_assignment_tbl.LAST
630: LOOP
631: IF p_asset_assignment_tbl.EXISTS(tab_row) THEN
632: p_asset_assignment_tbl(tab_row).instance_id := p_instance_rec.instance_id;
633: csi_asset_pvt.create_instance_asset
634: (
635: p_api_version => p_api_version
636: ,p_commit => fnd_api.g_false
637: ,p_init_msg_list => p_init_msg_list
652: WHILE l_msg_count > 0 LOOP
653: x_msg_data := FND_MSG_PUB.GET
654: ( l_msg_index,
655: FND_API.G_FALSE );
656: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
657: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
658: l_msg_index := l_msg_index + 1;
659: l_msg_count := l_msg_count - 1;
660: END LOOP;
1268: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
1269: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
1270: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
1271: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
1272: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1273: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1274: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1275: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1276: l_updated BOOLEAN := FALSE;
1269: l_ext_count_rec csi_item_instance_pvt.ext_count_rec;
1270: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
1271: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
1272: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1273: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1274: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1275: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1276: l_updated BOOLEAN := FALSE;
1277: l_date BOOLEAN := FALSE;
1270: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
1271: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
1272: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1273: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1274: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1275: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1276: l_updated BOOLEAN := FALSE;
1277: l_date BOOLEAN := FALSE;
1278: l_curr_party_id NUMBER; -- Added for 2972082
1271: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
1272: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
1273: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1274: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1275: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1276: l_updated BOOLEAN := FALSE;
1277: l_date BOOLEAN := FALSE;
1278: l_curr_party_id NUMBER; -- Added for 2972082
1279: l_cascade_party_tbl csi_datastructures_pub.party_tbl; -- Added for 2972082
2590: IF p_asset_assignment_tbl.EXISTS(tab_row) THEN
2591: IF ((p_asset_assignment_tbl(tab_row).instance_asset_id IS NULL)
2592: OR
2593: (p_asset_assignment_tbl(tab_row).instance_asset_id = FND_API.G_MISS_NUM)) THEN
2594: csi_asset_pvt.create_instance_asset
2595: (p_api_version => p_api_version
2596: ,p_commit => fnd_api.g_false
2597: ,p_init_msg_list => p_init_msg_list
2598: ,p_validation_level => p_validation_level
2607: ,p_asset_loc_tbl => l_asset_loc_tbl
2608: );
2609: ELSE
2610: --call the update assets api
2611: csi_asset_pvt.update_instance_asset
2612: (p_api_version => p_api_version
2613: ,p_commit => fnd_api.g_false
2614: ,p_init_msg_list => p_init_msg_list
2615: ,p_validation_level => p_validation_level
4773:
4774: IF p_get_asset_assignments = fnd_api.g_true THEN
4775:
4776: l_instance_asset_query_rec.instance_id := p_instance_rec.instance_id;
4777: csi_asset_pvt.get_instance_assets
4778: (
4779: p_api_version => p_api_version
4780: ,p_commit => fnd_api.g_false
4781: ,p_init_msg_list => fnd_api.g_false
4794: WHILE l_msg_count > 0 LOOP
4795: x_msg_data := FND_MSG_PUB.GET
4796: ( l_msg_index,
4797: FND_API.G_FALSE );
4798: csi_gen_utility_pvt.put_line( ' Error from csi_asset_pvt.get_instance_assets.. ');
4799: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4800: l_msg_index := l_msg_index + 1;
4801: l_msg_count := l_msg_count - 1;
4802: END LOOP;