27343: l_location_tbl csi_item_instance_pvt.location_tbl;
27344: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27350: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27351: l_version_label VARCHAR2(30);
27344: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27350: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27351: l_version_label VARCHAR2(30);
27352: l_version_label_rec csi_datastructures_pub.version_label_rec;
27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27350: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27351: l_version_label VARCHAR2(30);
27352: l_version_label_rec csi_datastructures_pub.version_label_rec;
27353: l_obj_id NUMBER;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27350: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27351: l_version_label VARCHAR2(30);
27352: l_version_label_rec csi_datastructures_pub.version_label_rec;
27353: l_obj_id NUMBER;
27354: --
27599: l_instance_asset_query_rec.fa_asset_id := FND_API.G_MISS_NUM;
27600: l_instance_asset_query_rec.fa_book_type_code := FND_API.G_MISS_CHAR;
27601: l_instance_asset_query_rec.fa_location_id := FND_API.G_MISS_NUM;
27602: l_instance_asset_query_rec.update_status := FND_API.G_MISS_CHAR;
27603: csi_asset_pvt.get_instance_assets
27604: ( p_api_version => p_api_version
27605: ,p_commit => p_commit
27606: ,p_init_msg_list => p_init_msg_list
27607: ,p_validation_level => p_validation_level
28687: l_asset_tbl(tab_row).ACTIVE_START_DATE := FND_API.G_MISS_DATE;
28688: l_asset_tbl(tab_row).ACTIVE_END_DATE := FND_API.G_MISS_DATE;
28689: -- Trap the row in a record and create assets row by row
28690: l_instance_asset_rec := l_asset_tbl(tab_row);
28691: csi_asset_pvt.create_instance_asset
28692: ( p_api_version => p_api_version
28693: ,p_commit => p_commit
28694: ,p_init_msg_list => p_init_msg_list
28695: ,p_validation_level => p_validation_level
32149: l_map_count NUMBER := 0;
32150: l_rel_count NUMBER := 0;
32151: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32152: l_par_vld_organization_id NUMBER;
32153: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32154: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32157: l_version_label VARCHAR2(30);
32150: l_rel_count NUMBER := 0;
32151: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32152: l_par_vld_organization_id NUMBER;
32153: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32154: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32157: l_version_label VARCHAR2(30);
32158: l_version_label_rec csi_datastructures_pub.version_label_rec;
32151: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32152: l_par_vld_organization_id NUMBER;
32153: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32154: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32157: l_version_label VARCHAR2(30);
32158: l_version_label_rec csi_datastructures_pub.version_label_rec;
32159: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32152: l_par_vld_organization_id NUMBER;
32153: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32154: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32157: l_version_label VARCHAR2(30);
32158: l_version_label_rec csi_datastructures_pub.version_label_rec;
32159: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32160: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
32423: l_instance_asset_query_rec.fa_asset_id := FND_API.G_MISS_NUM;
32424: l_instance_asset_query_rec.fa_book_type_code := FND_API.G_MISS_CHAR;
32425: l_instance_asset_query_rec.fa_location_id := FND_API.G_MISS_NUM;
32426: l_instance_asset_query_rec.update_status := FND_API.G_MISS_CHAR;
32427: csi_asset_pvt.get_instance_assets
32428: ( p_api_version => p_api_version
32429: ,p_commit => p_commit
32430: ,p_init_msg_list => p_init_msg_list
32431: ,p_validation_level => p_validation_level
33449: l_asset_tbl(tab_row).ACTIVE_START_DATE := FND_API.G_MISS_DATE;
33450: l_asset_tbl(tab_row).ACTIVE_END_DATE := FND_API.G_MISS_DATE;
33451: -- Trap the row in a record and create assets row by row
33452: l_instance_asset_rec := l_asset_tbl(tab_row);
33453: csi_asset_pvt.create_instance_asset
33454: ( p_api_version => p_api_version
33455: ,p_commit => p_commit
33456: ,p_init_msg_list => p_init_msg_list
33457: ,p_validation_level => p_validation_level