27920: l_location_tbl csi_item_instance_pvt.location_tbl;
27921: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27926: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27927: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27928: l_version_label VARCHAR2(30);
27921: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27926: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27927: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27928: l_version_label VARCHAR2(30);
27929: l_version_label_rec csi_datastructures_pub.version_label_rec;
27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27926: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27927: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27928: l_version_label VARCHAR2(30);
27929: l_version_label_rec csi_datastructures_pub.version_label_rec;
27930: l_obj_id NUMBER;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27926: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27927: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27928: l_version_label VARCHAR2(30);
27929: l_version_label_rec csi_datastructures_pub.version_label_rec;
27930: l_obj_id NUMBER;
27931: --
28176: l_instance_asset_query_rec.fa_asset_id := FND_API.G_MISS_NUM;
28177: l_instance_asset_query_rec.fa_book_type_code := FND_API.G_MISS_CHAR;
28178: l_instance_asset_query_rec.fa_location_id := FND_API.G_MISS_NUM;
28179: l_instance_asset_query_rec.update_status := FND_API.G_MISS_CHAR;
28180: csi_asset_pvt.get_instance_assets
28181: ( p_api_version => p_api_version
28182: ,p_commit => p_commit
28183: ,p_init_msg_list => p_init_msg_list
28184: ,p_validation_level => p_validation_level
29264: l_asset_tbl(tab_row).ACTIVE_START_DATE := FND_API.G_MISS_DATE;
29265: l_asset_tbl(tab_row).ACTIVE_END_DATE := FND_API.G_MISS_DATE;
29266: -- Trap the row in a record and create assets row by row
29267: l_instance_asset_rec := l_asset_tbl(tab_row);
29268: csi_asset_pvt.create_instance_asset
29269: ( p_api_version => p_api_version
29270: ,p_commit => p_commit
29271: ,p_init_msg_list => p_init_msg_list
29272: ,p_validation_level => p_validation_level
32769: l_map_count NUMBER := 0;
32770: l_rel_count NUMBER := 0;
32771: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32772: l_par_vld_organization_id NUMBER;
32773: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32774: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32777: l_version_label VARCHAR2(30);
32770: l_rel_count NUMBER := 0;
32771: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32772: l_par_vld_organization_id NUMBER;
32773: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32774: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32777: l_version_label VARCHAR2(30);
32778: l_version_label_rec csi_datastructures_pub.version_label_rec;
32771: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32772: l_par_vld_organization_id NUMBER;
32773: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32774: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32777: l_version_label VARCHAR2(30);
32778: l_version_label_rec csi_datastructures_pub.version_label_rec;
32779: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32772: l_par_vld_organization_id NUMBER;
32773: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32774: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32777: l_version_label VARCHAR2(30);
32778: l_version_label_rec csi_datastructures_pub.version_label_rec;
32779: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32780: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
33044: l_instance_asset_query_rec.fa_asset_id := FND_API.G_MISS_NUM;
33045: l_instance_asset_query_rec.fa_book_type_code := FND_API.G_MISS_CHAR;
33046: l_instance_asset_query_rec.fa_location_id := FND_API.G_MISS_NUM;
33047: l_instance_asset_query_rec.update_status := FND_API.G_MISS_CHAR;
33048: csi_asset_pvt.get_instance_assets
33049: ( p_api_version => p_api_version
33050: ,p_commit => p_commit
33051: ,p_init_msg_list => p_init_msg_list
33052: ,p_validation_level => p_validation_level
34077: l_asset_tbl(tab_row).ACTIVE_START_DATE := FND_API.G_MISS_DATE;
34078: l_asset_tbl(tab_row).ACTIVE_END_DATE := FND_API.G_MISS_DATE;
34079: -- Trap the row in a record and create assets row by row
34080: l_instance_asset_rec := l_asset_tbl(tab_row);
34081: csi_asset_pvt.create_instance_asset
34082: ( p_api_version => p_api_version
34083: ,p_commit => p_commit
34084: ,p_init_msg_list => p_init_msg_list
34085: ,p_validation_level => p_validation_level